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 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.