In either case, the value of the variable is not saved across a segmented converse.
For the record structure, see sqlLib.sqlData (EGL system variable).
EGL maintains sysVar.sqlData for compatibility with VisualAge® Generator and earlier releases of EGL. In addition, use sysVar.sqlData when you want to limit the scope of the SQL information to a single program or if you are using COBOL generation.
EGL maintains sqlLib.sqlData for compatibility with I4GL. In addition, if you are using Java™ generation and using a library function to do SQL I/O, you can use sqlLib.sqlData to check the SQL results of the library function after the return to the invoking function.
Value saved across segmented converse?
NO
| Platform | Issue |
|---|---|
| Java generation | Java only sets sqlcode, sqlstate, sqlerrd[2], sqlerrd[3], and sqlwarn[2]. In Java the sqlca data structure is not passed to and from the database with each I/O operation, so EGL sets whatever fields it can. The user can modify other fields, but EGL Java does not use them. |