- SQL iQuery - RUNiQRY CL Command
- CSV() - Read and Parse Comma Separated Values File
- CSV_VAL() Extract CSV Column Value
- CSV_XXXX() Extract CSV Column Value as xxxx
- CSV_COUNT - Retrieve Field Count
- ObjExist - Check Object Exits
- DTAARA - Data Area
- encode_URL Encode URL for the Web
- encode_TAG Encode HTML TAG Content
- FLDLIST - List the Fields of a Table
- FROMHEX - Fold 2-hex Chars into 1 Char
- GET CPUCNT, CURLIB, ENV, SRLNBR, SYSNAME
- MD5_HASH - UDF - Return MD5 Hash
- ifsStat - Get IFS File Attributes
- ifsExists - Check if IFS File Exists
- ifsFile - Query Contents of IFS Text File
- ifsDIR - List IFS Directory Entires
- DEPFILE - List Dependent Database Relations
- JOB - Get Job Name Component
- Job_ATTR - Job Attributes
- JOB_DATE Retrieve the Job Date
- JOBLOG - Write Message to Joblog
- Library List UDF and Procedures
- MBRLIST - Member List
- MCHINFO Machine Type and Model Number and OS version
- OSVER and OSVRM Get IBM i Version/Release
- PrintPDF - Print a PDF to a PDF Compatible Printer
- CPYTOPDF - Copy SPOOLED File to PDF file
- OBJ_LIST List Object in a Library
- LIB_LIST List Descriptions of Libraries on the Library List
- OBJ_EXPORTS List Exported Items from an Object
- OBJ_STRUCT Retrieve Objects Components
- RTVCMDD Retrieve Command Definition
- RTVJOBA - Retrieve Job Attributes
- RTVJOBD - Retrieve Job Description
- RTVLASTSPLF - Retrieve ID of Last SPOOLED File for this Job
- RTVxxx - Retrieve Various Objects Description Table Functions
- WATCHLIST - List Current Watches
- Polymorphic Qualified Name Syntax
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.
iQuery.getSysName and other GETxxx UTF
Published by: Bob Cozzi on 14 Jun 2019 view comments
Retrieve System Information UDF
The various iQuery.GETxxx() UDF return system information as a varchar or integer value.
| UDF | Return Type | Description |
| GETCPUCOUNT | integer | Returns the number of CPU CORES installed on the system. |
| GETCURLIB | varchar(10) | Returns the current library from the library list. |
| GETSRLNBR | varchar(10) | Returns the System Serial Number. Similar to RTVSYSVAL SYSVAL(QSRLNBR) |
| GETSYSNAME | varchar(10) | Returns the System Name. Similar to RTVNETA SYSNAME(&SYSNAME) |
| GETENV | varchar(32739) | Returns the value of an Environment Variable |
With the exception of GETENV(), these UDFs have no input parameter.
GETENV() Parameters
| Parameter | Type | Description |
| Environment Variable Name | varchar(256) | The name of the environment variable whose value is to be returned. |
The GETENV() UTF runs the getenv() API to return the environment value. This API is case-sensitive, therefore the iQuery GETENV() UDF input value is also case sensitive. getenv('java_Home') is not the same as getenv('JAVA_HOME').
The following examples assume the host variables are already declared unless SQL iQuery Script is being used, in which case host variables are auto-created.
Example
values iQuery.getCPUcount() INTO :cores;
values iQuery.getCurLib() INTO :myCURLIB;
values iQuery.getSRLNBR() INTO :SRLNBR;
values iQuery.getSysName() INTO :SysName;
values iQuery.getEnv('JAVA_HOME') INTO :classPath;