RE: Integers with embedded SQL problem

[rob@xxxxxxxxx]

What we're discussing here is different.  You are talking about how the
file stores the value and I am talking about how the RPG processes the
data.  Perhaps my file was created as a DEC and not a INT.  Who cares?  The
point is that the SQLRPGLE could not store this into a 10i field because
the precompiler decided to make my 10i work field a 9b field.
Or is your point that not only is this stupidity in the precompiler but in
the database itself?

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/12/2002 08:07
                    PM
                    Please respond to
                    rpg400-l






Rob,

Well that's interesting.  I get a different result.  Here's what I did and
the result:

1. create table qtemp/phil (fld1 integer not null with default)

2. dspffd qtemp/phil

Field Level Information
             Data        Field  Buffer    Buffer        Field    Column
  Field      Type       Length  Length  Position        Usage    Heading
  FLD1       BINARY       9  0       4         1        Both     FLD1

Phil

> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
> Behalf Of rob@dekko.com
> Sent: Tuesday, March 12, 2002 8:26 AM
> To: rpg400-l@midrange.com
> Subject: RE: Integers with embedded SQL problem
>
>
>
> 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.
>
>
>
>
>
> _______________________________________________
> 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.