DSNX104I bind-type SQL WARNING USING authorization-id AUTHORITY PLAN=plan-id DBRM=dbrm-name STATEMENT=statement-number THE RESULT OF DECIMAL MULTIPLICATION MAY CAUSE OVERFLOW

Explanation

An arithmetic expression contains a decimal multiplication that might cause an overflow condition when the statement is executed. The problem can be corrected by restructuring the arithmetic expression so that decimal multiplication precedes decimal division or by changing the precision and scale of the operands in the arithmetic expression.
bind-type
Type of BIND subcommand that caused the warning: BIND or REBIND
authorization-id
Authorization ID used during the bind process. For a BIND subcommand, it is the authorization ID of the plan owner. For a REBIND subcommand, it is the authorization ID of the owner specified by the subcommand, or the latest owner of the plan. If this is a remote operation, and the OWNER was not specified in the subcommand, then REMOTE OWNER is output.
Important: If you are using a trusted context, the token auth-id might return a role instead of an authorization ID. A role is returned if a role was in effect and the authorization checking is performed against the role, rather than the authorization ID of the session, when the condition was encountered. Otherwise an authorization ID is returned. A role is returned in the following format as a single token:
  • ROLE: role-name
plan-id
Name of the application plan specified in the BIND subcommand. If the application plan is not specified, this field is blank.
dbrm-name
Name of the DBRM that contains the reference to the indicated table.
statement-number
Statement number of the SQL statement referencing the indicated table.

System action

A valid plan is created if no errors are detected.