How to write to DML's in User-defined query.

Abhilasha · Post by **Abhilasha** » Fri Dec 16, 2005 4:06 am

Hi,

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

kcbland · Post by **kcbland** » Fri Dec 16, 2005 8:26 am

You get 1 query only.

Abhilasha · Post by **Abhilasha** » Tue Dec 20, 2005 6:45 am

Abhilasha wrote:Hi,

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

chulett · Post by **chulett** » Tue Dec 20, 2005 8:00 am

Use two different links.

Abhilasha · Post by **Abhilasha** » Wed Dec 21, 2005 6:29 am

Is their any other way to do this. Can we do this using User Defined Query

kcbland · Post by **kcbland** » Wed Dec 21, 2005 8:09 am

Abhilasha · Post by **Abhilasha** » Tue Dec 27, 2005 9:51 pm

Thank u vey much.

Regards,
Abhilasha

DSXchange

How to write to DML's in User-defined query.

How to write to DML's in User-defined query.

Re: How to write to DML's in User-defined query.