RE: Can SQL recognize a nested data structure?

Happy baby!

On Wed, 18 Aug 2004 08:46:42 -0500, "Gina M Whitney"
<whitneyg@xxxxxxxxxx> said:
> 
> Rob wrote: I wish the person from the precompiler
> team on this list would pipe up on this one, or
> related occasions.
> 
> I had a baby 5 months ago and have been off for 3
> months and working part time since then (I'll be
> back to full time soon).  I have not had a lot of
> time to keep up with this list. I get the list in
> digest mode, so I don't get the questions as fast
> as some of you.  I also wait a while to see if the
> question gets answered by other members of the list,
> which is almost always the case.  If it hasn't been
> answered and I know the answer off hand, I do try to
> pass it on.   I don't know all the ins and outs of
> SQL statements and performance, so I won't be able
> to answer such questions without doing some
> investigation, which probably won't happen since
> customer problems/questions are supposed to come to
> me through the proper IBM channels.
> 
> 
> d JPP010        e ds                  qualified
> d DS1             ds                  occurs(10)
> d   RRN                         10s 0
> d   JPPfields                         likeds(JPP010)
> 
> The precompiler just started to support LIKEDS in
> V5R3 so JPPfields would not be defined on a previous
> release.
> 
> Rob's example from v5r3:
> D iimds         e Ds                  extname(iim)
> D ds1             ds                  occurs(10) qualified
> D  rrn                          10s 0
> D  iimflds                            likeds(iimds)
> 
> Using DS1 in a blocked fetch is not valid since the precompiler
> does not generate an SQL_xxxxx variable, but passes the array itself.
> The runtime code knows what the subfields are by the information that
> the precompiler passes it.  In this case runtime knows the subfields are
> numeric 10 and a structure.  There is no SQL type structure, so an error
> is issued.
> 
> d JPP010        e ds                  occurs(10)
> d   RRN                         10s 0
> This would work in a blocked fetch since runtime sees all the subfield
> types, no structures.
> 
> 
> 
> Guy wrote:c+ fetch from C1 for 10 rows into :..
> for a while and can't get past
> SQL0221  30      15  Position 23 Number of rows 10 not valid.
> 
> Your host variable needs to be defined as an array of size 10 or larger.
> 
> 
> Hope this helps.
> Gina
> 
> --
> 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.
> 
-- 
  
  michaelr_41@xxxxxxxxxxxxxx