|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.