Hi Krishna, Thanks for unlocking db2 book for members.
can you please provide Password number 64.
Search found 52 matches
- Tue Nov 23, 2010 11:22 pm
- Forum: Admin Announcements
- Topic: DB2 QUICK START - FREE for Members
- Replies: 81
- Views: 154870
- Wed Jun 16, 2010 11:03 pm
- Forum: Suggestions & Feedback
- Topic: What happened?
- Replies: 3
- Views: 7635
- Tue Apr 27, 2010 3:50 pm
- Forum: JCL
- Topic: WER230A OUTREC FIELD OUTSIDE RANGE .......please help
- Replies: 2
- Views: 9258
OUTREC is trying to read more than record lenght of current input file.
your input file is haivng record lenght of 78 only.
Code: Select all
WER108I IN1 : RECFM=FB ; LRECL= 78; BLKSIZE= 27924
Code: Select all
OUTREC BUILD=(38,4,8X,42,40,11X,116,6,121X,82,12,
37X,94,22,739X,1001:C'BB')
- Thu Apr 22, 2010 11:20 am
- Forum: TSO, CLIST & REXX
- Topic: Access DB2 region using rexx
- Replies: 1
- Views: 6874
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_accessrexxlanguagesupportinterface.htm Sample Program: "SUBCOM DSNREXX" IF RC=0 THEN SAY 'DSNREXX IS AVAILABLE' ELSE DO SAY 'DSNREXX IS NOT AVAILABLE' SAY 'SUBCOM RC :' RC END IF RC THEN DO S_RC = RXS...
- Wed Oct 14, 2009 6:25 pm
- Forum: JCL
- Topic: fetch VSAM records
- Replies: 1
- Views: 3952
- Sun Oct 11, 2009 11:52 am
- Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
- Topic: Need Clarification on RESUB and RESTART commands in CA-7
- Replies: 6
- Views: 12385
in the restart screen in ca7 we will have three options 1. Resubmit from production 2. Force Completed 3. Restart 1. Resubmit from production: If you select this option , job will be resubmitted from first step. 2. Force Complete: if you select this Ca7 will treat that job has completed & it will st...
- Mon Sep 21, 2009 11:16 am
- Forum: JCL
- Topic: ebooks for mainframe beginners
- Replies: 2
- Views: 6939
- Sun Aug 30, 2009 3:11 pm
- Forum: JCL INTERVIEW QUESTIONS
- Topic: If a generation data set is specified as input without numb
- Replies: 7
- Views: 11301
- Wed Jul 29, 2009 3:16 pm
- Forum: JCL
- Topic: LISTCAT in JCL?
- Replies: 4
- Views: 9307
- Mon Jul 13, 2009 7:45 pm
- Forum: COBOL
- Topic: MATCHING REPORTS
- Replies: 1
- Views: 3353
Check below link, it will be help full for you.
http://www.mainframegurukul.com/Mainfra ... t=joinkeys
http://www.mainframegurukul.com/Mainfra ... t=joinkeys
- Mon Jul 13, 2009 3:43 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Splitting a file by counting records
- Replies: 2
- Views: 7572
you can try below job: //JS15 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=INPUT FILE,DISP=SHR //X1 DD DSN=OUTPUT FILE1,DISP=SHR //X2 DD DSN=OUTPUT FILE2,DISP=SHR //X3 DD DSN=OUTPUT FILE3,DISP=SHR //X4 DD DSN=OUTPUT FILE4,DISP=SHR //X5 DD DSN=OUTPUT FILE5,DISP=SHR //X6 DD DSN=OUTPUT FILE6,DISP...
- Wed Jul 08, 2009 4:27 pm
- Forum: JCL
- Topic: Scheduling jobs in mainframes.
- Replies: 1
- Views: 4001
- Tue Jul 07, 2009 3:14 pm
- Forum: JCL
- Topic: ignore the 3 columns from the inputfile/
- Replies: 5
- Views: 8332
Try using below sort card:
Code: Select all
OPTION COPY
INREC BUILD=(1,133)
- Tue Jun 23, 2009 11:52 am
- Forum: JCL
- Topic: How to concatenate records from two ps into one ps?
- Replies: 28
- Views: 60031
After seeing this I understood that you didnt have latest update. See below link from Frank: http://www.mainframegurukul.com/MainframeGuru/viewtopic.php?t=3982. I am also beginer in JCL or Sort. Still I am learning. Sorry to say this, Please wait till some experts of DFSORT check this link. They onl...
- Tue Jun 23, 2009 8:53 am
- Forum: JCL
- Topic: How to concatenate records from two ps into one ps?
- Replies: 28
- Views: 60031