Date from File name...

[mallireddibalaji]

Hi,

we are replacing our old system(PROC) by datastage jobs.
In old system, for date field we are getting date from file name itself.
That file name format like this:A01yymmdd0.dat

In our data stage how we can handle this one?


Thanks in advance...

[chulett]

Would need more information on how you are using the date, but basically you can substring the 'yymmdd' portion out of the filename, then use functions to convert it, if need be.