- 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.mchinfo - UDTF
Published by: Bob Cozzi on 18 Jun 2019 view comments
Retrieve System ("Machine") Information
The iQuery.mchInfo() UDTF returns a one row result that contains the machine type, model number, processor group, system serial number system name and other information often needed for software licensing or hardware support.
| UDF | Return Type | Description |
| mchInfo | TABLE | Returns a list of system related information. |
Parameters
This UDTF has no parameters.
Result Set Columns
| Column | Type | Description |
| MCHTYPE | varchar(4) | The machine type, such as 8202 or 9009 |
| MODEL | varchar(4) | The system model number--similar to the QMODEL system value. |
| PROCGROUP | varchar(4) | The processor group, e.g., P05, P10, P20, etc. |
| FEATURE | varchar(4) | The Feature code of the system, such as EPCK, EP10 |
| SRLNBR | varchar(10) | The system serial number. |
| SYSNAME | varchar(8) | The system name. |
| CPUCOUNT | int | The number of active CORES. |
| VRM | varchar(6) | The IBM i OS version and release in text form, VxRyMz format. e.g. V7R4M0 |
| VER | dec(7,2) | The IBM i OS version and release in numeric form, e.g., 7.40 |
Example
select * from table (iQuery.mchInfo( )) mi;
The output from the above UDTF is a 1-row resultSet similar to the following:
MCHTYPE MODEL PROCGROUP FEATURE SRLNBR SYSNAME CPUCOUNT VRM VER
8202 E4D P05 EPCK 10-xxxxx IQUERY3 4 V7R3M0 7.30