Re: Acucobol and DB2

From: "Robert Jones" <rjones0@xxxxxxxxxxx>
Date: 26 Feb 2007 11:39:10 -0800

On Feb 26, 4:45 pm, 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.

-thanks

You might be able to use the CASE function as described in the DB2
language reference manual

.

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

References:
- Acucobol and DB2
  - From: tomstacky

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

Relevant Pages

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 ... and Oracle. ... Are you sure about the account number? ...
(comp.lang.cobol)
Acucobol and DB2
... 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, ...
(comp.lang.cobol)
Re: Acucobol and DB2
... Having a problem with Db2 and Acucobol, ... and Oracle. ... cant change the entire application. ...
(comp.lang.cobol)