On 10/18/2013 3:23 PM, Darryl Freinkel wrote:
I am using iNavigator to generate the SQL source for tables I havecreated.
It generates the code sort of okay. Going to a IFS file, the source is
great, but it uses the space beyond the 72nd character in the line and
makes it difficult to convert into a member in QSQLSRC. So I am using the
option to generate the source to a source file QSQLSRC.
Can't really help with the source physical file, but I would share that
we store our SQL in stream files that we use with iNav. Ours are named
like 'CustomerMaster.sql' and double clicking with Windows Explorer
fires up iNav's SQL app. One can select a single statement to execute,
or several. It's nice to have the SQL to create the table, views and
indexes all in one place. In a pinch, one can edit these with EDTF and
execute them with RUNSQLSTM, although that would require judicious
editing to make sure only the desired statements are processed.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact