DSNT295I bind-type WARNING FOR QUERY = query-identifier REASON: reason-text
Explanation
A warning condition was encountered during BIND
QUERY processing.
- bind-type
- Whether the LOOKUP option was specified in the BIND subcommand
that resulted in the message.
- BIND
- The LOOKUP option was not specified.
- LOOKUP
- The LOOKUP option was specified.
- query-identifier
- The unique identifier for the query that corresponds to the values of the QUERYID columns in the and user-id.DSN_USERQUERY_TABLE SYSIBM.SYSQUERY tables.
- reason-text
- A string value that described the reason for the message. Example reason-text values
include:
- 1. SYMBOL & IS ENCOUNTERED
- The statement text for a statement-level optimization hint contains the ampersand symbol (&). The presence of the ampersand symbol indicates that the hint applies to a cached dynamic SQL statement and that the CONCENTRATE STATEMENTS WITH LITERAL VALUES option is expected when the statement is prepared.
- 2. qualifier.DSN_USERQUERY_TABLE.ACCESSPATH_HINT AND qualifier.DSN_USERQUERY_TABLE.OPTION_OVERRIDE ARE BOTH SET TO BLANK. THE qualifier.DSN_USERQUERY_TABLE OPTIONS ARE IGNORED
- The values of both the ACCESSPATH_HINT and OPTION_OVERRIDE columns of the DSN_USERQUERY_TABLE are blank. The option values are ignored.
- 3. qualifier.DSN_USERQUERY_TABLE.OPTION_OVERRIDE IS SET TO N. THE qualifier.DSN_USERQUERY_TABLE OPTIONS ARE IGNORED
- Values were found in some of the DSN_USERQUERY_TABLE columns that specify option values, but the value of the OPTION_OVERRIDE column indicates that no option overrides are specified. The option values are ignored.
System action
The hints is created successfully, or the lookup is successful.
User response
Verify that the specified statement is eligible for literal replacement, and the CONCENTRATE STATEMENTS WITH LITERAL VALUES is specified when the statement is prepared.