1
What is the function of suspend in a Procedure in the Firebird?
3 answers
2
It seems to me, with a very quick Google search, suspend suspends the execution of a trial that is bringing a result table (result set) until the caller asks to bring the rest of the results.
Sources:
"Only for SELECT procedures which Return Tables: Waits for the client to request the next line. Returns the next line to the client." http://www.destructor.de/firebird/storedproc.htm
"The SUSPEND Command informs the Stored Procedure to suspend execution until data is requested by the client." http://www.devmedia.com.br/while-e-for-no-firebird/16734
1
In a stored Procedure, the function of the suspend is to send a current result line of the output parameters (returns). At each suspend, a new line is sent as a result.
1
The function of suspend in a SP (Stored Procedure) is to suspend the code on that line prior to suspend and print on the screen the result of that code, basically the same as saying "print". In an allusion the basic programming (C++) would be equivalent to the printf.
Browser other questions tagged sql procedure firebird
You are not signed in. Login or sign up in order to post.