pshongal
New User
Joined: 14 Jun 2012 Posts: 96 Location: India
|
|
|
|
Hi All,
I am trying to unload records from multiple tables (join) using CDB utility. Below is the query.
Code: |
UNLD DATA FORMAT(DSN)
MODE DIRECT
SELECT T1.C_TRANS_ID
,T1.C_SOURCE_CD
,T2.C_SOURCE_NM
,T2.C_SOURCE_TX
,T1.A_TYPE_CD
,T4.A_TYPE_NM
,T4.A_TYPE_TX
,T1.A_TYPE_SEQ_NO
,T1.MO_PRTN_KEY
,T1.UPD_SOURCE_CD
,T3.C_SOURCE_NM
,T3.C_SOURCE_TX
,T1.A_DT
,T1.A_TM
,T1.CREATE_TS
,T1.A_RSN_CD
,T1.A_RSN_CMNT_TX
,COALESCE(T5.A_CRIT_IN,SPACE(003))
,COALESCE(T5.A_RSN_DS_TX,SPACE(254))
FROM TABLE VMUSIU.C_SRCE T2
,VMUSIU.C_SRCE T3
,VMUSIU.ACT_TYP T4
,VMUSIU.E_C_ACT T1 LEFT OUTER JOIN
VMUSIU.ACT_RSN T5
ON ( T5.A_RSN_CD = T1.A_RSN_CD )
WHERE
(
T1.MO_PRTN_KEY IN (39,38,37,36)
AND T1.C_SOURCE_CD = T2.C_SOURCE_CD
AND T1.UPD_SOURCE_CD = T3.C_SOURCE_CD
AND T1.A_TYPE_CD = T1.A_TYPE_CD
AND T1.CREATE_TS BETWEEN '2016-02-08-16.00.00.000001'
AND '2016-02-08-20.00.00.000000'
AND T1.A_TYPE_CD <> 450
)
WITH UR |
Job is failing with below error.
Code: |
23:40:40.37 MAIN.COMWRKMD NGTB293 CDBWORK NAME(DEFAULT) WAS NOT FOUND.
23:40:40.83 MAIN.SVRMS000 NGTC258 CDB SUBSYSTEM IS ACTIVE. VERSION 05.01.
23:40:40.97 MAIN.SVRRESTR NGTZ197 STATUS FILE IS EMPTY. UNABLE TO RESTART.
23:40:40.99 MAIN.COMOBRPT NGTZ343 OBJECT REPORT DID NOT FIND ANY STATUS RECORDS.
23:40:41.00 MAIN.RRGMINIT NGTR303 UTILITY COMPLETE, COMPLETION CODE=8. |
Is the UNLD keyword is correct for joins also? |
|