Informix using database stored procedures in DataWindow objects
You can use database stored procedures as a data source for
DataWindow objects. The following considerations apply:
Result set definition
You must define what the result set looks like. The DataWindow
object cannot determine this information from the stored procedure
definition in the database.
You cannot perform DataWindow updates through stored procedures
(that is, you cannot update the database with changes made in the
DataWindow object); only retrieval is allowed. (However, the DataWindow
can have update characteristics set manually through the DataWindow
Result set processing
You can specify only one result set to be processed when you
define the stored procedure result set in the DataWindow painter.
Computed rows cannot be processed in DataWindows.
PowerBuilder supports Informix syntax; however, the syntax
displayed in the DataWindow painter is the most general syntax.
You can leave the syntax unchanged or edit the displayed syntax
to conform to the Informix syntax rules. If you do not change the
syntax, PowerBuilder converts it to Informix syntax before passing
it to the Informix database.