Re: Size of a SQL result set

[rob@xxxxxxxxx]

My problem was a packed number in the middle.  Seems that x'00' can
determine the end of the field in a result set.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    rob@dekko.com
                    Sent by:                To:     rpg400-l@midrange.com
                    rpg400-l-admin@mi       cc:
                    drange.com              Fax to:
                                            Subject:     Size of a SQL result 
set

                    03/22/2002 03:35
                    PM
                    Please respond to
                    rpg400-l







I have the following code:
...
     D Parm1           DS                  Occurs(1)
     D  Valid                         1a
     D  Exception                     7a
     D  vLogin                      380a
      * Normally I would define vLogin with a like(login) but the @#$%ing
SQL precompiler
      * doesn't support a externally defined data structure as of V5R1.

     D Row1            S              1P 0 inz(1)
     D WorkDate        s               d

     D login         e ds                  extname(login)
...
     C/EXEC SQL
     C+ SET RESULT SETS ARRAY :Parm1 FOR :Row1 ROWS
     C/END-EXEC
...

But the Domino which calls this is only seeing a subset of vLogin.  Is
there a limit on the size of the elements within the result sets array?

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.