DB2 Access with Rexx for CICS

Ask/Clarify the questions on TSO, CLIST & REXX

Moderators: Veera, Moderator Group

Post Reply
buzzd
Member
Posts: 1
Joined: Mon Sep 07, 2015 11:05 pm

DB2 Access with Rexx for CICS

Post by buzzd » Mon Sep 07, 2015 11:20 pm

Hey everyone,
I'm a student currently working on a mainframe. I have following Problem: i need to get access to a DB2 via Rexx for CICS. It works with Rexx using DSNREXX. This is not supported in Rexx for CICS. How do i get something out of my DB there?
I tried this:

Code: Select all

000001   "EXECSQL SELECT * FROM PRAK405.ANGESTELLTE "                          
 000002  If rc <> 0 then                                                        
 000003   do                                                                    
 000004     Say ' '                                                             
 000005      Say 'Error accessing EMPLOYEE table'                               
 000006      Say 'RC      =' rc                                                 
 000007       Say 'SQLCODE =' SQLCODE                                           
 000008      Exit rc                                                            
 000009       end                                                               
 000010       EXIT          
But not surprisingly it didn't work.

Code: Select all

Error accessing EMPLOYEE table                                
RC      = -4                                                  
SQLCODE = SQLCODE    

academyindia4

Topic deleted by Admin

Post by academyindia4 » Wed Jan 20, 2016 3:30 pm

<< Content deleted By Admin >>

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others