DSXchange

I believe DB2 requires date in internal format. Try ICONV(DSJobStartDate,"D-YMD")

use dsn as localuv.

If you want the retrieve the status code of the dsjob command then do as Craig advised. And, if you want to retrieve the status code of the job then add -jobstatus to Craigs advised commands. i.e, dsjob -run -jobstatus blah-blah-blah X=$? exit $X This way you will get a status code of 1 if job is su...

Welcome Aboard Get rid of the 'var' and replace it with input key column. One less stage varialbe Var1 = If in.key = Var2 Then "Cons Double File" Esle "Cons Insert Target" Var2 = Key If you get any key violation, the warning will be created. Thats why you need to explicitly handl...

Try to google 'sgslufread'. See what it retrieves.

Go to your dsenv file in $DSHOME and make a backup copy for it. VI the dsenv file and add the following to SHLIB_PATH SHLIB_PATH=/home/dsadm/Ascential/DataStage/PXEngine/lib:SHLIB_PATH; export SHLIB_PATH save it and then execute it as follows . ./dsenv then try the following $APT_ORCHHOME/bin/dsreco...

The id you are using to log into unix, is that the same id you use to log into datastage?

ok then try this

You can use ICONV/OCONV functions. Search for specific details or look into DataStage help.

I am no dos expert but here is what i found on google. Maybe a batch file expert can throw some more light.

Its a good idea. Search for something like files older than 7 days, and delete them. Search this forum, i think Ray has a piece of code out here to do that.

Welcome Aboard
Use the Int() function.

Try to clear the &PH& folder. See if that helps.

Read this.

what is your job design. What if you replace the IPC stage with sequential file stage or just get rid of the IPC stage?