HomeAppeon Web | Appeon Mobile | Appeon PowerBuilderAppeon Online Help Center

Informix retrieval using database stored procedures

Qualification

PowerBuilder uses a construct that is very similar to cursors to support retrieval using database stored procedures. In PowerBuilder embedded SQL, there are four commands that involve database stored procedures:

  • DECLARE procedure_name PROCEDURE FOR . . .

  • EXECUTE PROCEDURE procedure_name

  • FETCH procedure_name INTO . . .

  • CLOSE procedure_nameRetrieval only

See also

Informix DECLARE and EXECUTE

Informix FETCH

Informix CLOSE

Prev  Up  Next
Informix database stored procedures  Home  Informix DECLARE and EXECUTE