DSNT281I bind-command QUERY FOR query-type = query-identifier NOT SUCCESSFUL. REASON: reason-text
Explanation
Errors were detected during processing of a BIND QUERY or related operation on a query.
- bind-command
- The type of command that resulted in the
message:
- BIND
- For BIND QUERY commands.
- FREE
- For FREE QUERY commands.
- LOOKUP
- For BIND QUERY commands when the LOOKUP(YES) option is in effect.
- query-type
- Information that identifies the query:
- QUERYNO
- The query is identified by the query number (QUERYNO) in the table DSN_USERQUERY_TABLE.
- QUERYID
- The query is identified by the query ID (QUERYID) in the table SYSIBM.SYSQUERY.
- query-identifier
- The query number or query ID, depending on the query-type value.
- reason-text
- A string that identifies the reason that the specified command failed. For example, the string might identify that an unsupported statements was specified, that an invalid value that was encountered, or that a required table does not exist.
When bind-command is LOOKUP, an instance of the DSNT281I message is issued for each row in the DSN_USERQUERY_TABLE that has matching rows in both the SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN catalog tables.
System action
The query is not processed.
System programmer response
Use the information provided in this code and other messages issued in conjunction with this one to determine the reason why the query could not be processed.