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.
-
DataWindow updates
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 painter.)
-
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
Computed rows cannot be processed in DataWindows.
-
Informix syntax
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.
