News
Abstract
The GET_JOB_INFO table function returns one row containing the information about a specific job.
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > QSYS2.GET_JOB_INFO()
For complete detail, visit this IBM Knowledge Center page: GET_JOB_INFO table function
Enhanced with IBM i 7.4 base release and IBM i 7.3 SF99703 Level 15
V_ACTIVE_JOB_TYPE and V_AUTHORIZATION_NAME were added to the UDTF result table
Enhanced with IBM i 7.3 SF99703 Level 3 and IBM i 7.2 SF99702 Level 14
V_PJ_REUSE_COUNT and V_PJ_MAXUSE_COUNT were added to the UDTF result table
Enhanced in IBM i 7.2 TR3:
V_CLIENT_IP_ADDRESS column was added to the UDTF result table
Enhanced in IBM i 7.2 TR2:
V_SQL_STMT_STATUS, V_SQL_STMT_START_TIME & V_QUERY_OPTIONS_LIB_NAME columns added to the UDTF result table
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
05 January 2020
UID
ibm11128591