DSXchange

Hi Meena,
If you are scheduling at 11.59pm for 12.00am, do it for tomorrow and not Today.

Are you gettin all the error at the same time or in same job?
Or is it all just a question to be know?
Have you checked the config file you have. Use the available GUI tool to check you APT_CONFIG file that been used in your server.

Hi Ravish,

Welcome aboard :D !!!
You should be refering DSTX to Datastage TX, one and the same.

Ray - Everytime you give out some new stuff. May I know what 'DET.SUP' used in your query for. Is it to suppress the Description information?

You cannot schedule the job for today at 12:00 am. Unless your current time is 12.00 am. Where the time is alreay passed.
After you press Ok, dont you get any warning or error message?

zam62 - Do you wish to share, how this issue has been resolved?

Change the Char data type to Varchar.
As character Datatype might expect the fixed size character for the defined length. Since you input seems variable length, there is a chance where new line character may come even before the defined length.

Try to trun off the RCP.

This sounds interesting. I ll check whether my site is still convered under maintanance.

Even what I explained doesn't delete but, just skip.

You have the first name as column name property in sequential file. Which will eliminate the first line been read.
You can also achive by just counting the total number of records present in the file, and tail of n-1.

Could see the same value been passed to the Password parameter from the routine that calls the job. You can find this by double clicking the job in director on Status View.

If you dont have any parameters to pass, you can call the procedure from either Before SQL or After SQL, by just CALL ProcedureName;

It may not be easy to pickup the order from exported file. The of execution of jobs can even changed during runtime or the logic that been defined.
But you can parse the output log file and can get the order in which the jobs been executed by that JobSequence.

And if "[" present for all the cases.