News
Abstract
IBM i Services (SQL)
Content
IBM i Service
|
Type of Service | IBM i 7.4 | IBM i 7.3 |
IBM i 7.2
|
Application Services | ||||
QSYS2.BOUND_MODULE_INFO | View | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.BOUND_SRVPGM_INFO | View | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.CLEAR_DATA_QUEUE() | Procedure | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.DATA_AREA_INFO() | Table function | Base | SF99703 Level 15 | Not Supported |
QSYS2.DATA_AREA_INFO | View | Base | SF99703 Level 15 | Not Supported |
QSYS2.DATA_QUEUE_ENTRIES | Table function | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.DATA_QUEUE_INFO | View | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.DB_TRANSACTION_INFO | View |
SF99704 Level 7
Enhanced: SF99704 Level 10
|
SF99703 Level 18
Enhanced: SF99703 Level 22
|
Not Supported |
QSYS2.ENVIRONMENT_VARIABLE_INFO | View | Base | SF99702 Level 11 | |
QSYS2.EXIT_POINT_INFO | View | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.EXIT_PROGRAM_INFO | View | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.PROGRAM_EXPORT_IMPORT_INFO | View | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.PROGRAM_INFO | View | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.QCMDEXC() | Procedure | Base | Base | Base |
QSYS2.RECEIVE_DATA_QUEUE() | Table function | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.SEND_DATA_QUEUE() | Procedure | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.SEND_DATA_QUEUE_BINARY() | Procedure | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.SEND_DATA_QUEUE_UTF8() | Procedure | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.SERVICES_INFO | Table | Base | Base | Introduced: SF99702 Level 11 |
QSYS2.SET_PASE_SHELL_INFO() | Procedure | Base | SF99703 Level 4 | SF99702 Level 16 |
QSYS2.STACK_INFO() | Table function | Base | SF99703 Level 7 | SF99702 Level 19 |
QSYS2.WATCH_DETAIL() | Table function | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.WATCH_INFO | View | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
SYSTOOLS.LPRINTF | Procedure | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
SYSTOOLS.SPLIT() | Table function |
Base
Enhanced: SF99704 Level 10
|
SF99703 Level 15
Enhanced: SF99703 Level 22
|
Not Supported |
Communication Services | ||||
QSYS2.ACTIVE_DB_CONNECTIONS() | Table function | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.ADD_TIME_SERVER() | Procedure | Base | Not Supported | Not Supported |
QSYS2.HTTP_SERVER_INFO | View | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
QSYS2.NETSTAT_INFO | View | Base |
Base Enhanced: SF99703 Level 11 |
SF99702 Level 9 Enhanced: SF99702 Level 11 Enhanced: SF99702 Level 23 |
QSYS2.NETSTAT_INTERFACE_INFO | View | Base | Base |
SF99702 Level 9 Enhanced: SF99702 Level 11 |
QSYS2.NETSTAT_JOB_INFO | View | Base |
Enhanced: SF99703 Level 11 |
SF99702 Level 9 Enhanced: SF99702 Level 11 Enhanced: SF99702 Level 23 |
QSYS2.NETSTAT_ROUTE_INFO | View | Base | Base |
SF99702 Level 9 Enhanced: SF99702 Level 11 |
QSYS2.REMOVE_TIME_SERVER() | Procedure | Base | Not Supported | Not Supported |
QSYS2.SERVER_SBS_CONFIGURATION | View | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.SERVER_SBS_ROUTING | View | Base |
Base |
SF99702 Level 5 Enhanced: SF99702 Level 11 |
QSYS2.SET_SERVER_SBS_ROUTING() | Procedure | Enhanced: SF99704 Level 4 |
Base Enhanced: |
SF99702 Level 5 Enhanced: SF99702 Level 11 |
QSYS2.TCPIP_INFO | View | Base | Base | Base |
QSYS2.TIME_PROTOCOL_INFO | View | Base | Not Supported | Not Supported |
SYSIBMADM.ENV_SYS_INFO | View | Base | Base | Base Enhanced: SF99702 Level 9 |
IFS Services | ||||
QSYS2.IFS_JOB_INFO() | Table function | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.IFS_OBJECT_LOCK_INFO() | Table function | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.IFS_OBJECT_PRIVILEGES() | Table function | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
QSYS2.IFS_OBJECT_REFERENCES_INFO() | Table function | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.IFS_OBJECT_STATISTICS() | Table function | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.IFS_READ() | Table function | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.IFS_READ_BINARY() | Table function | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.IFS_READ_UTF8() | Table function | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.IFS_WRITE | Procedure | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.IFS_WRITE_BINARY | Procedure | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.IFS_WRITE_UTF8 | Procedure | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.SERVER_SHARE_INFO | View | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
Java Services | ||||
QSYS2.JVM_INFO | View | Base | Base | SF99702 Level 5 |
QSYS2.SET_JVM() | Procedure | Base | Base | SF99702 Level 5 |
Journal Services | ||||
QSYS2.DISPLAY_JOURNAL() | Table function |
Base
Enhanced: SF99704 Level 7
Enhanced: SF99704 Level 10
|
Enhanced: SF99703 Level 3 Enhanced: SF99703 Level 7 Enhanced: SF99703 Level 18 Enhanced: SF99703 Level 22 |
Base Enhanced: SF99702 Level 11 Enhanced: SF99702 Level 14 Enhanced: SF99702 Level 19 |
QSYS2.JOURNAL_INFO | View | Base | Base | SF99702 Level 3 |
QSYS2.JOURNALED_OBJECTS | View | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
Librarian Services | ||||
QSYS2.JOURNAL_INHERIT_RULES | View | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.LIBRARY_INFO() | Table function |
SF99704 Level 7
Enhanced: SF99704 Level 10
|
SF99703 Level 18
Enhanced: SF99703 Level 22
|
Not Supported |
QSYS2.LIBRARY_LIST_INFO | View | Base | Base | SF99702 Level 3 |
QSYS2.OBJECT_STATISTICS() | Table function | Enhanced: SF99704 Level 4 |
Base Enhanced: SF99703 Level 3 Enhanced: |
Base Enhanced: SF99702 Level 14 |
Message Handling Services | ||||
QSYS2.HISTORY_LOG_INFO() | Table function | Base |
SF99703 Level 3 Enhanced: SF99703 Level 7 |
SF99702 Level 14 Enhanced: SF99702 Level 19 |
QSYS2.JOBLOG_INFO() | Table function | Base |
Base
Enhanced: SF99703 Level 18
|
SF99702 Level 3 |
QSYS2.MESSAGE_FILE_DATA | View | Base | SF99703 Level 15 | Not Supported |
QSYS2.MESSAGE_QUEUE_INFO | View | Base | SF99703 Level 4 | SF99702 Level 16 |
QSYS2.REPLY_LIST_INFO | View | Base | Base | SF99702 Level 3 |
Product Services | ||||
QSYS2.LICENSE_INFO | View | Base |
Enhanced: SF99703 |
SF99702 Level 9 Enhanced: SF99702 |
SYSTOOLS.LICENSE_EXPIRATION_CHECK() | Procedure | Base | SF99703 Level 4 | SF99702 Level 16 |
QSYS2.SOFTWARE_PRODUCT_INFO | View | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
PTF Services | ||||
QSYS2.GROUP_PTF_INFO | View | Base | Base | Base |
QSYS2.PTF_INFO | View | Base | Base | Base |
SYSTOOLS.FIRMWARE_CURRENCY | View | Base | SF99703 Level 15 | Not Supported |
SYSTOOLS.GROUP_PTF_CURRENCY | View |
Base
Enhanced: SF99704 Level 10
|
Enhanced: SF99703 Level 3 Enhanced: SF99703 Level 22 |
SF99702 Level 3 Enhanced: SF99702 Level 14 |
SYSTOOLS.GROUP_PTF_DETAILS | View |
Base
Enhanced: SF99704 Level 10
|
Enhanced: SF99703 Level 3 Enhanced: SF99703 Level 22 |
SF99702 Level 9 Enhanced: SF99702 Level 14 |
Security Services | ||||
QSYS2.AUTHORITY_COLLECTION | View | Base | Base | Not Supported |
QSYS2.AUTHORITY_COLLECTION_DLO | View | Base | Not Supported | Not Supported |
QSYS2.AUTHORITY_COLLECTION_FSOBJ | View | Base | Not Supported | Not Supported |
QSYS2.AUTHORITY_COLLECTION_LIBRARIES | View | Base | Not Supported | Not Supported |
QSYS2.AUTHORITY_COLLECTION_OBJECT | View | Base | Not Supported | Not Supported |
QSYS2.AUTHORIZATION_LIST_INFO | View | Base | SF99703 Level 4 | SF99702 Level 16 |
QSYS2.AUTHORIZATION_LIST_USER_INFO | View | Base | SF99703 Level 4 | SF99702 Level 16 |
QSYS2.CERTIFICATE_INFO() |
Table function | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
QSYS2.DRDA_AUTHENTICATION_ENTRY_INFO | View | Base | Base | SF99702 Level 5 |
QSYS2.FUNCTION_INFO | View | Base | Base | Base |
QSYS2.FUNCTION_USAGE | View | Base | Base | Base |
QSYS2.GROUP_PROFILE_ENTRIES | View | Base | Base | Base |
QSYS2.OBJECT_OWNERSHIP | View | SF99704 Level 4 | SF99703 Level 16 | Not Supported |
QSYS2.OBJECT_PRIVILEGES() | Table function |
SF99704 Level 7
|
SF99703 Level 18
|
Not Supported |
QSYS2.OBJECT_PRIVILEGES | View |
Base Enhanced: |
SF99703 Level 4 Enhanced: Enhanced: Enhanced: SF99703 Level 18 |
SF99702 Level 16 |
QSYS2.SQL_CHECK_AUTHORITY() | Scalar function | Base | Base | Base |
QSYS2.USER_INFO | View |
Base
Enhanced: SF99704 Level 7
|
Base Enhanced: SF99703 Level 4 |
Base Enhanced: SF99702 Level 16 |
SYSPROC.SET_COLUMN_ATTRIBUTE() | Procedure | Base | Base | Base |
Spool Services | ||||
QSYS2.OUTPUT_QUEUE_ENTRIES | View | Base | Base | SF99702 Level 9 |
QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC | View | Base | SF99703 Level 11 | SF99702 Level 23 |
QSYS2.OUTPUT_QUEUE_ENTRIES() | Table function | Base | Base | SF99702 Level 9 |
QSYS2.OUTPUT_QUEUE_INFO | View | Base | Base | Introduced: SF99702 Level 11 |
SYSTOOLS.DELETE_OLD_SPOOLED_FILES | Procedure | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
SYSTOOLS.SPOOLED_FILE_DATA() | Table function | Base | SF99703 Level 15 | Not Supported |
Storage Services | ||||
QSYS2.ASP_INFO | View | Base |
SF99703 Level 7 Enhanced: |
SF99702 Level 19 |
QSYS2.ASP_JOB_INFO | View | Base | SF99703 Level 15 | Not Supported |
QSYS2.ASP_VARY_INFO | View | Base | SF99703 Level 7 | SF99702 Level 19 |
QSYS2.MEDIA_LIBRARY_INFO | View | Base | Base | SF99702 Level 9 |
QSYS2.SYSDISKSTAT | Table function | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.SYSDISKSTAT | View |
Base
Enhanced: SF99704 Level 7
Enhanced: SF99704 Level 10
|
Base
Enhanced: SF99703 Level 22
|
Base |
QSYS2.SYSTMPSTG | View | Base | Base | Base |
QSYS2.USER_STORAGE | View | Base | Base | Base |
System Health Services | ||||
QSYS2.SYSLIMTBL | Table | Base |
Enhanced: SF99703 Level 7 Enhanced: |
Introduced: Base Enhanced: SF99702 Level 11 Enhanced: SF99702 Level 19 |
QSYS2.SYSLIMITS | View | Base |
Enhanced: SF9970 Level 7 Enhanced: |
Introduced: Base Enhanced: SF99702 Level 11 Enhanced: SF99702 Level 19 |
QSYS2.SYSLIMITS_BASIC | View | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
Work Management Services | ||||
QSYS2.ACTIVE_JOB_INFO() | Table function |
Base
Enhanced: SF99704 Level 7
Enhanced: SF99704 Level 10
|
Enhanced: SF99703 Level 11 Enhanced: SF99703 Level 18 Enhanced: SF99703 Level 22 |
SF99702 Level 5 Enhanced: SF99702 Level 23 |
QSYS2.AUTOSTART_JOB_INFO | View | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
QSYS2.COMMUNICATIONS_ENTRY_INFO | View | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.GET_JOB_INFO() | Table function | Base |
Enhanced: SF99703 Level 3 Enhanced: |
Introduced: Base Enhanced: SF99702 Level 14 |
QSYS2.JOB_DESCRIPTION_INFO | View | Base |
SF99703 Level 11 |
SF99702 Level 23 |
QSYS2.JOB_INFO() | Table function | Base | SF99703 Level 3 | SF99702 Level 14 |
QSYS2.JOB_LOCK_INFO() | Table function | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
QSYS2.JOB_QUEUE_INFO | View | Base | SF99703 Level 7 | SF99702 Level 19 |
QSYS2.MEMORY_POOL() | Table function | Base | Base | SF99702 Level 9 |
QSYS2.MEMORY_POOL_INFO | View | Base | Base | SF99702 Level 9 |
QSYS2.OBJECT_LOCK_INFO | View | Base | Base | SF99702 Level 9 |
QSYS2.OPEN_FILES() | Table function | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.PRESTART_JOB_INFO | View | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
QSYS2.PRESTART_JOB_STATISTICS() | Table function | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
QSYS2.RECORD_LOCK_INFO | View | Base | Base | SF99702 Level 9 |
QSYS2.ROUTING_ENTRY_INFO | View | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
QSYS2.SCHEDULED_JOB_INFO | View | Base | Base | SF99702 Level 5 |
QSYS2.SUBSYSTEM_INFO | View | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
QSYS2.SUBSYSTEM_POOL_INFO | View | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
QSYS2.SYSTEM_STATUS() | Table function |
Enhanced:
SF99704 Level 4 Enhanced: SF99704 Level 7 Enhanced: SF99704 Level 10
|
Base Enhanced: Enhanced: SF99703 Level 18 Enhanced: SF99703 Level 22 |
SF99702 Level 9 |
QSYS2.SYSTEM_STATUS_INFO | View |
Enhanced:
SF99704 Level 4 Enhanced: SF99704 Level 7 Enhanced: SF99704 Level 10
|
Base Enhanced: Enhanced: SF99703 Level 18 Enhanced: SF99703 Level 22 |
SF99702 Level 9 |
QSYS2.SYSTEM_STATUS_INFO_BASIC | View | SF99704 Level 10 | SF99703 Level 22 | Not Supported |
QSYS2.SYSTEM_VALUE_INFO | View | Base | Base | Base |
QSYS2.WORKSTATION_INFO | View | SF99704 Level 7 | SF99703 Level 18 | Not Supported |
The documentation for these services can be found in Knowledge Center:
Related Information
Document Information
Modified date:
04 October 2020
UID
ibm11119123