Status Code

1 character code denoting the type of message. Normal codes for usage with this table would be:

Job Name

See Common Parameters (on page 813)

Task Name

See Common Parameters (on page 813)

Sequence

See Common Parameters (on page 813)

Message

Messages to be recorded into the error log. Each individual message must be no more than 256 characters in length. The individual messages must be separated by either the new-line character (ASCII decimal character 10) or the tilde character (~). A maximum size of 32767 bytes is permitted.

For example the message line1~line2~line3 would result in 3 rows being added to the ws_wrk_error_log table.

Rdbms Code

Maximum 10 character code that identifies an rdbms error or informational message. Under Oracle this code is available from the special variable SQLCODE. The normal practice is to populate this field when an error occurs otherwise leaving it as a null.

Rdbms Message

Maximum 256 character message that contains an rdbms error or informational message. Under Oracle this message is available from the special variable SQLERRM. The normal practice is to populate this field when an error occurs otherwise leaving it as a null.

Job key

See Common Parameters (on page 813)

Task Key

See Common Parameters (on page 813)

Message Type

Maximum 10 character code that identifies the type of message. For application usage. This has no meaning within the QAD metadata

Result

Integer that indicates the status of the call to this procedure. See below for the possible values of Result. DB2 only.