You can use database stored procedures as a data source for DataWindow objects. The following rules apply:
-
Result set definition
You must define what the result set looks like in the DataWindow painter. PowerBuilder cannot determine this information from the stored procedure definition in the database.
-
Stored procedure arguments
The DataWindow painter provides the arguments for stored procedures only if the driver you are using to connect gives PowerBuilder the required information. If the arguments for the database stored procedure are not provided, you must define them.
-
DataWindow updates
Updates are not allowed for stored procedures in a DataWindow object. Only retrieval is allowed.
