IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQLCA location


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Arun Aravind

New User


Joined: 20 Jun 2008
Posts: 14
Location: Bangalore

PostPosted: Sat Oct 11, 2008 10:15 am
Reply with quote

Hi..


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.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat Oct 11, 2008 10:37 am
Reply with quote

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.
Back to top
View user's profile Send private message
Arun Aravind

New User


Joined: 20 Jun 2008
Posts: 14
Location: Bangalore

PostPosted: Sat Oct 11, 2008 8:04 pm
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat Oct 11, 2008 9:41 pm
Reply with quote

Hello,

Yes, the SQLCA is generated by DSNHPC.

Quote:
Also I would like to know its default location.
From what i see, it is generated internally by DSNHPC. Other languages/pre-compilers may be different.
Back to top
View user's profile Send private message
Arun Aravind

New User


Joined: 20 Jun 2008
Posts: 14
Location: Bangalore

PostPosted: Sun Oct 12, 2008 7:43 am
Reply with quote

Thanks a lot for the answer.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts how to show listing in physical locat... PL/I & Assembler 2
No new posts I need help with SQLCA DB2 8
No new posts Confusion regarding length of SQLCA v... DB2 4
No new posts RMM Cannot move a volume from SHELF l... IBM Tools 0
Search our Forums:

Back to Top