DSXchange

ray.wurlod wrote:Have the file land in a particular folder. In a sequence use a DIR /B command to get the file name and feed it to your job. Move the file to a different folder when done. ...

Thanks it worked...

Hello All,


I have a situation where a file comes everyday with the name
"20101023000004_Sample_File" ....
File schedule for everyday
So the file name changes everyday... How to approach this issue...

Help appreciated...
Ravi.

If any job aborts in sequencer, I need the job report in the mail why it has been aborted.. can i use the #Exception_Handler.$ErrMessage#..If so ..how can i capture the message..
help appreciated..

Thanks.
Ravi.

Oconv worked.. Thanks bro.

when i try to use this Field(SRC_JOINING_DT,' ',2) it is giving me NULL.
It is not returning any value..

Hello All

I am reading a field name JOINING_DT from DB2 as
"12167 (2001-04-23)"
JOINING_DT datatype is Date.
I need to convert to the above format to MMDDYYYY.
When i tried to use the field and extract the date part it is giving me NULL.

Thanks in advance

Hello everyone, In a sequencer.. there are 7 jobs... after running for 3 jobs..the 4th job fails ....but its continuing till the end of the sequencer.... i have given the setting as jobstatus=DSRUNOK or jobstatus=DSRUNWARN. and an exception handler to email that the job is aborted.. how to terminate...

ray.wurlod wrote:I have provided everything you need except the If..Then..Else construct. ...

Thanks it worked...

The Senario is i need to convert the timestamp to MMDDYYYY and check the YYYY is numeric or not
If numeric send MMDDYYYY else send space
... to a seqential file...which in turn used to load into warehouse..

how to convert the timestamp to date..
Need to convert "2008-10-21 13:14:44.997187" to the format MMDDYYYY
and then check whether yyyy is numeric or not...

thanks for the speedy response..


Actually i need to convert the above timestamp format to mmddyyyy..
then i need to compare whether the yyyy is numeric or not...

Hello all,

I have a timestamp coming as" 2008-10-21 13:14:44.997187"

need to check that 2008 is numeric or not...


Please help me..