Re: Obtaining SQL Table schema with V4R5

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Are the SYSTABLES and SYSCOLUMNS  etc not available on V4R5?



> On Sep 13, 2020, at 2:28 PM, Mark Waterbury <mark.s.waterbury@xxxxxxxxxxxxx> wrote:
>
> Patrik,
> See the QSQGNDDL API ... :-)
> Mark S. Waterbury
>
>    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