Displaying Multiple Results Sets in Run SQL Scripts
October 15, 2008 Skip Marchesani
The SQL Script Center, which is part of the System i Navigator Database function, allows the user to execute a script that contains single or multiple SQL statements. If the script contains multiple SQL statements, the user has the option of executing a single SQL statement, the entire script (starting with first statement in the script and ending with the last statement in the script) or two or more consecutive SQL statements as a subset of the script.
The results from executing an SQL statement are shown in the lower portion of the Run SQL Scripts window called the Output