Re: SQL vs DDS

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

"Al Barsa, Jr." wrote:
> We are currently examining the feasibility of putting enhancements like
> column level security into CL commands within TAA Tool.
> 

I understand the reasoning behind this, but it is not the command
process that is lacking. Commands can be issued from SQL to the
database. It is the DDS issue. Put in source and compile your files.
Will you be able to define User Defined Fields and Functions and then
reuse them in DDS? No.

Yes, I know, a lot of people don't have the SQL toolkit on their 400.

My question would be "Why not?". No administrator of another system
would consider installing the database product without the SQL toolkit
unless it were a standalone, non-development environment.

AS/400 users should NOT cripple themselves by not making the tools
available to their programmers. The defacto, primary tool of all
database professionals (outside of the AS/400) is SQL.

If cost is a limiting factor, get a development machine. Pricing of
these tools and others is VERY favorable at the P05 or P10 pricing
levels.

Production: 500 users, 530 4-banger. Development: 170 with SQL, Java,
RPG, COBOL and C. The fees saved in the languages more than cover the
cost of the 170. Not to mention the significant impact of removing
developers from the production environment.

With this scenario, there is no good reason that developers could not
choose the appropriate tool for whatever job they are facing.

-- 
===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---