DSXchange

Hi

can we write multiple SQLs in a single CLOSE COMMAND

my requirement is there are updates and delete on the table and the SQLs are like....
1)update table_name set..... left join on table_name2 .....
2)DELETE FROM TABLE_NAME LEFT JOIN TABLE_NAME2 ....WHERE.....
3)update table_name set..... inner join on table_name3 .....
etc.,

so these should be execited one by one.
so is it possible in any way?

is there any other option to do like so?

Thanks
Praveen

jpraveen wrote:can we write multiple SQLs in a single CLOSE COMMAND

I have not tried in parallel, but think you can. The same works in Server After SQL.