JR19420: Insert of timestamp date into an Oracle nickname truncates time portion replacing with 00:00:00.

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as program error.

Error description

• Insert of timestamp date into an Oracle nickname truncates time
  portion replacing with 00:00:00.
  
  Internal defect is 288442.
  
  Problem Scenario:
  set passthru v8ora
  DB20000I  The SQL command completed successfully.
  
  create table ts1 (cola varchar2(2) not null, coldate date)
  DB20000I  The SQL command completed successfully.
  
  set passthru reset
  DB20000I  The SQL command completed successfully.
  
  drop nickname ts1n
  DB20000I  The SQL command completed successfully.
  
  create nickname ts1n for v8ora.undjr18.ts1
  DB20000I  The SQL command completed successfully.
  
  insert into ts1n values ('no','2003-12-25-21.21.21')
  DB20000I  The SQL command completed successfully.
  
  select * from ts1n
  
  COLA COLDATE
  ---- --------------------------
  no   2003-12-25-00.00.00.000000
  

Local fix

Problem summary

•  This problem is fix in DB2 II fixpack 6.
  

Problem conclusion

•  Apply DB2 II 8.1 fixpack 6.
  

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

  IBM INFO INTEGR

• Fixed component ID

  5724C7400

Applicable component levels