Re: Acucobol and DB2

tomstacky@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)


.

Relevant Pages

  • Re: Acucobol and DB2
    ... Having a problem with Db2 and Acucobol, ... and Oracle. ... cant change the entire application. ...
    (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. ... You might be able to use the CASE function as described in the DB2 ...
    (comp.lang.cobol)
  • RE: SQL2008: Fehler bei EXECUTE AS USER
    ... Procedure auf DB2 zugreift, weil dort wieder User U1 verwendet wird. ... Aber, deine Fehlermeldung deutet schlicht darauf hin, das der angegebene ... Account ausgeführt werden, da sonst die beschriebenen Daten nicht zur ...
    (microsoft.public.de.sqlserver)
  • 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)