TSL_MessageSet function

The TSL_MessageSet function retrieves loader message text.

Syntax

TSL_MessageSet()
returns SET;

Usage

Run the TSL_MessageSet function to retrieve loader message text for one or more message numbers that you provide in an SQL query. The message text is in English. The TSL_MessageSet function is useful if you use the TSL_GetLogMessage function in your loader program. The TSL_GetLogMessage function returns the message ID number, but not the message text.

You can run the TSL_MessageSet function outside the context of a loader program.

Returns

A SET data type that has the following format:

SET(ROW(message_id INTEGER, 
                  message    VARCHAR(255))

message_id: The loader program message number.
message: The loader program message severity and text.

Example

The following statement returns the message text for message numbers that are less than or equal to 10:

SELECT * FROM TABLE(tsl_messageset()) AS m WHERE message_id <= 10;

message_id    msg
1             ASSERT: Condition %s encountered
2             Attempting to build trigger <%s> body text <%s>
3             Bad container <%s> for element <%s>
4             Bad container update <%s> for element <%s>
5             Bad primary key length <%d>
6             Body text for <%s> is <%s>
7             boolean conversion failed with improper value <%c> on col[%d]
8             boolean conversion failed with length %d on col[%d]
9             tstamp=%s, bufptr[%p]=<%s>
10            Caught exception error <%d> state <%s> message: %s