Eric you wouldn't happen to have an instruction on this would you? Cause We've ran Iseries Nav and it's not abvious...:(
Thanks, Ron Mast Truth Hardware Webmaster 507-444-4693 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Knipp Sent: Tuesday, March 06, 2007 3:39 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: Re: [DFW CFUG] AS/400 gurus 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]<mailto:[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]<mailto:[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<http://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]<mailto:[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/<http://www.instantspot.com/> www.teksystems.com/<http://www.teksystems.com/> ________________________________ _______________________________________________ Reply to DFWCFUG: [email protected]<mailto:[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/> http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/<http://www.instantspot.com/> www.teksystems.com/<http://www.teksystems.com/> -- http://www.cjordan.us _______________________________________________ Reply to DFWCFUG: [email protected]<mailto:[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/<http://www.instantspot.com/> www.teksystems.com/<http://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/
