DSXchange

Write a small script which deletes the '0x00' character or replaces it with '0x20' as Ray pointed. Then use this script as a pre-processing step for the job (You can call it from the before job routine).

I would strongly recommend you to attend a training session if you can. This would help you a lot with the understanding Datastage parallel edition. And also, Try to test the things you learn by testing them out by creating dummy jobs, that's the best way to learn. If I were you, I would spend atlea...

Ray, I think the OP has put the post in the wrong forum, It is supposed to be in Datastage Parallel forum.

Does the certification require prior experience with all databases to clear? I have worked only with SQL, Sybase, Oracle and DB2/UDB- never got my hands on Teradata,SAS,Informix or DB2/z\OS editions. You are in luck, you just have to read the datastage documentation for the rest of the databases :w...

When you say you want to start a job (say 'X') from a sequence(say 'Seq_A'). You can do this only when your job ('X') is a sequence. So, you can call a sequence or a job from a sequence. But, Datastage doesn't have any stage (in server or parallel edition) which will call a job from a Parallel/serve...

Yes, To be able to change the transaction size i.e. the commit interval, you will have to add this environment variable in the job parameters.

Hi We have jobs ,Where we need to LookUp on either DataSets or LookUpFileSets.And data to be processed is more than 40 lakhs Which would be better Data Sets or Look Up FileSets.PLease suggest and why? If I had to choose between Lookup fileset and a Dataset, the first thing I would see was the numbe...

The only advantage you have with "Lookup Filesets" is that the lookup tables are created when you create the lookup filesets. But, when you do a lookup against a file,dataset or a database(Normal lookup) The lookup tables are created during the execution of the job. So, Lookup filesets wou...

Cool, Time to mark the post as "Resolved" then

Congratulations :D

Are you using :1, :2 for bind variables?
You are not supposed to use these.

In PX the bind variables can be used by putting ORCHESTRATE.<column_name> instead of your bind variables.

That was a good one

A few parameters have to be setup properly before you can use orchadmin.

set your $APT_CONFIG_FILE to the absolute path of your configuration file and $APT_ORCHHOME to the PXEngine directory of Datastage and try this command again.

I am not a pro at server jobs, But let me give it a shot. If you think about it, Even with the Pipeline paralleism in place for your two transformers, The rows are going to be processed by Transformer1 and then by Transformer2 in a sequential fashion. And you can always put the logic of two consecut...

Try replacing the DB2 API stage with a row generator stage. This will filter out other possibilities for this behavior.

Also, how may records do you expect for your query?