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.

• 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.

---