Schema IQUERY
IFSSTAT( path_name => 'IFS file name' )
The IFS Statistics (IFSSTAT) User Defined Table Function returns
one row with the results of the stat64() API for the specified IFS
file.
Return last date/time the file is created along with the file
size and Owner User Profile.
select data_size, owner, crtdta
FROM TABLE( iQuery.IFSSTAT( path_name => '/home/sqlref.pdf' )) stats;
| Column |
Data Type |
Description |
| OBJTYPE |
VARCHAR(10) |
The type of object(s) to be returned. DIR or
STMF is returned. |
| DATA_SIZE |
BIGINT | The size of the object, in bytes. Note, in
RPG IV this would be defined as int(20). In C/C++ it is a
long long variable. |
| ALLOC_SIZE |
BIGINT |
The number of bytes allocated for the file.
This is often larger than the file's data_size as it also
contains the size used by the object itself as well as
rounded up size to allocate future insertions to the file. |
| CCSID |
INT |
The CCSID of the data in the file. |
| LINKS |
BIGINT |
The number of links to this file or zero if
no links exist. |
| OWNER |
VARCHAR(10) | The owner of the IFS object. |
| CRTDTS |
timeStamp | The date the object was created. This is a
timestamp value. |
| ACCDTS |
timeStamp |
The date and time the object was last access
(view, written to, opened). |
| CHGDTS |
timeStamp | The date and time the object definition was
last changed. |
| MODDTS |
timeStamp |
The date and time the data in the object (if
it is a STMF) was changed/modified. |
| AUTH_MODE |
VARCHAR(256) |
The Authorization for the file. For example: S_IRGRP S_IROTH S_IRUSR S_IRWXG S_IRWXO S_IRWXU S_IWGRP S_IWOTH S_IWUSR S_IXGRP S_IXOTH S_IXUSR S_ISREG |
| PATH_NAME |
VARCHAR(2048) |
The fully qualified object name. This column
contains the file name prefixed with the path name. |