• 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
    OCEAN User Group

    OCEAN TechCon25 Online

    It’s an Exciting Time for IBM i !

    July 16 & 17, 2025 – ONLINE

    Two virtual days of learning, presented by an outstanding group of IBM’ers and IBM Champions, featuring leading-edge topics.

    FREE for OCEAN members!

    Register NOW!

    Annual (12-month) Individual OCEAN Memberships are $80 and a Corporate Membership is $250. A Corporate Membership would allow your entire company to have full access to the OCEAN website & video library and to attend OCEAN events at member rates. Act now because rates are increasing on August 1, 2025.

    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

    • To Comfort The Afflicted And Afflict The Comfortable
    • How FalconStor Is Reinventing Itself, And Why IBM Noticed
    • Guru: When Procedure Driven RPG Really Works
    • Vendors Fill In The Gaps With IBM’s New MFA Solution
    • IBM i PTF Guide, Volume 27, Number 27
    • With Power11, Power Systems “Go To Eleven”
    • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
    • Izzi Buys CNX, Eyes Valence Port To System Z
    • IBM i Shops “Attacking” Security Concerns, Study Shows
    • IBM i PTF Guide, Volume 27, Number 26

    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