Re: SQL pre-processor (was RPG IV release levels and complexity)

[rob@xxxxxxxxx]

CLI is included in base OS.

I believe that some CLI examples are in the RPG Sorcerer's redbook.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




Rich Duzenbury <rduz-midrange@xxxxxxxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/21/2003 03:08 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: SQL pre-processor (was RPG IV release levels and  complexity)







>
>I think the main issue is performance. I believe the process of 
>precompiling the SQL results in a more efficient means of performing the 
>SQL queries, which is often an important consideration for programmers 
who 
>choose static compiled languages, like C, RPG, and COBOL.

How much more efficient?


>But yeah, I agree - for flexibility, you can't beat an interpreted 
>language, like Python or Perl. I like how you can easily construct a 
query 
>dynamically in Python, and get the results back in a list along with 
>another list that describes the columns returned. Of course the cost of 
>that flexibility is run-time performance. But personally I think the 
>dynamic nature of SQL makes it a natural match for dynamic languages like 

>Perl or Python.

Any benchmarks on the static vs dynamic?  Doesn't the query manager cache 
any of this stuff?  Let's say the system runs the same OPNQRYF 5,000 times 

a day in 1,000 different jobs.  Isn't the access path available to all 
1,000 different jobs, or does it get built 5,000 times?   Same question 
for 
SQL access.

Where does java fit in to this?  Does it use a precompiler for the SQL 
statements or does it react like an interpreted language?


>Sure, if you want, you can do SQL programming in RPG without having to 
use 
>the preprocessor, using the SQL CLI. But I'm not sure if anyone has given 

>up on the SQL prep in favor of using the CLI.

Is the CLI available as part of the base OS, or is it only available with 
the extra SQL licensed stuff?

Is the CLI easy to use?

Thanks!

Regards,
Rich


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.