Re: problems on translate oracle sql to informix

cnwy >>1:Is there a table like oracle's dual in Informix, which i can used for >>execute functions, for example get the system date? No, but you can create one, with a single column and a single row. >>2:How can i know how many records were updated by the last Update Sql >>statement in the Stored Procedure? LET nrows = DBINFO('sqlca,sqlerrd1') -- nrows is the number of rows updatred >>3:Is it possible to update records in a FOREACH dataset without a >>transaction? Yes, but you will need to use an explicit WHERE instead of a CURRENT OF. HTH Sujit cnwy@my-deja.com on 01/04/2000 09:52:25 PM Please respond to cnwy@my-deja.com To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: problems on translate oracle sql to informix 1:Is there a table like oracle's dual in Informix, which i can used for execute functions, for example get the system date? 2:How can i know how many records were updated by the last Update Sql statement in the Stored Procedure? 3:Is it possible to update records in a FOREACH dataset without a transaction? Sent via Deja.com http://www.deja.com/ Before you buy.