We found this information after much experimentation. The last modified time of a SQL program shows when it was last SQL-compiled - it does not reflect when the source language program was actually compiled. (The opposite is also true: the Binder timestamp does not reflect when the SQL-compile was performed but this information is much less important.) We ran into some problems where the wrong version of a program was used, but it was not possible to tell this from the last modified time information. Using the Binder you can obtain the date and time of both the source language compilation and the SQL-compilation.
To show the source language compilation time, issue the following command:
BIND SHOW SET TIMESTAMP FROM object
To determine the SQL-compilation time, use the following undocumented option of the Binder's INFO INCLUDE command:
BIND FILE object; INFO INCLUDE SQL_OBJ SQL-OBJECT, DETAIL
No comments:
Post a Comment