Char 1 To Binary type

snassimr · Post by **snassimr** » Fri Mar 31, 2006 5:28 pm

Hi !

In my source I have Char(1) datatype of field . When I bring metadata to DS this field is Dispalyed as Binary(1) with symbol @ instead of a one letter

Does anybody know what's the point here ?

ArndW · Post by **ArndW** » Sat Apr 01, 2006 4:33 am

Unless you explain nobody will know the point.

1. What is your column defined as in your database DDL?
2. What is your column defined as in your source stage accessing the database in DataStage?

ray.wurlod · Post by **ray.wurlod** » Sat Apr 01, 2006 2:09 pm

Are you trying to view unconverted EBCDIC value?

snassimr · Post by **snassimr** » Sat Apr 01, 2006 4:41 pm

In DDS its defined Char(1) in Stage I accessing the field in DS the field defined as Binary 1. I accessed the field with another query tool and its seems ok and I see the content of the field ok.

ArndW · Post by **ArndW** » Sun Apr 02, 2006 2:10 am

If the database has it declared as CHAR(1) then why are you declaring it differently in DS and what happens if you keep the CHAR(1) in you DataStage job?

snassimr · Post by **snassimr** » Sun Apr 02, 2006 12:29 pm

Hi all !!!
The problem was resolved by assigning CCSID 424 for Hebrew
All fields were char represented in HEX format