How do you suppress the message that is displayed when your program processes an EXECUTE statement?
You may do this by use of the "CAPTURING" clause. Anytime an EXECUTE is processed in a program, the results will be displayed. Whether a successful, or an unsuccessfull select has occurred, there will always be output. Sometimes this output may cause the screen to scroll, so you may consider suppressing the output.
Example:
[404] 103 Items selected from 1227 possibles.
This message is there to show that the EXECUTE was successful and resulted in 103 records being selected.
Any EXECUTE will result in some type of response. Common examples would be SELECTS and GET-LISTS.
Here is how you would suppress the output message:
The format for use of the CAPTURING clause as part of an EXECUTE statement requires that the word 'CAPTURING" be followed by the name of the variable into which you would like the results stored.
In the first example "[404] 103 items(s) selected from 1227 possibles." will be stored in the variable called OUTPUT.
By adding the CAPTURING OUTPUT, you have successfully suppressed the resulting message. Give it a try!
Bakken Software Services ... The Obvious Pick 1-708-450-1062