Create QTEMP/ZSYSP as ( SELECT SUBSTR(HOST_NAME, 1, 8) AS SYSNAM, PARTITION_ID AS NUMPAR, NUMBER_OF_PARTITIONS AS TOTPAR, CAST(SUBSTR(PARTITION_NAME, 1, 15) AS CHAR(15)) AS PARNAM, SERIAL_NUMBER AS SERIAL, MACHINE_TYPE CONCAT MACHINE_MODEL AS MODEL, &ALSYNM AS ALSYNM FROM QSYS2.SYSTEM_STATUS_INFO ) With DATA