Application Services

These procedures, functions, and views provide interface information that can be used by applications.

ACTIVATION_GROUP_INFO table function
The ACTIVATION_GROUP_INFO table function returns all the activation groups that are associated with a job and their attributes.
ADD_USER_INDEX_ENTRY and ADD_USER_INDEX_ENTRY_BINARY procedures
The ADD_USER_INDEX_ENTRY and ADD_USER_INDEX_ENTRY_BINARY procedures add a single entry to a user index (*USRIDX). The data to be added can be provided as either character or binary data.
BINDING_DIRECTORY_INFO view
The BINDING_DIRECTORY_INFO view returns information about the object entries in binding directories.
BOUND_MODULE_INFO view
The BOUND_MODULE_INFO view returns information about modules bound into an ILE program or service program.
BOUND_SRVPGM_INFO view
The BOUND_SRVPGM_INFO view returns information about service programs bound into an ILE program or service program.
CHANGE_USER_SPACE and CHANGE_USER_SPACE_BINARY procedures
The CHANGE_USER_SPACE and CHANGE_USER_SPACE_BINARY procedures change the contents of a user space (*USRSPC) object by writing a specified amount of data to the object at a specified location. The data can be provided as either character or binary data.
CHANGE_USER_SPACE_ATTRIBUTES procedure
The CHANGE_USER_SPACE_ATTRIBUTES procedure changes the attributes of a user space (*USRSPC) object.
CLEAR_DATA_QUEUE procedure
The CLEAR_DATA_QUEUE procedure clears all messages from the specified data queue or clears messages that match the key provided.
COMMAND_INFO view
The COMMAND_INFO view returns information about all CL commands on the system.
CREATE_USER_INDEX procedure
The CREATE_USER_INDEX table procedure creates or replaces a user index (*USRIDX) object.
CREATE_USER_SPACE procedure
The CREATE_USER_SPACE procedure creates or replaces a user space (*USRSPC) object.
DATA_AREA_INFO table function
The DATA_AREA_INFO table function returns a row for the specified data area, including a data area in QTEMP or the *LDA, *PDA, or *GDA data areas.
DATA_AREA_INFO view
The DATA_AREA_INFO view returns the values of data areas.
DATA_QUEUE_ENTRIES table function
The DATA_QUEUE_ENTRIES table function returns one or more messages from the specified data queue. The messages are not removed from the data queue. The message data is returned as character, UTF-8, and binary data.
DATA_QUEUE_INFO view
The DATA_QUEUE_INFO view returns a row for every data queue.
DB_TRANSACTION_INFO view
The DB_TRANSACTION_INFO view returns one row for each commitment definition.
DB_TRANSACTION_JOURNAL_INFO table function
The DB_TRANSACTION_JOURNAL_INFO table function returns the status of journal resources under commitment control for a commitment definition.
ENVIRONMENT_VARIABLE_INFO view
The ENVIRONMENT_VARIABLE_INFO view contains information about environment variables.
EXIT_POINT_INFO view
The EXIT_POINT_INFO view returns information about exit points.
EXIT_PROGRAM_INFO view
The EXIT_PROGRAM_INFO view returns information about exit programs.
GENERATE_SPREADSHEET scalar function
The GENERATE_SPREADSHEET scalar function generates a file in the Integrated File System containing a spreadsheet based on either the results of a query or the complete content of a database file.
LPRINTF procedure
The LPRINTF procedure writes an informational message to the joblog. It is severity 0 and has no message identifier.
PROGRAM_EXPORT_IMPORT_INFO view
The PROGRAM_EXPORT_IMPORT_INFO view returns the data and procedure that are exported or imported for an ILE program or service program.
PROGRAM_INFO view
The PROGRAM_INFO view returns information about programs.
QCMDEXC procedure
The QCMDEXC procedure executes a CL command.
QCMDEXC scalar function
The QCMDEXC scalar function executes a CL command.
RECEIVE_DATA_QUEUE table function
The RECEIVE_DATA_QUEUE table function returns a message from the specified data queue. The message data is returned as character, UTF-8, and binary data.
REMOVE_USER_INDEX_ENTRY and REMOVE_USER_INDEX_ENTRY_BINARY table functions
The REMOVE_USER_INDEX_ENTRY and REMOVE_USER_INDEX_ENTRY_BINARY table functions remove one or more entries from a user index (*USRIDX).
SEND_DATA_QUEUE, SEND_DATA_QUEUE_BINARY, and SEND_DATA_QUEUE_UTF8 procedures
The SEND_DATA_QUEUE, SEND_DATA_QUEUE_BINARY, and SEND_DATA_QUEUE_UTF8 procedures send a message to the specified data queue. The message data can be sent as character, UTF-8, or binary data.
SEND_EMAIL scalar function
The SEND_EMAIL scalar function sends an email to a single recipient. This is done by using the SNDSMTPEMM (Send SMTP E-mail Message) CL command.
SERVICES_INFO table
The SERVICES_INFO table returns information about system-supplied services.
SET_PASE_SHELL_INFO procedure
The SET_PASE_SHELL_INFO procedure provides the ability to set the path to the PASE shell for the specified user or the path to the default shell returned for users that do not have a configured shell.
SPLIT table function
The SPLIT table function returns a result table that contains one row for each substring of input-list that is separated by delimiter.
STACK_INFO table function
The STACK_INFO table function returns one row for each entry in the call stack for either a specific thread or for every thread of the specified job. It returns information similar to what can be accessed through the Display Job (DSPJOB) CL command and the Retrieve Call Stack (QWVRCSTK) API.
USER_INDEX_ENTRIES table function
The USER_INDEX_ENTRIES table function returns the entries of the specified user index (*USRIDX). The data is returned as character and binary data.
USER_INDEX_INFO view
The USER_INDEX_INFO view returns the attributes of user indexes.
USER_SPACE table function
The USER_SPACE table function returns the contents of the specified user space (*USRSPC). The data is returned as character and binary data.
USER_SPACE_INFO view
The USER_SPACE_INFO view returns the attributes of user spaces.
WATCH_DETAIL table function
The WATCH_DETAIL table function returns the details for watched messages, LIC logs, and PALs for a specific session identifier.
WATCH_INFO view
The WATCH_INFO view returns information about watch sessions on the system.

Parent topic: IBM i Services