RE: [WEB400] what does this man???

["Haas, Matt" <Matt.Haas@xxxxxxxxxxx>]

Juan,

SQLCOD -901 is an internal error in the SQL engine. The joblog should have more 
details about what caused it. If it doesn't, run the program in debug and you 
may get additional information.

Matt

-----Original Message-----
From: Juan Robledo [mailto:Juan_Robledo@xxxxxxxx]
Sent: Wednesday, November 03, 2004 5:03 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] what does this man???


Yes, it does. But now the real question why do i have a SQLCod0901 error 
code. lol.
more digging for me to do.

Thanks

Juan Robledo
Programmer Analyst





web400@xxxxxxxxxxxxxxxx
Sent by: web400-bounces@xxxxxxxxxxxx
11/03/2004 03:44 PM
Please respond to Web Enabling the AS400 / iSeries

 
To:     Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
cc:     (bcc: Juan Robledo/cmg/IRCorp)
Subject:          Re: [WEB400] what does this man???



> i have the following 0000090J in a numerical field, what does the J 
mean.
> I know it has something to do with a negative value, but my brain has 
been
> drain and this eludes me.

If you look up the EBCDIC code for numbers, zero is x'F0' and nine is
x'F9' with the other numbers falling in between.

So, the first 4 bits of a number in EBCDIC is always 1111 (or, hex F)...
effectively, those bits aren't used since they're always the same, right?
Well, IBM decided that rather than waste another byte to specify a
positive or negative sign, they'd just use those "unused" bits of the last
digit in the number.  By changing it from 1111 to 1101, they indicate that
the number is negative.

So, for the last digit, x'F0' - x'F9' represents the number 0-9 if it's a
positive number, and x'D0' - x'D9' represents the numbers 0-9 if the field
is negative.

In your example, you've got 0000090J.  The letter J is hex x'D1' in
EBCDIC -- it represents a negative number where the last digit is 1.
In this case -901  (if there are no decimal places, otherwise it might be
-0.901 or -9.01, etc)

In IBM's terminology the D in x'D1' represents the number's "zone" and the
1 represents the numbers "digit".  That's why this field is referred to as
a "zoned decimal" field, because digit of the number has a zone associated
with it. (The last zone indicates positive or negative.)

HTH



_______________________________________________
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.






-----------------------------------------
The information contained in this message is privileged and intended only
for the recipients named. If the reader is not a representative of the
intended recipient, any review, dissemination or copying of this message or
the information it contains is prohibited. If you have received this
message in error, please immediately notify the sender, and delete the
original message and attachments.
_______________________________________________
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.