Since some of the prev replies have recommended learning & using SQL, I would strongly recommend understanding not just the coding of SQL, but the performance issues and indexing strategies.
The last thing you want is someone calling the system "slow". I just completed a project turning some .net'rs multiple joins high profile business analysis screen from a 3 minute (why is the system so slow...) to a comfortable 15 seconds with a few indexes built and getting the .net to not use logical files with select/omits... iNav's Visual Explain is a wonderful tool.

IBM has put major development $$ into enhancing DB2 for i.
Make sure management & the non-i developers know it's DB2 - a very standard, competitive, & robust database. I can't count the blank stares I get from people who think this is still some proprietery & strange database. Just tell them it changed when they were running Win98...
Start here:
http://www-03.ibm.com/systems/i/software/db2/awp.html

(the future never looks bright to people who want the fairy tale called "the good old days"..)
jim franz


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 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.