Can anyone please tell me the location of SQLCA.I have tried searching the DB2 datasets DSN810.* .I would like to know the default location of SQLCA file.
Joined: 23 Nov 2006 Posts: 8733 Location: 221 B Baker St
Hello,
It is not clear what you want to know. The SQLCA is not something to be found in the db2 datasets. It is not a file (unless we are talking about 2 different things).
The SQLCA is a structure provided by db2 to facilitate interaction between the application sql code and the database system.
If you explain more about what you are lookikng for, someone will have suggestions.
Hi..
I have found the include files for CICS like DFHBMSCA copybook and DFHEIBLK etc in CICSTS31.* datasets.I have been able to find SQLCA structure for C/C++ language in DSN810.* ie the header file.
I would like to know where the SQLCA for COBOL gets included from.
When we write:
EXEC SQL
INCLUDE SQLCA
END-EXEC.
in a COBOL-DB2 program doe this structure gets generated by DSNHPC or is it included from some file in DB2 system libraries like DFHBMSCA etc as in the case of CICS from CICSTS31.* datasets?Also I would like to know its default location.
