Re: How would one generate the SQL "CREATE TABLE" statement for a file?

With iACS, run the Schemas option, then add the Schema where your table
is. Expand that Schema, and click on "Tables". Find your table,
right-click on it, and in the context menu you will find "Generate SQL".
As simple as that. It works also with DDS-created files.

JS

El mar, 10 oct 2023 a las 16:51, James H. H. Lampert via MIDRANGE-L (<
midrange-l@xxxxxxxxxxxxxxxxxx>) escribió:

Given an existing file, that was (at least according to DSPFFD)
originally created with an SQL "CREATE TABLE" statement, how would one
generate the SQL to recreate the file (just the structure, not the
contents)?

I'm guessing, just from what little I've read, that this is an easier
thing to do from Navigator than from a command line. Makes no difference
to me, as I wouldn't be the one doing it.

--
JHHL

--
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.