RE: Can SQL recognize a nested data structure?

Where is a multiple row fetch used usually?  Can a stored proc use it?
But we don't need to fetch and can just pass the cursor itself I
thought. 

Thanks, 
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax


-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx] 
Sent: Tuesday, August 17, 2004 2:27 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Can SQL recognize a nested data structure?

Well, he did find a solution.  But I tried your example and got the same

error.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Dan Bale" <dbale@xxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
08/17/2004 02:18 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
RE: Can SQL recognize a nested data structure?






How about: 

     D iimds         e Ds                  extname(iim)
     D ds1             ds                  qualified
     D  rrn                          10s 0
     D  iimflds                            likeds(iimds)
     d ds2             ds                  likeds( ds1 ) occurs(10) 

and fetch into ds2?

Just a WAG.

db

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx / rob@xxxxxxxxx
> Sent: Tuesday, August 17, 2004 2:54 PM
> 
> Definitely some improvements at V5R3.
> 
> However this didn't work
>      D iimds         e Ds                  extname(iim)
>      D ds1             ds                  occurs(10) qualified
>      D  rrn                          10s 0
>      D  iimflds                            likeds(iimds)
> 

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


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