Oninit cdi / Archive
Talk to an expert →

@@rowcount equivalent in INFORMIX?

Posted in 2007

Topics: SQL Development & Query Writing, Stored Procedures & SPL

saira — — source: Usenet: comp.databases.informix

Hello, I have a stored procedure that executes a select statement (from table A), and insert the resultset into another table (table B)... How can I view the number of rows inserted into table B? Thanks in advance for your help. Saira.

↪ replying to saira
saira — — source: Usenet: comp.databases.informix

On Apr 16, 4:20 pm, "saira" <saira_mat...@yahoo.com> wrote: > Hello, > I have a stored procedure that executes a select statement (from table > A), and insert the resultset into another table (table B)... How can I > view the number of rows inserted into table B? > Thanks in advance for your help. > Saira. Sorry... forgot to mention that we use Informix Ver 7.31

↪ replying to saira
Obnoxio The Clown — — source: Usenet: comp.databases.informix

saira said: > Hello, > I have a stored procedure that executes a select statement (from table > A), and insert the resultset into another table (table B)... How can I > view the number of rows inserted into table B? > Thanks in advance for your help. SQLCA record? -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

↪ replying to saira
Art S. Kagel — — source: Usenet: comp.databases.informix

saira wrote: > Hello, > I have a stored procedure that executes a select statement (from table > A), and insert the resultset into another table (table B)... How can I > view the number of rows inserted into table B? > Thanks in advance for your help. > Saira. > select dbinfo('sqlca.sqlerrd2') from systables where tabid = 1; Art S. Kagel

↪ replying to Art S. Kagel
Doug Lawry — — source: Usenet: comp.databases.informix

"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:4623F776.2020709@bloomberg.net... > saira wrote: >> Hello, >> I have a stored procedure that executes a select statement (from table >> A), and insert the resultset into another table (table B)... How can I >> view the number of rows inserted into table B? >> Thanks in advance for your help. >> Saira. >> > > select dbinfo('sqlca.sqlerrd2') from systables where tabid = 1; > > Art S. Kagel You can use dbinfo directly within the stored procedure, for example: IF dbinfo('sqlca.sqlerrd2') = 0 THEN ... -- Regards, Doug Lawry www.douglawry.webhop.org