DSXchange

Thanks Craig and ArndW. ArndW, My jobname is "Test1" and I have added following code to my routine. IF DSGetJobInfo(DSJ.ME,DS.JOBNAME)= 'MyJobName' THEN JobHandle = DSJ.ME ELSE JobHandle = DSAttachJob('Test1',DSJ.ERRNONE) It still gets stuck for 1800 seconds before aborting. Is there some...

As Craig has already intimated, the "Before Job" should actually be called "In the Job, but before the stages start executing". It is a known (and irksome) limitation of DSAttachJob that one cannot attach to oneself. I tend to use something along the lines of the the following co...

BASIC Code wrote:Oconv(Iconv(InLink.TheDate, "DMDY"), "D-YMD[4,2,2]")

PX Transformer Code wrote:DateToString(StringToDate(InLink.TheDate,"%mm-%dd-%yyyy"),"%yyyy-%mm-%dd")

India2000 wrote:SC2_1..Sequential_File_0.DSLink39: nls_read_delimited() - row 18, column CustName, required column missing
...

This doesn't apply to a database or to record deletion. It is a simple sequential file format error.

Try using MSQUERY or another tool to access the sheet via ODBC. If the error is the same then that takes DataStage out of the equation.

Suman - the link that kwwiliiams put in his post documents that you need more than just INSERT privileges in order to do a load.

(note - you have two different questions with the same topic, this can lead to confusion) When you read from a DB2 stage the column attributes come from the database, not from the DB2 stage column settings. Turn on "APT_PRINT_SCHEMAS" to confirm this. the INTERNET_ORDERN_NBR column in DB2 ...

Is "session_key" declared in the dataset and passed into the stage? Did you declare "session_key" in the DB2 stage columns and then not use it in your insert or update statements?

The only way to see Ray's complete post is become a premier member. But he has already given you the approach in the visible part of his response. You need to determine which step is the blocking one. Replace your output DB2 with a peek - has the speed changed?

With BLOBs that big I would use the bulk loader.

Use a sort stage to sort your incoming data on KEY and create a key change column. In the subsequent transform change, output all records where the key change column is true to the DB "INSERT" link and the others to the DB "UPDATE" link. Both DB stage should have the appropriate ...

The error has nothing to do with deletion or hashed files. You are reading a sequential file and, at the 18th row, your sequential file format is not correct.

It sounds like you need to bind the library. Is this the first time you have used DB2 on this installation or was this something that had already worked in the past?

What is "hello.o" and does it exist?

##W TBLD 000000 12:53:10(003) <main_program> Error when checking composite operator: Output from subprocess: ld: fatal: file /mdw/dvl/tgt/scripts/shells/hello.o: open failed: No such file or directory

Perhaps the logs that you can't see right now were created when the RT/ORlogging settings were different from the current ones. If you re-run or reset one of those jobs does the log contain new entries?