RE: Can SQL recognize a nested data structure?

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