Print
Write debug messages to the console when running from Studio.
These print messages are available for the specific script being run, and are not carried across scripts. The print messages are displayed in Studio, as shown in the procedure that follows the syntax and example. If you turn on tracing, the message also appears in the log file.
Location
/lib/debug/
Syntax
print (IN textToPrint VARCHAR (4096))
Input
textToPrint: The text to write to the debug console.
Outputs
N/A
Exceptions
N/A
Example
PROCEDURE proc3()
BEGIN
CALL print('Test printing built-in.');
END
To verify a print message that you have defined
1. Right-click the examples node in the resource tree and select New SQL Script.
2. Type a name for the script and click OK.
3. On the SQL Script panel, type the “CALL print...” line shown in the example above.
4. Click the Execute button.
5. Verify that the text you specified appears on the Console panel.