Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
The iQuery.obj_exports() UDTF returns one row for each Procedure or Field that is exported from the specified *SRVPGM or *MODULE object.
Parameters
iQuery.obj_exports( library-name, object-name, object-type )
The library-name is the name of the library that contains the object specified on the second parameter.
The file-name is the name of the object whose exports are returned.
The object-type can be *MODULE, *SRVPGM or *ALL. If not specified, the default is *ALL.
Column | Type | Description |
OBJNAME | varchar(10) | The name of the object whose exports have been extracted. |
OBJLIB | varchar(10) | The library name of the object whose exports have been extracted. |
OBJTYPE | varchar(10) | The Object Type of the object whose exports have been extracted. |
EXPORTNAME | varchar(2048) | The name of the exported item. Exported names are usually 128 characters or less except for C++ obfuscated exports. So in typically scenarios this column can be cast to varchar(128) safely. |
The following creates a list of all exported items from the COZSYSLIB *SRVPGM in the iQUERY library.
select * from table(iquery.obj_exports('IQUERY','COZSYSLIB')) exports;
An excerpt from the output follows:
OBJNAME OBJLIB OBJTYPE EXPORTNAME
COZSYSLIB IQUERY *SRVPGM COZZI_getOSVER
COZSYSLIB IQUERY *SRVPGM COZZI_getOSVRM
COZSYSLIB IQUERY *SRVPGM COZZI_getOSVERSION
COZSYSLIB IQUERY *SRVPGM COZZI_getSysName
COZSYSLIB IQUERY *SRVPGM COZZI_getSrlNbr
COZSYSLIB IQUERY *SRVPGM COZZI_getCPUcount
COZSYSLIB IQUERY *SRVPGM COZZI_fscan
COZSYSLIB IQUERY *SRVPGM COZZI_fscani
COZSYSLIB IQUERY *SRVPGM COZZI_fReplace
COZSYSLIB IQUERY *SRVPGM COZZI_fReplacePad
COZSYSLIB IQUERY *SRVPGM COZZI_fscanReplace
COZSYSLIB IQUERY *SRVPGM COZZI_fscanReplacePad
COZSYSLIB IQUERY *SRVPGM COZZI_fscaniReplace
COZSYSLIB IQUERY *SRVPGM COZZI_fscaniReplacePad
COZSYSLIB IQUERY *SRVPGM COZZI_crtusrspace
COZSYSLIB IQUERY *SRVPGM COZZI_crtusrspaceEx
COZSYSLIB IQUERY *SRVPGM COZZI_cpyusrspace