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

But to divert into the realm of "wild and crazy ideas", apart from SQL, the thought occurred to me that it might be possible to add some framework into the RPG compiler to implement a sort of generalized processing of 3rd party embedded statements. That is, if you coded something like "exec xyz ...;", exits for component "XYZ" would be invoked which would return RPG statements to include in place of the exec statement. Anyways, I seriously doubt if anything will come out of such flights of fancy since it would need a lot of work in the compiler, but it's fun to imagine the possibilities.

Cheers! Hans

# Get last name, first name from the table
my $sth = $dbh->prepare( "SELECT ulnam, ufnam FROM person") ;

while ($row = $sth->fetchrow_hashref) {
    # do stuff with each row
    print $row->{ulnam}, "\n";
    print $row->{ufnam}, "\n";
}

Regards,
Rich