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