DSXchange

If it is EBCDIC, you may try '0x40' as padchar...

Be sure that you address the 32-bit ORACLE lib, not the 64-bit one, which usually is the default one...

Klaus

It is not possibles with the DB2 Enterprise Stage, since the Enterprise Stage needs a DS runtime on the DB2 machine, which is not supported with this environment.

You need to utilize one of the other connection methods like DB2API or ODBC to access DB2 on AS/400.

Best Regards
Klaus

You may also check which EBCDIC codepage is being used at your host system and then set the environment variable APT_EBCDIC_VERSION accordingly.

Klaus

Hello Shah, be aware that a hash file is a UNIVERSE table - not readable/editable with a simple text file editor. It can be found in the project folder specified in the account name option. If the account name field is left empty (which usually is the case) the hash file ist created in your current ...

Hello Sai, a "parallel shared container" has nothing to do with "allow multiple instance". A shared container is a design element that is incorporated into the job at compile time. "Allow multiple instance" allows you to run the same job several times at once - with a d...

If you're using a sequence anyhow, you don't need a script to achieve this. In the job-activity simply set the "Execution action" to "Reset if required, then run" from the drop down list...

Klaus

What is your question? The message says it all: your source field as VARCHAR may be longer than the target DB2 CHAR field...

You are informed that truncation may occur, i.e. your data may be "corrupted"...

Klaus

In one join stage you can join multiple links on the same keys only. In your case you have to use 2 joins: join A and B on K1 and then repartion, sort and join B and C on K2.

Klaus

Thanks Ray and everybody,

the issue is resolved after is client reinstallation from customer site. I guess it was indeed a directory not being writable.

Klaus

Arnd, Craig,

thanks for your input! A server routine and a server job both do compile and run without any error....

Klaus

I think I have seen this situation before, where just some local file or so needed to get r/w flag being set...

Does anyone remember this kind of issue?

Arnd - I'll try that as well...

Best regards
Klaus

Trying to compile job sequences always returns "INTERNAL COMPILER ERROR", regular jobs (parallel) compile OK.

Any idea on this?

Best regards
Klaus

About the Date conversion you can try this: 1. If you want pre-hawk behaviour then you will have to set DS_NO_FF to 1 at Project level or in the dsenv file. After this both date and timestamp will be imported as timestamp and fractional second is not supported. Same as 7.5.2. 2. If you want fraction...

The DB2 UDB stage does not do bulk loading - please refere to the manual. For bulk loading you have to use the separate db2 bulk load stage.

Best regards
Klaus