sysVar.sqlData

sysVar.sqlData is a structured record that contains the same system variables that are defined in structured record sqlLib.sqlData. The variables in both records are updated after your program accesses a relational database. The differences between the two records are as follows:

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?

YES

Compatibility

Table 1. Compatibility considerations for sqlData
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 is left to set whatever fields it can. The others can be modified by the user, but EGL Java does not use them.

Feedback