RE: SQL Files - Source Based or Not?

Gord,

Having been off yesterday, I'm a little late so maybe others have answered
similarly.

Anyway, I use the Create New Table function within iNav's Database to create
SQL tables (Paul Tuohy showed me that), usually within a project library.
Then use the Generate SQL function to save the source for the table to a
source file member. It is necessary, in my opinion, to uncheck the "Format
for readability" box and later to edit the source to remove the project
library's name. Other than that, the source member then becomes the driver
when the project is pushed to production.

Jerry C. Adams
IBM i Programmer/Analyst
To compare baseball to other team games is to say the Hope Diamond is a nice
chunk of carbon. -Bill Veeck
--
A&K Wholesale
Murfreesboro, TN
615-867-5070

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gord Hutchinson
Sent: Tuesday, March 15, 2011 1:50 PM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: SQL Files - Source Based or Not?

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