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

I believe that those who have given up and gone to CLI are in one of a few 
camps

1)  Would rather get the $$$ for developing, and the job security of being 
the only person who can maintain it.
2)  Need to find someone attractive and get a life
3)  Company would spend thousands for development but not one cent for 
purchasing software
4)  Just out-and-out frustration after waiting several releases and years 
for the precompiler people to do something.  (Glad to hear they do have a 
pulse now.)
5)  Want to distribute their software and figure their customers may have 
PHB's who are in category 3.

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




Hans Boldt <boldt@xxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/21/2003 02:43 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

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






Rich Duzenbury wrote:

> So why not get rid of this 'embedded' idea?  So far as I know, it's the 
> only architecture that tries to compile the SQL statements in to the 
> program.
> 
> I'm sure python can access an SQL database without having to use an SQL 
> preprocessor.  Java doesn't use this preprocessor idea does it?  I use 
> perl quite a bit on intel platforms, and it's no trouble to get access:
> 
> my $dbh = connect();
> 
> # Get last name, first name from the table
> my $sth = $dbh->prepare( "SELECT ulnam, ufnam FROM person") ;
> 
> $sth->execute;
> 
> while ($row = $sth->fetchrow_hashref) {
>     # do stuff with each row
>     print $row->{ulnam}, "\n";
>     print $row->{ufnam}, "\n";
> }
> 
> Frankly, I've been turned off from even trying to write SQL code on the 
> iSeries because of all of this problematic stuff I keep hearing about 
> the SQL preprocessor.  And, few of my clients have the extra SQL 
> licensed program.
> 
> I would really like to have SQL access from RPG that's as much of a 
> no-brainer as the perl code above.
> 

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.

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.

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.

Cheers! Hans


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