Re: SQL Files - Source Based or Not?

Gord,

Even as sometimes I create SQL views and/or tables directly from either
iNav's SQL Script editor or using iNav's wizards, I always save the SQL
source (sometimes using iNav). Besides being easier, as you wrote, to
recreate a file, it can also make it easier to create a new view or table,
as long as it is similar to one already defined.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Tue, Mar 15, 2011 at 2:20 PM, Gord Hutchinson <gordm1@xxxxxxxxxxxxxxx>wrote:

We are (finally) going to begin creating some files with SQL instead of
DDS.

Are there any issues either way with using source-based SQL or not? I
would
think that source-based files would allow for more quickly recreating
files.

Any recommendations?


Thanks,


Gord

--
Gord Hutchinson

TST Overland Express
ghutchinson@xxxxxxxxxxxxxxx

--
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,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.