DSXchange

Hi.

I need to retrieve the creation date and the last modification date of a sequential file.

I didn't find if FILEINFO or STATUS functions can retrieve these values.

Is there any other function to get the creation date and the last modification date of a seq file ?

Thanks in advance.

I believe you'll need to fall back to the O/S for that. For Windows, perhaps a 'dir' with the '/tc' and then the '/tw' option, parsing the results.

The STATUS statement will retrieve date and time created, modified and last accessed, and 25 other pieces of information about a sequential file.

Note that I refer specifically to the STATUS statement here, not the Status() function. Check the DataStage BASIC manual for full details. Dates and times returned are in DataStage internal format.

Hmmm... I went through the BASIC manual before I replied for both FILEINFO and STATUS but didn't see that. Guess I need to look again.

Page 6-560 in the manual for version 7.1, page 6-561 in the manual for version 7.5, page 6-561 in the manual for 8.0.

OK, not sure why I missed them. Found the last access and modification date and time fields, 13 thru 16. There's also field 17 for 'Time and date of last status change' that states it is the creation date on Windows NT, out of curiousity where is the UNIX creation date retrieved?

This seems to be the date/time created unless permissions have been changed.

Finally, I could find the page where the STAUS fields are explained.

Thanks to everyone.

:D