Oh yeah, forgot about that. iSeries Navigator will also generate SQL for you if you like. You can pick a library or a table and have it generate SQL that can be pasted into CF for example.
On 3/6/07, Christopher Jordan <[EMAIL PROTECTED]> wrote:
EEK! The green screen! lol! ;o) Ron, if you've got access to the iSeries Navigator, you can add libraries, tables, fields, etc. There are certain limitations, but they may only apply to the super old version of the SQL engine that we're running on at my client. For instance I can't rename a column after I've created it. Man, I hope they've fixed stuff like that in more recent versions (we're due an upgrade somewhere in the third quarter of this year...) :o) Cheers, Chris Eric Knipp wrote: Ron - Just an FYI - you can create some code that will work using the interactive SQL tools on the AS/400. Its not a GUI but you can have it prompt you for stuff with F4 almost anywhere in the app. On 3/6/07, Jimmy Harrell <[EMAIL PROTECTED]> wrote: > > Ooops. Sorry about that Ron, my bad... I was too excited to help and I > misread what you were asking for :-) > > I believe Mike's example will work. > > > Jimmy L. Harrell > MBA: E-Business > *Website*: www.jimmyharrell.com > *Blog:* http://jimmyharrell.instantspot.com > *Local User Groups: *Dallas-Ft. Worth Adobe User Group<http://www.dfwaug.net/> & > Dallas-Ft. Worth Coldfusion User Group <http://dfwcfug.instantspot.com/> > ** > > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.instantspot.com/ > www.teksystems.com/ > > ------------------------------ _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/ -- http://www.cjordan.us _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
