Accessing DB2 table using sas leading to system rc=00000B37

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
samba0808
Member
Posts: 1
Joined: Tue Aug 07, 2018 9:39 am

Accessing DB2 table using sas leading to system rc=00000B37

Post by samba0808 » Tue Aug 07, 2018 10:06 am

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?

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