HI,
I have a DB2 table having almost 800million records. Accessing this DB2 table using sas leading to system rc=00000B37
It always ends with sapce error, THEN reattempted to increase the space but still same error,
Code:
SELECT (CAST(SOURCE_DATE AS DATE) + 364 DAYS) AS SNAP_DTE ,
ORIGST AS ORIG ,
DESTINA AS DEST ,
B.CABIN_CLS_AD AS CABN_CAT ,
LEG_DPART AS DPTR_DTE ,
FLIGT_GR_ID AS FLIGHTGRPID ,
INT( SUBSTR(FLIGT_GR_ID,1,3)) AS FLIGHTGRPID3 ,
LEG_DAYS_OUT AS DAYS_OUT ,
BKD_ARZD_PCTG AS BKD_DFD1
FROM DB2RMD.FLT_LVL_DATA A,
DB2YDA.RCFM_HRDLE_DATA B
WHERE LEG_DAYS_OUT > 1
AND A.SOURCE_DATE BETWEEN (CAST(SOURCE_DATE AS DATE) - 364 DAYS)
AND (CAST(SOURCE_DATE AS DATE) - 0 DAYS)
AND A.ORIGST = B.ORIGST_AD
AND A.DESTINA = B.DESTINA_AD
AND A.CABIN_CLS_CD = B.CABIN_CLS_AD
AND A.LEG_DPART = B.LEG_DPART_AD
Can someone help me on this?
Accessing DB2 table using sas leading to system rc=00000B37
Moderators: Kalicharan, Moderator Group
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page