RE: Integers with embedded SQL problem

WRKQRY will work if you adjust the column formating to 10.

>>> sublime78ska@yahoo.com 03/12/02 01:10PM >>>
Thanks, Andrew.  Now I understand.

It also won't work with UPDDTA or WRKQRY (if the value
is greater than 9 positions.)

Phil

--- Andrew Lutz <alutz@pmigroup.com> wrote:
> Phil,
>
> The problem is small integer and 4 digit binary look
> the same on the physical file (2 byte binary data)
>
> The DSPFFD while show a 2 byte binary field as a 4
> digit binary field
>
> Prompt this same field within ISQL and it is a Small
> Integer
> Operations Navigator will show this field as a Small
> Integer
>
> Place this in your h-spec in your RPG program and
> they will see 2 byte binary as small integer and 4
> byte binary as Integer
>  H EXTBININT(*YES)
>
> AND work with them as (5 I 0) and (10 I 0)
>
> A small integer WILL hold 32767
> A Integer WILL hold 2147483647
>
>
> I can work with these data types successfully with
> RPGLE and SQL
>
> NOT
>
> the DAM SQL pre-compiler
>
>
>
>
> >>> sublime78ska@yahoo.com 03/11/02 06:15PM >>>
> 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!?
Try FREE Yahoo! Mail - the world's greatest free email!
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.