Skip to content

Db2 FOR BIT DATA data types are unsupported #1655

@nj1973

Description

@nj1973

Describe the bug
The two FOR BIT DATA data types in Db2 to not validate.

,   col_char_bit    CHAR(5) FOR BIT DATA
,   col_varchar_bit VARCHAR(5) FOR BIT DATA

I inserted "ABC" into col_char_bit and when selecting it back I get hex output:

$ db2 "select col_char_bit,cast(col_char_bit as varchar(30)) from pso_data_validator.dvt_
db2_types;"

COL_CHAR_BIT                2                                                              
--------------------------- -------------------
x'4142432020'               x'4142432020'    

We need to figure out how to get back to the original value.

What version of DVT are you using?
8.4.0

What type of connections are you using for source and target?
Db2

Metadata

Metadata

Assignees

No one assigned

    Labels

    type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions