CLOSE COMMAND

[jpraveen]

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

[HariK]

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.