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

DB2 CICS -923 SQLCODE Problem
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
Manshadi

New User


Joined: 31 Aug 2005
Posts: 82
PostPosted: Tue Feb 23, 2010 8:47 pm
 Reply with quote
Hi,

Please help me about the following message:

Code:
 TRANSACTION: BTAC PROGRAM: SY0181   TASK: 0000151 APPLID: CICSU3A1 DISPLAY:  00
  STATUS:  COMMAND EXECUTION COMPLETE                                           
  CALL TO RESOURCE MANAGER DSNCSQL                                             
  EXEC SQL OPEN                              P.AUTH=CICSU3A1, S.AUTH=           
  PLAN=CEPL,     DBRM=DBIOBTAC, STMT=00599, SECT=00002                         
  SQL COMMUNICATION AREA:                                                       
   SQLCABC      = 136                                            AT X'1892C738'
   SQLCODE      =   -923                                         AT X'1892C73C'
   SQLERRML     = 070                                            AT X'1892C740'
   SQLERRMC     = ' ACCESS,00E30301,00000800,CEPL           '    AT X'1892C742'
   SQLERRP      = 'DSNAET03'                                     AT X'1892C788'
   SQLERRD(1-6) =  000,  000, 00000, 0000000000, 00000,  000     AT X'1892C790'
   SQLWARN(0-A) = '_ _ _ _ _ _ _ _ _ _ _'                        AT X'1892C7A8'
   SQLSTATE     = 57015                                          AT X'1892C7B3'
                                                                               
                                                                               
                      LINE:UNKNOWN        EIBFN=X'0612'                         



Many thanks
Manshadi
Back to top
View user's profile Send private message
Manshadi

New User


Joined: 31 Aug 2005
Posts: 82
PostPosted: Tue Feb 23, 2010 8:49 pm
 Reply with quote
Hi,

Do you have any idea about the following message:
Code:
 TRANSACTION: BTAC PROGRAM: SY0181   TASK: 0000151 APPLID: CICSU3A1 DISPLAY:  00
  STATUS:  COMMAND EXECUTION COMPLETE                                           
  CALL TO RESOURCE MANAGER DSNCSQL                                             
  EXEC SQL OPEN                              P.AUTH=CICSU3A1, S.AUTH=           
  PLAN=CEPL,     DBRM=DBIOBTAC, STMT=00599, SECT=00002                         
  SQL COMMUNICATION AREA:                                                       
   SQLCABC      = 136                                            AT X'1892C738'
   SQLCODE      =   -923                                         AT X'1892C73C'
   SQLERRML     = 070                                            AT X'1892C740'
   SQLERRMC     = ' ACCESS,00E30301,00000800,CEPL           '    AT X'1892C742'
   SQLERRP      = 'DSNAET03'                                     AT X'1892C788'
   SQLERRD(1-6) =  000,  000, 00000, 0000000000, 00000,  000     AT X'1892C790'
   SQLWARN(0-A) = '_ _ _ _ _ _ _ _ _ _ _'                        AT X'1892C7A8'
   SQLSTATE     = 57015                                          AT X'1892C7B3'
                                                                               
                                                                               
                      LINE:UNKNOWN        EIBFN=X'0612'                         


Best regards
Manshadi
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2501
Location: Atlanta, Georgia, USA
PostPosted: Tue Feb 23, 2010 8:59 pm
 Reply with quote
Have you made any attempt to research these errors yourself icon_question.gif

The last EIB Function (EIBFN) of X'0612' equates to an 'ENDBR'.

Bill
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
PostPosted: Tue Feb 23, 2010 10:04 pm
 Reply with quote
open DB2 manual : Messages & codes

search -923

search 00E30301
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 Using API Gateway from CICS program CICS 0
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Calling an Open C library function in... CICS 1
No new posts How to 'Ping' a CICS region in JCL CICS 2
No new posts Parallelization in CICS to reduce res... CICS 4
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us