DSXchange

After removing DB2CMD I'm getting below message ..

EST #1
*******

Arg1 =

Test completed.

returned status 8 and screen output "DB21061E Command line environment not initialized.> ".

Result = DB21061E Command line environment not initialized.

Hi I got following output after adding CALL DSLogWarn('Command "':DB2Cmd1:'" returned status ':ErrCode:' and screen output "':ScreenOutput:'".','') TEST #1 ******* Arg1 = Test completed. DSLogWarn called from : Message to be logged is... > Command "db2cmd; db2 connect to tar...

Hi I got following output after adding CALL DSLogWarn('Command "':DB2Cmd1:'" returned status ':ErrCode:' and screen output "':ScreenOutput:'".','') TEST #1 ******* Arg1 = Test completed. DSLogWarn called from : Message to be logged is... > Command "db2cmd; db2 connect to tar...

I'm getting 0 for ErrorCode value, and after adding below line

I'm getting below Test output

TEST #1
*******

Arg1 =

Test completed.

DSLogWarn called from :
Message to be logged is...
>

Result =


Let me know what needs to be modified ...

Hi Brad, Everything is fine with the job but still I am not able to understand why DS is showing such an error or dont know if its the default behaviour of DS. But I am able to find a work around. I guess its more to do with Orchestrate interface optimisation when using parallel Enterprise DB Stages...

Hi, I guess its one more day that I found DataStage acting wierd. I have a simple job, S.F ---> SPRSE LOOKUP ----> CPY ---2 out links---> Two Db2 Upserts and the fatal error it gives is db2Upsert: When preparing operator: When binding partitioner interface: Could not find input field "arr_id_ap...

Hi,

I am facing the same problem. Iguess Db2/UDB load stage does not work properly in 7.5.1

This is still open. I am just wondering if the CDC & A stages can be used, but in CDC I am not able to propogae columns of Before dataset. Any other stages, that avoids transformer

Hi, Is there a single stage in DS that performs the same actions as of Oracle Merge. Basically, I have two input datastreams and one output stream and I have to perfrom a LEFTOUTER join, but I dont want to use a downstream transformer for the logic ( If NUll(reference.value) then out.value = primary...

Yes, it is the same job. The one exported and imported from prod to dev. The config file is also the same. Only the user id used to run the job and connection parameters to database are different in both the evnvironments. And as i said, it used to work fine until yesterday. And also the above error...

Yes.

Use the string functions Alpha and Num in the transformer.

I face a problem in DS 7.5.1 , which i can think of has no solution and DS is just crazy. I have a simple job Seq File Read ---> REM DUP ---> DB2 UPSERT ( with a reject link ). I get the follwing error when I run the job, the stage is output reject stage. Basically the output reject stage is not abl...

You might probably be interested in getting the count from the command line utility, if you want to use the counts for file balancing.

Use dsjob -linkinfo <project> <job> <stage> <link> to get the link count

You might probably be interested in getting the count from the command line utility, if you want to use the counts for file balancing.

Use dsjob -linkinfo <project> <job> <stage> <link> to get the link count

Use substring in input column