Column Definition:
SUB_NM Varchar (50)
G_SK Integer (5)
EFF_DT Date(10)
EXP_DT Date(10)
C_CD Varchar (5)
A_SK Integer
Thanks
Error : Not bounded length
Moderators: chulett, rschirm, roy
Hi,
I Used other option to Do Update and then Insert (using User defined query)
When I was doing the same in single ODBC Enterpeise Stage ( Write Method : Upsert, Update then Insert, Using user Defined query) then I was getting Fatal which I explained in earlier post.
Now I did : From transformer, I used 2 ODBC stages ( Each separate for Update and Insert ) AND accordingly set Oreder of link Execution. by this way I am getting my expected result.
I Used other option to Do Update and then Insert (using User defined query)
When I was doing the same in single ODBC Enterpeise Stage ( Write Method : Upsert, Update then Insert, Using user Defined query) then I was getting Fatal which I explained in earlier post.
Now I did : From transformer, I used 2 ODBC stages ( Each separate for Update and Insert ) AND accordingly set Oreder of link Execution. by this way I am getting my expected result.