I am trying to use following SQL's in the User Defined section of Informix stage:
UPDATE table1 SET update_user_id ='-5' ,update_type_cd = 'D' WHERE merch_num=? AND cso_cd=? AND plan_type_cd=?;;
DELETE FROM table2 WHERE merch_num=? AND cso_cd=? AND plan_type_cd=?;;
1st query (Update) is not working, bu the 2nd (Delete) is working fine.
I have looked in to the DS help, its given to use it in the above way only.
Can anyone please help me with this and give me the solution.
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
I am trying to use following SQL's in the User Defined section of Informix stage:
UPDATE table1 SET update_user_id ='-5' ,update_type_cd = 'D' WHERE merch_num=? AND cso_cd=? AND plan_type_cd=?;;
DELETE FROM table2 WHERE merch_num=? AND cso_cd=? AND plan_type_cd=?;;
1st query (Update) is not working, bu the 2nd (Delete) is working fine.
I have looked in to the DS help, its given to use it in the above way only.
Can anyone please help me with this and give me the solution.
Thanks & Regards,
Abhilasha
I want to know how both the queries will work in User-defined SQL.
Regards,
Abhilasha
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle