DSXchange

OK, try setting the Null Field Value property to "".

Search the forum. DSGuru2B published a parallel function that mimics the Ereplace() function from server jobs.

If the column has an identity property, you provide the remainder of the row from DataStage - you do not provide anything (though some databases allow you to provide 0) for the identity column.

Welcome aboard. Please advise what the settings are on the Format tab of your Sequential File stage.

... and it's hashed file, not hash file.

If you delete the hashed file all information associated with it is lost. You must make your own arrangements if you need separate storage of these tuning parameters.

If you have MKS Toolkit, CygWin, or some other UNIX emulator, you could use a UNIX command such as uniq or sort -u to de-duplicate your data. If you have version 7.5x2, you get MKS Toolkit installled with it.

Code 80012 might also be seen if TCP port number 31538 is blocked by a firewall.

Maybe you could also use dsjob -linkinfo, with a lot of preliminary mucking about to determine the stage name and link name.

Unless you delete the orphaned files (DS.CHECKER) you will not be able to create a new job number 1.

To delete all jobs in the project the simplest method is to delete the project, then re-create it in the same location.

Welcome aboard.

Given how new version 8 is, I don't think you'll find anyone who has done this particular upgrade. In theory it ought to be reasonably transparent. However check with your support provider - who may advise upgrading to 7.5 first.

Can you please elaborate on how you are attempting to compare two datasets using DataStage TX?

Create a job that has this property set, and inspect the generated OSH or the score. This will show how to do it.

Select the first row from the table. If it's not there, there are 0 rows.

Try selecting just the first row from the table.