Re: changing keys of a physical file

And there's nothing stopping anyone from using iSeries Navigator, etc 
against a file created with DDS to add/alter a field and thus obsoleting 
your DDS.

Once again, it's not the tool, it's how the tool is used.

And who cares if you don't have the original SQL source?  The file should 
never get deleted, if so, you should have a backup of the file itself to 
restore it.  What does the original SQL source tell you that most 
utilities don't?

Rob Berendt
-- 
"All creatures will make merry... under pain of death."
-Ming the Merciless (Flash Gordon)




PaulMmn <PaulMmn@xxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/22/2003 11:28 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Fax to

Subject
Re: changing keys of a physical file






SQL scares me, not because of the things it can do, nor because I 
don't understand it fully, but because it's so undisciplined.

With DDS, you have the source code, it's compiled, approved, 
promoted, and distributed.

With SQL, unless you're -very- disciplined (and use RUNSQLSTM (which 
you then archive)), it's all too easy to STRSQL, do some stuff, and 
exit.  And your work is not documented, not approved, and, most 
importantly, not repeatable.

--Paul E Musselman
PaulMmn@xxxxxxxxxxxxxxxxxxxx




Rob wrote (in part):

>However, if the goal is to keep the same key, but add other keys then you
>may wish to use SQL to create indexes.  If you are SQL phobic you can
>always create logical file DDS from scratch and use that to create your
>indexes.
>
>Rob Berendt
_______________________________________________
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.