char for bit data
Posted: Tue Oct 16, 2001 8:22 am
Hi!
I use DataStage V4.1 and UDB V7.2.
When I code a job with DataStage Basic, I get problems with the datatype. In my UDB table there is a field defined as character for bit data. I would like to move this field from the source table to the target table.
layout of UDB tableA (source table):
FieldA1 char(5)
FieldA2 char(3)
FieldA3 char(10) for bit data only
layout of UDB tableB (target table):
FieldB1 char(5)
FieldB2 char(10) for bit data only
I use the ODBC connection. Which kind of data types should I use in the SQLBindCol and the SQLBindParameter calls?
When I use the binary data type, I get the following error:
An illegal SQL data type was supplied S1003.
When I use the character data type:
SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.
--> So I tried to specify the char(10) to char(20) but I still get the
--> same
error I also tried to change the SQL an use the HEX(FieldB2), but this didnt help me either.
Thanks! Regards,
An
I use DataStage V4.1 and UDB V7.2.
When I code a job with DataStage Basic, I get problems with the datatype. In my UDB table there is a field defined as character for bit data. I would like to move this field from the source table to the target table.
layout of UDB tableA (source table):
FieldA1 char(5)
FieldA2 char(3)
FieldA3 char(10) for bit data only
layout of UDB tableB (target table):
FieldB1 char(5)
FieldB2 char(10) for bit data only
I use the ODBC connection. Which kind of data types should I use in the SQLBindCol and the SQLBindParameter calls?
When I use the binary data type, I get the following error:
An illegal SQL data type was supplied S1003.
When I use the character data type:
SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use.
--> So I tried to specify the char(10) to char(20) but I still get the
--> same
error I also tried to change the SQL an use the HEX(FieldB2), but this didnt help me either.
Thanks! Regards,
An