Accessing DB2 table using sas leading to system rc=00000B37
Posted: 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?
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?