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

True enough - Bob Cozzi published that command in 2003 - it uses the
QSQGNDDL API that has been mentioned here. Good stuff! You can find it
online if you want to - still, let's use one of the services IBM are giving
us - or the functionality that is in ACS. The services can be done
programmatically, the ACS tool lets you select multiple (I believe) items
and generate them


Cheers
Vern

On Thu, 12 Oct, 2023 at 8:19 AM, Gad Miron <gadmiron@xxxxxxxxx> wrote:


To: midrange-l@xxxxxxxxxxxxxxxxxx

There is/was a utility named RTVSQLSRC

Gad

from: Rob Berendt <robertowenberendt@xxxxxxxxx<mailto:

robertowenberendt@xxxxxxxxx>>

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

GENERATE_SQL_OBJECTS procedure - IBM Documentation
<

https://www.ibm.com/docs/en/i/7.5?topic=services-generate-sql-objects-procedure

On Tue, Oct 10, 2023 at 6:51?PM James H. H. Lampert via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>

wrote:

*******************************************

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:
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<mailto:
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<mailto:
support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

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