Explanation
When SQLMODE=FIPS, only those features explicitly in violation of the ANSI SQL-86 standard are rejected. With SQLMODE=ANSI, all extensions to the ANSI SQL-86 standard are rejected.
The SQLSTATE that equates to this SQL return code is 42S02.
User Response
SQLMODE=ANSI SQL statements should be portable to another ANSI SQL-86 conforming implementation without change. With SQLMODE=FIPS, ANSI SQL-86 extensions may not be available in another implementation, but at least the extensions are flagged.
|
Copyright © 2014 CA.
All rights reserved.
|
|