Previous Topic: -244 - NOT ALLOWED WITH SQLMODE=ANSI/FIPSNext Topic: -246 - INVALID AREA NAME: aaaa


-245 - CONFLICTING SECURITY MODES

Explanation

Tables and views which reside in databases of differing security modes may not be mixed in the same SQL statement.

The SQLSTATE that equates to this SQL return code is 42S03.

User Response

If possible, split the SQL statement into two statements (one for each security mode) to achieve the same effect. The security mode of a table or view may be viewed on CA Datacom Datadictionary panels or reports.