Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact

Error code groups

ACE ADA/Same Backup Branding and Installation Class Libraries Connection (>V6) Connectivity CM CSS DBAccess Debugger ESQL/C ESQL/C (Windows) Embedded Languages Form Compiler Form and Menu Gateway with DRDA INet (Windows) INet Relay Module ISAM Locales mkmessage NLS Online/Secure Open View Operating System Optical Disk Subsystem Perform Postive Numbers Preprocessor Smart Blobs Roles SQL SQL Utility 4GL Runtime NewEra Compiler 4GL/NewEra Compiler 4GL/NewEra Runtime Unknown
Finderr

-940 The statement failed, becuase the WITH CHECK OPTION keywords are not

supported in Union, Intersect, or Minus views.

You tried to define a union/intersect/minus view with a check options. Redefine the union/intersect/minus view without the check options clause.