DSXchange

eph

And by the way, your code is the exact opposite of mine, inverted then&else and inverted internal logic, which is why it is also valid logic-wise.

Eric

eph

Hi,

You have in the bulk load options a "Allow concurrent load sessions" that allow you to run the stage in parallel. I suppose it also allows the behavior that you describe (no locks?)?

Eric

eph

Hi,

Use a transformer and variables to retain the previous value for compare :
Hash Partition & Sort on your input column
sv1=input column
sv2=if sv1<>sv3 then 1 else sv2+1 (default value 0)
sv3=input column

sv2 will give you the desired value

It is a classical design in DS

Eric

eph

Hi,

You can count the number of separators for each line and determine if it is ok or not.

Eric

eph

Hi,

Maybe you need to make the echo command interpret the \n character as well?

Code: Select all

$ echo "\n"
\n
$ echo -e "\n"
<blank line>

Eric

eph

It purely depends on how you build your schema files. Manually? Automatically? Using a Unix script? An excel macro? Then you can build something like <schema file name 1>|<modify spec> <schema file name 2>|<modify spec> Then with a command like below retrieve the modify spec and use it calling the j...

eph

Hi,

You could create a configuration file at the same time you create the schema file. This way, you can parse your configuration before calling the job, sending the right modification spec.

Eric

eph

Hi,

Sorry, IBM gave me that information in a PMR and I can't find out where is the associated technote.

Here is a technote talking about the same problem : http://www-01.ibm.com/support/docview.w ... wg21472651

Eric

eph

Hi, I believe that you can use the sql below : TO_CHAR ( (TO_TIMESTAMP_TZ ('1970-01-01 Europe/London', 'yyyy-mm-dd tzr') + NUMTODSINTERVAL ( B.LOCKED_AT / 1000, 'second' )) + 2 / 24, 'DD/MM/YYYY HH24:MI:SS' ) Eric

eph

Hi,

I've been through this error some time ago, fixed it with setting following variables :
- APT_DISABLE_FASTALLOC=1 (APAR JR33194)
- MALLOC_CHECK_=0

If it's not working, I suggest you to contact your official support provider.

Eric

eph

Hi, I've seen this : ##I IIS-DSEE-TBLD-00079 15:37:13(010) <transform> Error when checking composite operator: /usr/vacpp/bin/xlC_r which make me think that you are using a gcc compiled object on a non-gcc environment (linux=>AIX?). Your compilator and your compilation options should match DS server...

eph

You are right, I really need to fix that 2days long headache.... Deepest apologies

Eric

eph

That's strange, according to this technote, the env variable should work on all DS versions : http://www-01.ibm.com/support/docview.w ... wg21586920

Eric

eph

Hi,

You may try the APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS environment variable (ibm doc).

Eric

eph

Hi, You don't necessarily need to have partitioned tables to use a partitioned read method. For Oracle, see http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.conn.oracon.usage.doc%2Ftopics%2Fsuppt_partition_reads.html For DB2, you have 3 partitioning methods, a mo...

Search found 111 matches