DATASTAGE Upgrade from Server 7.5.2 to Parallel 8.1
Posted: Wed Aug 24, 2011 10:28 am
Hi,
We have migrated server jobs which were in DS 7.5.2 to DS 8.1 parallel version. Both of these versions installed on same Linux server. Some of the DS server jobs with OCI stage has user defined SQL. These SQLs first column is the oracle sequence next val for surrogate key and the remainder columns are from transformer mapping. This job runs successfully in 7.5.2 ver but not in 8.1. It simply hangs out as it is running but nothing really happening. If I change the SQL to 'Generate SQL' in properties tab with adding DS sequence number for surrogate key column, it runs successfully. Would appreciate your thoughts/comments on this issue. Or may be wondering if anyone had gone through the same issue? Below is the sql..
INSERT INTO SAT.SDT027_USER_AKA
(USER_AKA_ID,
USER_ID,
ID_TYP_ID,
INTRNL_IDNTFYR_TXT,
CRTD_BY,
CRTD_DT,
LST_CHNGD_BY,
LST_CHNGD_DT,DLT_FLG)
VALUES
(SAT.SDQ027_USER_AKA_ID.NEXTVAL,
:1,
:2,
:3,
:4,
TO_DATE(:5, 'YYYY-MM-DD HH24:MI:SS'),
:6,
TO_DATE(:7, 'YYYY-MM-DD HH24:MI:SS'),
:8)
We have migrated server jobs which were in DS 7.5.2 to DS 8.1 parallel version. Both of these versions installed on same Linux server. Some of the DS server jobs with OCI stage has user defined SQL. These SQLs first column is the oracle sequence next val for surrogate key and the remainder columns are from transformer mapping. This job runs successfully in 7.5.2 ver but not in 8.1. It simply hangs out as it is running but nothing really happening. If I change the SQL to 'Generate SQL' in properties tab with adding DS sequence number for surrogate key column, it runs successfully. Would appreciate your thoughts/comments on this issue. Or may be wondering if anyone had gone through the same issue? Below is the sql..
INSERT INTO SAT.SDT027_USER_AKA
(USER_AKA_ID,
USER_ID,
ID_TYP_ID,
INTRNL_IDNTFYR_TXT,
CRTD_BY,
CRTD_DT,
LST_CHNGD_BY,
LST_CHNGD_DT,DLT_FLG)
VALUES
(SAT.SDQ027_USER_AKA_ID.NEXTVAL,
:1,
:2,
:3,
:4,
TO_DATE(:5, 'YYYY-MM-DD HH24:MI:SS'),
:6,
TO_DATE(:7, 'YYYY-MM-DD HH24:MI:SS'),
:8)