Previous Topic: -148 - SUBQUERY AT LVL aaaa NBR bbbb RETURNED MORE THAN 1 ROWNext Topic: -150 - AUTHORIZATION ID MUST MATCH SCHEMA'S AUTHORIZATION ID


-149 - PLAN CAN'T SPECIFY DATACOM SQLMODE WHEN MUF OPTION SPECIFIES ANSI

Reason:

ANSI was specified as the mode in the MUF startup option SQLOPTION. This cannot be overridden by specifying SQLMODE=DATACOM at preprocessing time.

The SQLSTATE that equates to this SQL return code is 53S15.

Action:

Verify that the requested SQL mode is the one desired. If necessary, restart the Multi-User Facility specifying DATACOM for the mode, which allows specification of either SQLMODE=DATACOM or SQLMODE=ANSI at preprocessing time.