DSXchange

Stop praising and applauding. Which part of Ray's answer did you not understand? What approach have you tried so far? What results did you get?

Think you are using a different configuration files when creating the FileSet and reading it. Use the configuration file that was used for creating the fileset in the job.

If in.Col[1,1] = "-" Then "-" : Right("000000" : trim(InLink.QT), 5) Else Right("000000" : InLink.QT, 6) . I am not sure of the trim syntax. You will have to trim the leading "-" sign. Use online help for that.

Can you identify the 3rd record? See what exactly is coming into the Join Stage. Maybe a copy, filter and a peek stage on each link would do. And how are you handling the null in the key field (Since you mentioned TRIM and NULL)?

Looks like a partition problem to me. What partition have you used? Use hash partition on key fields on both links to the join.

Are you changing the metadata of the field "inputData.STATUS_ID" in the job with the RCP on? If yes switch off RCP in the stage where you have modified the field and run the job.

Where is this error coming? in the sequence log or job log? Any other warnings/errors? Also check the variable values for each run from the log. Do you see any difference?

Generally an entire partition is used on the reference link and the main link is left to auto. No warnings in the log (i am guessing) could be because your key fields are different from the lookup keys.

Probably due to duplicates in the reference data. Remove the duplicates in the reference link on the lookup keys.

the select statment may be invalid"

Is the select query the same in both the server job and the parallel job? Paste the query here.

I heard that the pivot stage in V8 can do the vertical pivot. You might want to take a look at that. Or do a search here on "Vertical pivot".

Routines is your best option. In the online help of DataStage, search for sub routines that start with DS.

Passwords are encrypted in the file. You cannot directly read from the file. Other variables values Yes, passwords No.

Without posting the error message you will not get any answer. Copy paste the exact error message you got here.

Do a search on "Vertical pivot". There is transformer logic as well, in those posts. You would have to customize it for your needs.