What is sqlca Informix stored Procedure

[Bosch]

I have heard that the stored procedure is declared in the transaction object as a local external function, I am moving to php-4.2.1 now and still looking for explanation how to use exeption handling in informix stored procedures.

[Adler]

Dynamic SQL refers to SQL statements that can be constructed and executed dynamically during run time, based on supplied user input.

To find out the sequence number generated execute sql:
SELECT DBINFO('sqlca.sqlerrd1') FROM systables WHERE tabid=1 ;

IDS SPL is an extension to SQL for implementing business logic in the form of modules in the database server. To call the SP execute SQL:
EXECUTE PROCEDURE GetSerialNumber() Many database applications need dynamic SQL capability when queries are not fully known up front during application design or implementation phases.

[Chingum]

Stored procedures assist in achieving a consistent implementation of logic across applications. The SQL statements and logic needed to perform a commonly performed task can be designed, coded, and tested once in a stored procedure. SQL statements that are known at the time the procedure is created are called static SQL statements. CREATE PROCEDURE TEST()
RAISE EXCEPTION -746, 0, "testing...";
END PROCEDURE Static statements have advantages, because these SQL statements are checked for syntactical and semantic correctness and optimized during procedure compilation.

[Pauline]

Stored procedures are extremely similar to the constructs seen in other programming languages. They accept data in the form of input parameters that are specified at execution time. With only static statements support in SPL, the requirement of SQL statements that are expected to be known only during run time (called dynamic SQL) cannot be achieved. Stored procedures can also improve performance. Many tasks are implemented as a series of SQL statements. Conditional logic applied to the results of the first SQL statements determines which subsequent SQL statements are executed.