TACL Reference Manual

Built-In Functions and Variables
HP NonStop TACL Reference Manual—429513-018
9-173
#FILEINFO Built-In Function
INCOMPLETESQLDDL
returns -1 if the file exists and an SQL DDL operation is currently in progress.
Otherwise, it returns 0.
INDEXCOMPRESSION
returns -1 if the file exists, is key-sequenced, and uses index compression;
otherwise, it returns 0.
LASTOPEN_GMT
returns the time and date when the file was last opened, expressed as a four-
word timestamp. (If the file does not exist, or has not been opened since before
the B20 software RVU, this option returns 0.)
LICENSED
returns -1 if the file exists and is licensed; otherwise, it returns 0.
MAXBYTES
returns the maximum number of bytes configured for the file (0, if the file does
not exist).
MAXEXTENTS
returns the maximum number of file extents configured for the file (0, if the file
does not exist).
MODIFICATION
returns the numeric modification date (a three-word timestamp); if the file does
not exist, this option returns 0.
When a file is copied from one system to another system in a different time
zone without modifying the source date of the file, the MODIFICATION option
returns the file modification time as the local civil time of the system from which
the file was copied.
MODIFICATION_LCT
returns the time and date when the file was last modified, expressed as a four-
word timestamp. The time is expressed in the local civil time (LCT) of the
system on which the file resides. If the file does not exist, returns 0.
When a file is copied from one system to another system in a different time
zone without modifying the source date of the file, the MODIFICATION_LCT
option returns a timestamp that shows the file modification time as the local
civil time of the system to which the file was copied.