Re: Performance & SQL coding

[MacWheel99@xxxxxxx]

>  SQL has the coding methods to avoid poor performance, but it is very
>  easy to cause poor perfromance with SQL.

I am new to SQL - we converted to BPCS 405 CD from BPCS/36 last year & I am 
covered up with lots of aftermath implications - one of which is learning how 
to use SQL productively.

IBM just has the single 3 day SQL class & I am signed up for it

I guess what I will need is good reference materials that advise how best to 
program in SQL/400 that avoids the bad practices of which you speak.

May I presume that those of you doing analysis of your perfomance dogs are 
discovering that the inexperienced SQL programmers are apparently on the 
staff of SSA & that these problems are not purely in-house errors of 
omission, so that OSQ will have lists of upgrades needed?

There is another problem.

We have end users creating queries.

They are able to figure out which file contains the data they need, thanks to 
the wonders of external file descriptions, but my end users are not using the 
available logicals - it is almost too much to ask that a non-programmer 
comprehend their importance & the performance hit taken by not using them.

Al
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---