Re: Obtaining SQL Table schema with V4R5

[Bruce Vining <bruce.vining@xxxxxxxxx>]

If you're going to go to all that trouble why not just use List Fields
<https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/apis/quslfld.htm>.
It's been around (with appropriate enhancements over time) since V1R3.

On Sun, Sep 13, 2020 at 3:31 PM Mark Waterbury <
mark.s.waterbury@xxxxxxxxxxxxx> wrote:

> Patrik,
>
> You could also do something like:
>
>     DMPOBJ    library/filename    *FILE
>
> for the PF or LF for an SQL TABLE, INDEX or VIEW, and in that dump, search
> for the "associated space" and in there, you will find the SQL statements
> used to create the table, index or view -- (that 's where the QSQGNDDL API
> finds that stuff ...)
>
> Also true for programs with embedded SQL -- after the SQL precompiler does
> its thing, and invokes the regular compiler, the compiled object will end
> up having the SQL statements stored in an associated space.  For OPM *PGMs
> (SQLRPG or SQLCBL etc.) it will be in the "primary associated space" -- for
> ILE (SQLRPGLE or SQLCBLLE etc.) it will be in a secondary associated space
> -- each *MODULE has its own associated spaces.
>
> You can also use STRSST to create a dump of these objects, to a spool file.
>
> Mark
>
>
>
>
>
>
>
>
>
>
> On Sunday, September 13, 2020, 2:03:10 PM EDT, Patrik Schindler <
> poc@xxxxxxxxxx> wrote:
>
>
>
>
>
> Hello,
>
> V4R5 lacks the SYSIBM collection as well as a DESCRIBE statement.
>
> How can I retrieve the schema of a table in question?
>
> Could not find anything helpful online. V4 is a bit dated. ;-)
>
> Thanks!
>
> :wq! PoC
>
> PGP-Key: DDD3 4ABF 6413 38DE - https://www.pocnet.net/poc-key.asc
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com