Re: How can I get the DDL to display using ACS's interactive SQL?

Jack, thank you.

I see it generates the Source file version. I did not see an option to
bring it up the other way, that is, on the PC screen in PC format that is
easier to read versus the source file format. Is there an option to do it
that way?

Darryl.

On Mon, Jan 18, 2021 at 11:49 AM Jack Woehr <
jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I often need to be able to display the definition(DDL) of a table whilst
using the interactive SQL.

CALL QSYS2.GENERATE_SQL('MYTABLE', 'MYLIB', 'TABLE', REPLACE_OPTION =>
'1');

--
Jack Woehr
Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021

NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain
confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further
distribution or use of this communication is prohibited. If you received
this communication in error, please contact the sender and delete/destroy
all copies of this communication immediately.
--
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