Re: Acucobol and DB2



On Feb 27, 5:45 am, 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

Do you have EXEC SQL BEGIN DECLARE SECTION ... END DECLARE around the
host variables ?


.



Relevant Pages

  • 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
    ... 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: PL/1 DB2 V8 Table Declaration for a CLOB
    ... I am writing a PL/1 program which will be reading a DB2 Table which ... has a column defined as a CLOB. ... I should use DCLGEN to obtain accurate SQL DECLARE TABLE ... should be declared by the magic DB2 statement: ...
    (comp.lang.pl1)
  • Re: Acucobol and DB2
    ... Having a problem with Db2 and Acucobol, ... and Oracle. ... cant change the entire application. ...
    (comp.lang.cobol)