DSXchange

You didn't say what version of DB2 you're using but in DB2 LUW you should be able to specify an EXCEPTION table to capture rows that are not loaded (because they are duplicates for example). (Or in DB2 z/OS you can specify a DISCARD file which captures rows which are not loaded) You would need anoth...

Also, you can't use the DB2 API stage as a 'sparse' lookup and it can't have a reject link.

The ODBC Enterprise stage doesn't have those limitations :D

Found out that a script called OshRemote.sh is written to the appropriate RT_SCxxx project directory on the DataStage server. This script contains the rsh command to run the job. The target hostname for the rsh command is in there. You have to recompile to regenerate this script. (Or you can edit th...

You could try adding user defined variables: I'm not too sure if they will help. They let us see the load instructions sent when loading DB2 z/os tables, don't know about DB2 UDB. Worth a try?

In DS 7.5 the "truncate" option makes the DB2 Enterprise stage use "LOAD REPLACE" so there is no "delete from..." statement issued. You can specify if the load of the new data is logged through the "Load with logging" option in the DB2 Enterprise stage. (Presu...

We have a project configured for remote deployment of parallel jobs (through the "Remote" tab in Administrator). We're deploying jobs to USS on a mainframe. In development I'd like to be able to run parallel jobs on a different lpar on the mainframe from time to time. (for example we norma...

I know this thread is a few months old but thought I'd post what I have found out, having come up against a very similar issue. IBM support told me: when using the diff operator values from duplicate field names including key and value fields are copied from the before data set only. They also refer...

If you set the OSH_ECHO environment variable to true you will get a message in the Director log that shows the Orchestrate script for your parallel job. The password for your DB2 stages will appear as plain text (at least it does for me), which might help work out what is being passed when the job i...

Got to the bottom of it, eventually. When I have exported the PxDB2 stage type from my production project, to try to apply it to development, the .dsx file has some missing fields. ... BEGIN DSSUBRECORD Name "operator" Description "Write to INSERT; Load uses fast DB2 loader technology...

Got a problem importing a stage type, the PxDB2. I discovered that the PxDB2 stage in a production project on a production server has extra options when compared to my dev project on the dev server. It looks like a patch was applied to production, but not dev. I've located the patch that delivered t...

OK thanks. I didn't think of using more than two inputs into a join, I might play with that and see how the job behaves. Good to know there isn't a magic bullet hidden away though!

I don't think I've explained myself very well :( . ...Since it is a full outer join, If there is a match then the both the values will be same. If one is null then there wont be a corresponding record from the second stream. Say Leftkey is null, no corresponding value from right stream, so rightkey ...

Sorry, I meant "leftkey" as the key from the left side of the join and "rightkey" as the key from the right side of the join. Left and right being the two inputs to the join. The job is using common keys in all joins so I don't want any rows with null keys at the start of the nex...

Hi there DSXCHANGE :D , Can anyone offer any advice on a job design to perform a n-way outer join? I have a job to build a datamart FACT table using various other tables. It does an 8-way outer join like this: DB2 UDB --> -> JOIN -->XFORM --> DB2 UDB --> > JOIN --> XFORM -- > DB2 UDB --> > JOIN --> ...