Build SQL to Define Your Existing Files, Revisited

Hey, Ted:

In the June 5 issue of Midrange Guru, OS/400 Edition, you explained how to use the QSQGNDDL API to generate SQL to create SQL Data Definition Language (SQL DDL) for existing objects. I'm writing to mention that you can do the same thing without any programming through Operations Navigator (OpsNav).

-- John Valance

Thanks for bringing it up, John. Here are the steps:

When you open the connection to the iSeries machine, you'll see a Database option in the navigation pane. When you click on Database, the tasks panel (across the bottom of the window) will be refreshed with database tasks. Choose Run an SQL script.

A new window opens. Pull down the Edit menu and select Insert Generated SQL.

The General SQL window opens. Click on the Add… button.

The Edit list of objects window opens. You should see a list of libraries in the left panel. (You can add or remove libraries by clicking on the Select libraries… button.) When you expand a library, you will have options for the various types of objects, such as tables and views.

Select the objects for which you want SQL DDL, clicking the Add button to add them to the Objects to process: panel. Click OK when you have finished selecting objects.

You'll return to the Generate SQL window. Click Generate.

John, thanks for sharing this information with your fellow Midrange Guru readers.

-- Ted

Sponsored By TRAMENCO

iSeries and AS/400 Connection Conference Join your colleagues at the ultimate iSeries and AS/400 conference June 16 – 19. Sign up for the iSeries and AS/400 Connection Conference in beautiful Naples, Florida. To register, or to view the complete course agenda, click to www.tramenco.com/naples. Reserve your spot today.