RE: Integers with embedded SQL problem

[rob@xxxxxxxxx]

1)  Doesn't look that way to me.
           Data        Field  Buffer    Buffer        Field    Column
Field      Type       Length  Length  Position        Usage    Heading
THENBR     PACKED      10  0       6         1        Both     THENBR

2)  If it did, then why did the UPDDTA or INSERT allow me to put
1,000,000,000 in the record?  This is not a valid binary value.

3)  It is not in reading the file with SQL that the error occurs.  It is in
trying to place the value received into a host variable defined as 10i that
it fails.

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



                    "Phil"
                    <sublime78ska@yah       To:     <rpg400-l@midrange.com>
                    oo.com>                 cc:
                    Sent by:                Fax to:
                    rpg400-l-admin@mi       Subject:     RE: Integers with 
embedded SQL problem
                    drange.com


                    03/11/2002 09:15
                    PM
                    Please respond to
                    rpg400-l






The file created with CREATE TABLE defines the INTEGER data type as 9B 0.

Try it out, then do DSPFFD.

I don't think it's the precompiler.

Phil

> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
> Behalf Of Andrew Lutz
> Sent: Monday, March 11, 2002 4:12 PM
> To: <
> Subject: Integers with embedded SQL problem
>
>
>
> All,
>
> I have this situation where the pre-compiler insists that small
> integer is 4B0 and interger is 9B0
>
> Has anyone found out how to insert the value that a small integer
> is capable of (32676) via embedded SQL?
>
>
>
>
> _______________________________________________
> 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.
>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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