A CA Ideal program can access the SQL Communication Area (SQLCA) for the last SQL statement executed in a program or run‑unit. You can define the SQLCA work area in the program's working data or parameter data or code $SQL functions in any program procedure or $ERROR functions in the Error procedure. The SQLCA is described further in the SQLCA section in this chapter.
CA Ideal also supports the SQL WHENEVER statement (described in the SQL Language Elements section in this chapter).
Because SQL implementations can differ, the CA Ideal compiler can issue warnings for possible semantic errors in user‑generated SQL. Such statements are passed to the database management system for final determination.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|