Hello everyone,

I hope if anyone could help me find a way to know the date and time of the compilation of a routine compiled by EB.COMPILE, since I cannot rely on the UNIX file system attributes for the object file creation and modification dates due to copies and movements of files from one location to another.

In other words, is there an object attribute that says when the object was first created? If yes, please help me know how to know that.

Regards

T24 Version: R07
jBASE Version: 5
Operating System: AIX 5.3

The command is :
jshow -c <routine name>

www.jbase.com/r5/knowledgebase/manuals/3.../man/sup32_JSHOW.htm

Thank you Lior, you have saved the day.

Regards

I think jshow command returns timestamp of last compilation (not sure about jbase 5), maybe you ask wrong question..
If you want to know date and time of first compilation and you have all logs archived you should look in COMO

ls | grep COMPILED.PGM | xargs grep -B 1 name_of_routine

Thanks dajrokan

But the following command has some wrong argument

ls | grep COMPILED.PGM | xargs grep -B 1 name_of_routine

-B 1 before the name_of_route is an invalid argument

Also, the COMPILE.PGM file does save the history per day, meaning if a routine is compiled several times in one day, it will only save the last one. Nonetheless, COMPILE.PGM.* is serialized in a non-uniform sequence, so forth you have to sort it by date.

Hence, this does not show a full history of the compilation of the routine.

Hi
it depends on version of grep command you are using (check for newer version), -B 1 flag prints one line of leading context before matching line, where timestamp was stored. Anyway, you are right. File suffix is a port number and if operator compiled more than one routine under same port, file is rewrited :(

d.

hi,

can any body tell me the procedure for archiving large tables in the database?

regards
LSRao
This e-mail address is being protected from spambots. You need JavaScript enabled to view it