Acucobol and DB2

From: tomstacky@xxxxxxxxx
Date: 26 Feb 2007 08:45:59 -0800

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.

-thanks

.

Follow-Ups:
- Re: Acucobol and DB2
  - From: HeyBub
- Re: Acucobol and DB2
  - From: Richard
- Re: Acucobol and DB2
  - From: Robert Jones

Prev by Date: Re: Reset data
Next by Date: Re: Acucobol and DB2
Previous by thread: Reset data
Next by thread: Re: Acucobol and DB2
Index(es):
- Date
- Thread

Relevant Pages

Re: Acucobol and DB2
... Having a problem with Db2 and Acucobol, ... and Oracle. ... cant change the entire application. ...
(comp.lang.cobol)
Re: Acucobol and DB2
... The same select works fine with VisualAge cobol and DB2 and Acucobol ... and Oracle. ... Are you sure about the account number? ...
(comp.lang.cobol)
Re: Acucobol and DB2
... The same select works fine with VisualAge cobol and DB2 and Acucobol ... Do you have EXEC SQL BEGIN DECLARE SECTION ... ...
(comp.lang.cobol)
Re: Acucobol and DB2
... The same select works fine with VisualAge cobol and DB2 and Acucobol ... the sqlcode is zero and the text fields are returned fine. ...
(comp.lang.cobol)
Re: Acucobol and DB2
... Having a problem with Db2 and Acucobol, ... and Oracle. ... cant change the entire application. ... You might be able to use the CASE function as described in the DB2 ...
(comp.lang.cobol)