RE: Using SQL as opposed to OPNQRYF

The SQL preprocessors are only provided if you license a copy of the SQL/400
product (or whatever the name is today).
The only thing IBM did with V5.1 was to increase the price of RPG IV on most
system by 4 times and throw in the other products with it that weren't
selling, such as COBOL, C, C++, CODE, etc.


Bob Cozzi
Cozzi Consulting
www.rpgiv.com


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Malchow, Grizzly
Sent: Monday, November 24, 2003 11:45 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Using SQL as opposed to OPNQRYF

Is there much of a performance difference between SQL and OPNQRYF? I
have never used SQLRPGLE and I was curious to know if it performed any
faster than OPNQRY does. Also can anyone tell me why I can create a
SQLRPGLE source member, prompt a C+ line in the source member and see
all of the fields that are available for a SELECT statement, but I can't
use the CRTSQLRPGI command to create the object? We are at V5R1, and I
was under the impression this was included with V5R1.

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