ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Get DDL from Table

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Get DDL from Table

    Hi,

    Is it possible to get data definition language for a PF/LF ?

    Thanks,
    Manty

  • #2
    Re: Get DDL from Table

    Originally posted by manty View Post
    Hi,

    Is it possible to get data definition language for a PF/LF ?

    Thanks,
    Manty
    yes, through Navigator, Frog or using APIs, i also have a command that uses the API for download on my website under the downloads section http://tommyholden.com
    I'm not anti-social, I just don't like people -Tommy Holden

    Comment


    • #3
      Re: Get DDL from Table

      Thanks a lot. I am able to use QSQGNDDL API to generate SQL statements...

      However, the API introduced is introduced in systems for V5R1 and above. What about systems which are below the version levels V5Rx ? how to get DDL information ?

      Regards,
      Manty

      Comment


      • #4
        Re: Get DDL from Table

        Originally posted by manty View Post
        Thanks a lot. I am able to use QSQGNDDL API to generate SQL statements...

        However, the API introduced is introduced in systems for V5R1 and above. What about systems which are below the version levels V5Rx ? how to get DDL information ?

        Regards,
        Manty
        be prepared to hand code a lot of DDL...
        I'm not anti-social, I just don't like people -Tommy Holden

        Comment

        Working...
        X