Re: Acucobol and DB2

On Feb 26, 7:39 pm, "Robert Jones" <rjon...@xxxxxxxxxxx> wrote:
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

Sorry that should be CAST not CASE

.

Relevant Pages

  • Re: How to determine database market share?
    ... with your meaningful contributions to to .oracle lists over the time ... It was not "Something about measuring database market penetration by ... > On the DB2 side, many of the people who are DB2 DBA's have been doing ... > On the SQL Server side, there are 2 questions involved, how many real ...
    (comp.databases.oracle.server)
  • Re: Migrating to Oracle on Windows
    ... I am looking into migrating a database from DB2 on z/OS to Oracle ... essentially no excuse for moving to Windows, ... The example I gave of migrating from DB2 on z/OS to Oracle on Windows ...
    (comp.databases.oracle.server)
  • Re: Adjusting to DB2
    ... I guess "tier 1" is the escape clause which means that Oracle is not available on all platforms at the same time when a new release or fixpack is made available. ... DB2 for Linux, UNIX, and Windows is always simultaneously available for Every release and every fixpack on all it's supported platforms. ... Ports to new platforms (e.g. if IBM decided to support Apple) are possible within a few weeks and can occur at a servicepack level. ...
    (comp.databases.oracle.server)
  • Re: Would Oracle be considered?
    ... Thats good for Oracle users, but personally I wouldn't touch Oracle with a 10 foot pole. ... I think, there is no other database with such performance, scalability and security features. ... IBM last week announced a free version of its DB2 database aimed at attracting application developers who might have ... DB2 Express-C is available to customers and developers as a free download, ...
    (borland.public.delphi.non-technical)
  • Re: Adjusting to DB2
    ... And that you are unfamiliar with many of the DB2 ... It is even more interesting that Oracle IS a single code ... > I prefer to tune all the SQL before it goes into production. ...
    (comp.databases.oracle.server)