Retrieving info about a seq file

gpbarsky · Post by **gpbarsky** » Mon Sep 15, 2008 9:35 am

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.

chulett · Post by **chulett** » Mon Sep 15, 2008 9:51 am

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.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 15, 2008 3:49 pm

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.

chulett · Post by **chulett** » Mon Sep 15, 2008 4:14 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 15, 2008 5:11 pm

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.

chulett · Post by **chulett** » Mon Sep 15, 2008 5:26 pm

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?

ray.wurlod · Post by **ray.wurlod** » Mon Sep 15, 2008 8:20 pm

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

gpbarsky · Post by **gpbarsky** » Tue Sep 16, 2008 11:58 am

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

Thanks to everyone.

:D