Re: Can't call QSQGNDDL on a V7R2M0 box.

[Alan Campin <alan0307d@xxxxxxxxx>]

You are trying to retrieve the DDL associated with a given DDS physical
file I am assuming.

The simplest and easiest way to do this is to use Operations Navigator
which is part of Client Access. If it was not already installed, have
someone install it on your PC and make sure they include the Database
options.

You can then go in as Mark said in a GUI environment and display all the
tables in a schema and by right clicking can request that the DDL for the
table be generated. You might want to include the option to include short
names. It will open up a window with the DDL extracted form the database
that you can save or copy.

On Sat, Jul 18, 2015 at 9:11 PM, Justin Dearing <zippy1981@xxxxxxxxx> wrote:

> Hello,
>
> I would like the CREATE TABLE DDL for a PF on my clients V7R2M0 system. I
> am QSECOFR on this system. The internet tells me that QSQGNDDL is a
> wonderful tool for doing that, and proceeds to tell me that DDL is the
> future and DDS is the past, which is great news for me because I'm a PHP
> programmer that knows SQL, and not DDS, or RPG.
>
> Unfortunately, this IBMi tells me "Command QSQGNDDL in library *LIBL not
> found." This is not great news for me.
>
>
> http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/apis/qsqgnddl.htm
> Indicates that this command still works in V7.2 (also it gave me stern
> warnings about the maintenance window). It doesn't say what library it
> would be in, or else I'd attempt to edit my library list, which is
> something I have not done in a decade, but understand in theory. What am I
> doing wrong?
>
> If there is an alternative methodology to "script" a PF to a CREATE TABLE
> statement, such as through PASE, I'm all ears. I'm actually much more
> comfortable at the PASE shell prompt than the green screen.
>
> Thanks,
>
> Justin
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.