Re: Acucobol and DB2
- From: "Richard" <riplin@xxxxxxxxxxxx>
- Date: 26 Feb 2007 18:50:41 -0800
On Feb 27, 3:33 pm, "HeyBub" <heybubNOS...@xxxxxxxxx> wrote:
tomsta...@xxxxxxxxx wrote:
Hi,
Having a problem with Db2 and Acucobol, Selecting numeric values.
The same select works fine with VisualAge cobol and DB2 and Acucobol
and Oracle.
I can fix the problem by changing the COMP values to COMP-3, but I
cant change the entire application.
Here is an example:
The account number in the database is 20012
The acucobol/db2(udb) select returns: 961413120
the sqlcode is zero and the text fields are returned fine.
I can get 961413120 to map to 20025. Are you sure about the account number?
961413120(10) => 394E0000(16), 4E39(16) => 20025(10)
He probably should be using PIC S9(9) COMP-5 or whatever is accucobol
for native long integer. Your calcs show it is probably a byte
ordering issue.
.
- References:
- Acucobol and DB2
- From: tomstacky
- Re: Acucobol and DB2
- From: HeyBub
- Acucobol and DB2
- Prev by Date: Re: Acucobol and DB2
- Next by Date: Re: "WAIT" command?!
- Previous by thread: Re: Acucobol and DB2
- Next by thread: Cobol source code for a text adventure
- Index(es):
Relevant Pages
|
