how could we convert the the data in binary to char
Posted: Thu Mar 24, 2005 2:38 am
Hi
i have extracted the data from DB2 Database through ODBC Stage, but most of the fields datatypes are binary.
how could we convert from binary to actual char format at the time of extraction itself.
for more info, DB2 Database resides on AS/400.
i think this may be a problem with the ODBC interpretation of AS400 data types. I know the AS/400 uses a "packed" format to store some data, and it appears that it may be interpreted as binary by the ODBC connection.
Thanks in advance
pongal
i have extracted the data from DB2 Database through ODBC Stage, but most of the fields datatypes are binary.
how could we convert from binary to actual char format at the time of extraction itself.
for more info, DB2 Database resides on AS/400.
i think this may be a problem with the ODBC interpretation of AS400 data types. I know the AS/400 uses a "packed" format to store some data, and it appears that it may be interpreted as binary by the ODBC connection.
Thanks in advance
pongal