• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Build SQL to Define Your Existing Files, Revisited

    June 12, 2002 Timothy Prickett Morgan

    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.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: mgo_rc, Volume 2, Number 45 -- June 12, 2002

    Sponsored by
    New Generation Software

    “Fixing Your Data Supply Chain”

    FREE Webinar

    You’ve optimized your business processes, products and services, but is there still a logistics gap between your data and your managers and analysts?

    See how NGS-IQ simplifies query, reporting, data visualization, and analytics tasks. Enjoy Microsoft 365 integration, multidimensional modeling, built-in email, and FTP – with IBM i security and performance.

    October 23, 2025, 11am Pacific/2pm Eastern

    RSVP: https://ngsi.news/chain

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Searching the Information Center Reader Feedback and Insights: Group Job Limitation

    Leave a Reply Cancel reply

MGO Volume: 2 Issue: 45

This Issue Sponsored By

    Table of Contents

    • Reader Feedback and Insights: Printing Leading Zeros in Query/400, Another Look
    • String Parameters of Various Lengths, Take Two
    • Build SQL to Define Your Existing Files, Revisited

    Content archive

    • The Four Hundred
    • Four Hundred Stuff
    • Four Hundred Guru

    Recent Posts

    • Positive News From The Kyndryl Mainframe Modernization Report
    • NAViGATE, inPower 2025 On Tap for September 2025
    • Guru: WCA4i And Granite – Because You’ve Got Bigger Things To Build
    • As I See It: Digital Coup
    • IBM i PTF Guide, Volume 27, Number 37
    • AI Is Coming for ERP. How Will IBM i Respond?
    • The Power And Storage Price Wiggling Continues – Again
    • LaserVault Adds Multi-Path Support To ViTL
    • As I See It: Spacing Out
    • IBM i PTF Guide, Volume 27, Numbers 34, 35, And 36

    Subscribe

    To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

    Pages

    • About Us
    • Contact
    • Contributors
    • Four Hundred Monitor
    • IBM i PTF Guide
    • Media Kit
    • Subscribe

    Search

    Copyright © 2025 IT Jungle