|
midrange.com
If anyone else would like to apply 'pressure' on IBM I have reported this as a
problem and IBM has acknowledged that it is a BUG and has created a APAR to fix
it.
NOTE: V5R1 release level
The APAR that you could reference is: SE04519
I'm sure if others piggybacked onto this problem and others we could get IBM to
correct at least some (there are lots....) SQL pre-compiler bugs.
Andrew Lutz
Database Administrator
(916) 851-7140
alutz@pmigroup.com
>>> rob@dekko.com 03/13/02 06:46AM >>>
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.
_______________________________________________
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
