My Oracle Support Banner

ODPDRDA Sends 16 Char For A 4 Char Column (Doc ID 2515211.1)

Last updated on OCTOBER 15, 2019

Applies to:

Oracle Database Provider for DRDA - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Table with a CHAR(4 CHAR), type column.
  CREATE TABLE "TEST"."TABLE"
  ( "CODE" CHAR(4 CHAR),

When recovering the table from ibmdrda, Oracle is returning the column with a total size of 16 char left-padded with 12 empty spaces.
For example:
'code'
it returns
'code '

Trace of session in ODPDRDA shows the 12 empty spaces being sent:


Column 'CODE' SQLType(452,FCM) Prec(0) Scal(0) Len(16) Ccsid(1208); FIXED CHARACTER MIXED

Dumping 'QRYDTA' addr=0x13c9f0a size=162 bytes
00: FF004954 43412020 20202020 20202020 |..code |................|
10: 2020FF00 49544341 20202020 20202020 | ..code |................|
20: 20202020 FF004954 43412020 20202020 | ..code |................|
30: 20202020 2020FF00 49544341 20202020 | ..code |................|
40: 20202020 20202020 FF004954 43412020 | ..code |................|
50: 20202020 20202020 2020FF00 49544341 | ..code|................|
60: 20202020 20202020 20202020 FF004954 | ..co|................|
70: 43412020 20202020 20202020 2020FF00 |de ..|................|
80: 49544341 20202020 20202020 20202020 |code |................|
90: FF004954 43412020 20202020 20202020 |..code |................|
A0: 2020 | |.. |
Dumping 'QRYDTA' complete.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.