1 Reply Latest reply: Mar 12, 2014 2:10 PM by Bobfinan - Oracle-Oracle RSS

    DSNTIAR in Tuxedo Art Runtime

    indalo

      Hello.

       

      We have a cobol program using DSNTIAR for DB2 database.

      "CALL 'DSNTIAR' USING SQLCA ERROR-MESSAGE ERROR-TEXT-LEN"

       

      We are migrating the cobol program to Unix using Tuxedo Art Workbench version 12.

       

      Does anybody known how can we transform this utility to one for Oracle Database?

      Is there any utility for Oracle Database that return the error tesxt, as DSNTIAR does?

       

      Thanks in advanced.

      Best Regards.


        • 1. Re: DSNTIAR in Tuxedo Art Runtime
          Bobfinan - Oracle-Oracle

          Hi,

          Here is the usage description from the Pro*COBOL Programmer's Guide:

          Error Handling and Diagnostics

          DSNTIAR

          DB2 provides an assembler routine called DSNTIAR to obtain a form of the SQLCA that can be displayed. For users migrating to Oracle from DB2, Pro*COBOL provides DSNTIAR. The DSNTIAR implementation is a wrapper around SQLGLM. The DSNTIAR interface is as follows

               CALL 'DSNTIAR' USING SQLCA MESSAGE LRECL 

          where MESSAGE is the output message area, in VARCHAR form of size greater than or equal to 240, and LRECL is a full word containing the length of the output messages, between 72 and 240. The first half-word of the MESSAGE argument contains the length of the remaining area. The possible error codes returned by DSNTIAR are listed in the following table.

          Table 8-2 DSNTIAR Error Codes and Their Meanings

            

          Error CodesDescription

          0

          Successful execution

          4

          More data was available than could fit into the provided message

          8

          The logical record length (LRECL) was not between 72 and 240

          12

          The message area was not large enough (greater than 240)

           

          Regards,
          Bob Finan