• 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
    FalconStor

    Begin Your Journey to the Cloud with Hybrid Cloud Date Protection and Disaster Recovery

    FalconStor StorSafe optimizes and modernizes your IBM i on-premises and in the IBM Power Virtual Server Cloud

    FalconStor powers secure and encrypted IBM i backups on-premise and now, working with IBM, powers migration to the IBM PowerVS cloud and on-going backup to IBM cloud object storage.

    Now you can use the IBM PowerVS Cloud as your secure offsite copy and take advantage of a hybrid cloud architecture or you can migrate workloads – test & development or even production apps – to the Power VS Cloud with secure cloud-native backup, powered by FalconStor and proven IBM partners.

    Learn More

    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