Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Informix CLOSE – PB Docs 126 – PowerBuilder Library

Informix CLOSE – PB Docs 126

  2. Powerbuilder Documentation
  3. Powerbuilder Documentation Older
  4. Powerbuilder Documentation 12.6
  5. Informix CLOSE – PB Docs 126

Informix CLOSE

If a database stored procedure returns a result set, it must
be closed when processing is complete.

note.png Do you have to retrieve all the rows?

You do not have to retrieve all rows in a result set to close
a request or procedure.

Closing a procedure looks the same as closing a cursor:

As with cursors, if a procedure executes successfully and
returns at least one result set and is not closed, a result set
is pending and no SQL commands other than the FETCH can be executed.
Procedures with result sets should be closed as soon as possible.

The procedure remains open until you close it, execute a COMMIT
or a ROLLBACK, or end the database connection.

Document get from Powerbuilder help
Thank you for watching.
Powerbuilder Documentation 12.6
and Functions Events Objects and Controls PB Docs 126 PowerBuilder .NET Powerbuilder Documentation Powerbuilder Documentation 12.6 Powerbuilder Documentation Older PowerBuilder Extension Reference PowerBuilder New Features 12.6 PowerDesigner Integration System Object Properties Using the ADO.NET Interface
August 14, 2023
Was this article helpful?
2
2
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x