MAINFRAME - TIP OF THE DAY :
When you specified V for RECFM parameter, LRECL value is largest record in the file plus 4 bytes. These four bytes contain the actual length of each variable length record in the file
Programmers Voted for below topics. Please Vote for good Posts.
Thank You! for your feedback. Connecting to the server. Please Wait...
Posted: Mon Sep 07, 2015 11:20 pm Post subject: DB2 Access with Rexx for CICS
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:
000001 "EXECSQL SELECT * FROM PRAK405.ANGESTELLTE "
000002 If rc <> 0 then
000004 Say ' '
000005 Say 'Error accessing EMPLOYEE table'
000006 Say 'RC =' rc
000007 Say 'SQLCODE =' SQLCODE
000008 Exit rc
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Cobol Tutorial This cobol tutorial covers most of the important topics like STRING, UNSTRING, COMP, COMP-3.....
DB2 Tutorial DB2 Tutorial focuses on DB2 COBOL Programming. Explains in simple language. Some Chapters are locked, Forum members have free access to these chapters
CICS Tutorial This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming...
JCL Tutorial This is most popular JCL tutorial from mainframegurukul. It does contain important jcl ....
SORT Tutorial This Tutorial covers all important aspects of DFSORT. Has more SORT examples