RE: Teraspace, SQL, RPG

>I defined a MODS as OCCURS(32767) and ...

Ooops, I take is back 32766, no 67. The SQL preprocessor didn't like 67.
That what I get for not actually looking at my code before posting <G>.

-Walden


------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
  


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden H. Leverich
Sent: Tuesday, 22 March, 2005 18:12
To: RPG programming on the AS400 / iSeries
Subject: RE: Teraspace, SQL, RPG

Tim,

Never tried with teraspace (not sure RPG even support it) but I have
passed a user space back as a result set. I defined a MODS as
OCCURS(32767) and BASED on a pointer. I set the pointer to the user
space and issued the set results set for the MODS. You're limited to the
32767 limit of a MODS, but how many rows are you looking to return?

-Walden


------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
  

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