JR38224: FATAL ERROR IN SERVER ODBC JOB WHEN NVARCHAR COLUMN IS POSITIONED AS LAST COLUMN

APAR status

• Closed as program error.

Error description

• We getting a fatal error when last when nvarchar column is
  positioned as the last one in the column definition and one
  of the columns is timestamp.  We are reading from MS SQL server.
  This error is thrown irrespective of the table ddl & data. You
  can use any SQL server table having one nvarchar &
  timestamp column, example below is what I am testing.
  ODBC drivers version is DataDirect version 5.3.
  SQL>  create table testibm (timestamp datetime, data
  nvarchar(10));
  
  Enter SQL statements (Press ENTER to QUIT)
  
  SQL> insert testibm values (getdate(),"testdata");
  
  Enter SQL statements (Press ENTER to QUIT)
  
  SQL> select * from testibm;
  
  timestamp    data
  
  2010-11-04 11:39:24.830testdata
  
  Enter SQL statements (Press ENTER to QUIT)
  
  SQL>
  

Local fix

Problem summary

• Server ODBC job accessing MS SQL server table with timestamp and
  nvarchar columns aborts with error:
    DSD.BCIGetNext call to function SQLFetch failed.
    SQL statement:SELECT C1, C2 FROM TEST SQLSTATE=07006,
    DBMS.CODE=0 [DataStage][SQL Client]Unsupported data type
  

Problem conclusion

• Fixed the issue in the server code.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R810 PSY

     UP