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

What is the size of SQLCA


IBM Mainframe Forums -> FAQ & Basics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sukumaran

New User


Joined: 08 Apr 2007
Posts: 1
Location: chennai

PostPosted: Sun Apr 29, 2007 12:44 am
Reply with quote

hello every one
i want to know that what is the size of SQLCA
what is the error code for plan where program name not found
While executing the MAP , am getting error as ABMO. can any one suggest me
Back to top
View user's profile Send private message
muthuvel

Active User


Joined: 29 Nov 2005
Posts: 217
Location: Chennai

PostPosted: Mon Apr 30, 2007 11:50 am
Reply with quote

SQLCA will have a size of 41 bytes.The below is the stucture
01 SQLCA
05 SQLCAID PIC X(8).
05 SQLCABC PIC S9 (9) COMP-4.
05 SQLCODE PIC S9 (9) COMP-4.
05 SQLERRM.
49 SQLERRML PIC S9(4) COMP-4.
49 SQLERRMC PIC X (70).
05 SQLERRP PIC X (8).
05 SQLERRD OCCURS 6 TIMES
PIC S9(9) COMP-4.
05 SQLWARN.
10 SQLWARN0 PIC X.
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 -> FAQ & Basics

 


Similar Topics
Topic Forum Replies
No new posts REORG to reduce segment size new DBD IMS DB/DC 2
No new posts COBOL batch program using large size ... COBOL Programming 3
No new posts I need help with SQLCA DB2 8
No new posts Confusion regarding length of SQLCA v... DB2 4
No new posts TSO Region Size TSO/ISPF 7
Search our Forums:

Back to Top