RE: SQL vs. traditional I/O?

["Erich W. Schasse" <Schasse@xxxxxxxxxxxx>]

Joe,

what's about SELECT INTO ?

Define a DS:

D mxDS          E DS              EXTNAME(j4pp1)

and the following statement will do the job:

c/EXEC SQL
c/ select * from j4pp1 into :myDS where key1 = :mykey
c/END-EXEC

If there are two records with the same key, just ignore the coreesponding
sqlstate.

I'm sure, the ratio would no longer be 6:1.


Kind regards and a happy weekend

Erich W. Schasse

WIEDEMANN GmbH & Co. KG
IT/ORG
Wiedemannstr.
31157 Sarstedt
Tel. 05066/997-190
Fax  05066/997-366
mailto:schasse@xxxxxxxxxxxx
www.wiedemann.de



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Joe Pluta
Sent: Friday, July 23, 2004 1:12 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL vs. traditional I/O?


> From: James Rich
>
> Can this be restructured in such a way that it doesn't required
opening
> and closing the cursor for every iteration through the loop?

Feel free to tell me how.  If you cannot, you have to leave them in,
because that's what is necessary for a single record fetch.