Informix Guide to SQL: Tutorial

Informix Guide to SQL: Tutorial
Chapter 14: Creating and Using SPL Routines

Home Contents Index Master Index New Book

Checking the Number of Rows Processed in an SPL Routine

Within SPL routines, you can use the DBINFO function to find out the number of rows that have been processed in SELECT, INSERT, UPDATE, DELETE, EXECUTE PROCEDURE, and EXECUTE FUNCTION statements.

Figure 14-112 shows an SPL function that uses the DBINFO function with the 'sqlca.sqlerrd2' option to determine the number of rows that are deleted from a table.

Figure 14-112

CREATE FUNCTION del_rows ( pnumb INT )
RETURNING INT;


DEFINE nrows INT;


DELETE FROM sec_tab WHERE part_num = pnumb;
LET nrows = DBINFO('sqlca.sqlerrd2');


RETURN nrows;


END FUNCTION;

To ensure valid results, use this option after SELECT and EXECUTE PROCEDURE or EXECUTE FUNCTION statements have completed executing. In addition, if you use the 'sqlca.sqlerrd2' option within cursors, make sure that all rows are fetched before the cursors are closed to ensure valid results.

Informix Guide to SQL: TutorialChapter 14: Creating and Using SPL Routines Home Contents Index Master Index New Book

Checking the Number of Rows Processed in an SPL Routine

Informix Guide to SQL: Tutorial
Chapter 14: Creating and Using SPL Routines

Home Contents Index Master Index New Book