O'Reilly logo

The Programmer’s Guide to iSeries Navigator by Paul Touhy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Run SQL Scripts

The Run SQL Scripts editor is more than just an SQL script editor; it is also the equivalent of the Start SQL (STRSQL) command on green screen. It also has the added benefit of not requiring you to purchase DB2 Query Manager and SQL Development Kit (5722ST1) so that you can issue SQL statements.

The previous section on SQL Scripts introduced the editor as a means of entering and manipulating SQL scripts for DDL, but you can just as easily use it to test Data Manipulation Language (DML) statements like SELECT, INSERT, UPDATE, and DELETE.

To open the editor, select Run SQL Scripts... from the context menu of the database name (not the Schemas option or a Schema Name). You are presented with the window shown in Figure 5.8.

Figure ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required