Page 1 of 1

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

Posted: Tue Aug 07, 2018 10:06 am
by samba0808
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?