DSXchange

Either in a user activity of the calling sequence or in the Job Control section of the second job add some lines to get the number of rows that went down that exception link from the last run of job 1, if that is greater than 0 then either don't start the second job or (if you decide to put it in th...

Why not make sure that any rejected records trigger a warning. Start both jobs in a sequence but make the second one dependant upon the first one not generating warnings.

guarav - the original post states that words cannot be split, which is what doing a straight substring extraction would do.

"REJECTED" verb or word? In which stage? There is a 'Rejected' attribute for output links on databse writes, but I'm not sure if this is what you mean as it doesn't exist in server jobs.

will give the position of the last space before position 35. Assign from position 1 to this number to the first output string, then repeat (in stage variables) for the following 3.

The stage variable and constraint method is identical in PX transformers, so you can do it exactly as you would in Server jobs.

The FOR-NEXT loop is not available in Server transform stages.

Please explain what you are trying to loop in a stage and someone might be able to think of a way to do this.

I can't recall where the location defaults to, it will be either in the project directory or under the Oracle dir. I'd simply use the UNIX find command to locate it.

Yes, you should make sure that no job goes into production with warnings. This applies to both Server and PX jobs. Some PX warnings cannot be removed in the job design, so they should be demoted to informational by message handlers at runtime. This ensures that any real warnings are detected in prod...

sparth wrote:...Disable RCP in DataStage administrator...

I'm not sure if that is sufficient for existing jobs. Go into the stages leading into the join stage and on their output column pages explicitly turn off RCP.

g_rkrish - if you have an NFS mount all you need to do is the wait-for-file activity. no more, no less. No need for ftp or rcp or an rsh.

An NFS mount will look like a local directory, i.e. it will have a path starting at your local root directory - for instance '/usr/arndw/mounts/NSApasswordDirectory' could be a remote mount

Ray - I missed that that it was the first post. Mah - I'm sorry sorry about being so harsh, but the FAQs that are recommended reading plus many other posts from members here recommend using descriptive subject lines and posting in the appropriate forums. Plus, the use of the recommended search funct...

Right, do not use the DS FTP stage if you aren't converting the file line-by-line. Since it seems you've already used FTP I would stay with that approach; use the EBCDIC() function on the COMP-3 columns to reconvert them to their original binary image and then use the sdk kit routines to make them i...

Even though the job types look similar on the Designer canvas and contain many shared stage types you need to realize that they are based on completely different technologies and that an efficient approach on one job type will not necessarily be efficient in another. Server jobs do most of their wor...