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:

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

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 sets whatever fields it can. The user can modify other fields, but EGL Java does not use them.

Feedback