Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQLCA location

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: SQLCA location
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

Site Director


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

PostPosted: Sat Oct 11, 2008 10:37 am    Post subject:
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    Post subject: SQLCA
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

Site Director


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

PostPosted: Sat Oct 11, 2008 9:41 pm    Post subject:
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    Post subject: Reply to: SQLCA location
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Mainframe opening for 3 to 10 yrs exp... Placementatpune Mainframe Jobs 0 Tue Jul 05, 2016 12:02 pm
This topic is locked: you cannot edit posts or make replies. MVS Assembler profiles for Pune Locat... shailesh_do Mainframe Jobs 0 Mon Feb 22, 2016 6:21 pm
No new posts File sorting and summing up values at... kenshin DFSORT/ICETOOL 3 Wed Sep 23, 2015 2:14 am
This topic is locked: you cannot edit posts or make replies. Mainframe Openings with Genpact - Noi... Keanehelp Mainframe Jobs 0 Wed Jul 08, 2015 6:13 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us