SQL Type Bit to Binary Data Conversion Problem

vans2003 · Post by **vans2003** » Mon Feb 14, 2005 10:19 am

Hi,
I am converting Bit into Binay datatype in Teradata(Byte) using server job..

I am getting the following error message...

**** 09:49:03 UTY0805 RDBMS failure, 3857: Cannot use value (or macro parameter) to match 'Level_Type'.

Can someone Please find me a solution...

early reply would be appreciated...

Thanks in Advance...

Thx.
Vans

ArndW · Post by **ArndW** » Mon Feb 14, 2005 10:29 am

Hello Vans,

The column "Level_Type" has what definition in Teradata? Is the error dependant on the data you have (i.e. put in a fixed value in a transform for Level_Type) or does it abort on the first row?

vans2003 · Post by **vans2003** » Mon Feb 14, 2005 10:56 am

Level_type has defined as BYTE(1) in Teradata..
when I import metadata into Job Binay is SQL Type..

level_type input values are 1,0, source is SQL server with datatype Bit

I got following error message ........

TD_Main_Test..TD_ProdMast_Main: Unable to start MultiLoad process : MultiLoad failed: Check MultiLoad report E:DATA\temp\Test_Bit.rpt for details..

.rpt file has the following error message...

**** 09:49:03 UTY0805 RDBMS failure, 3857: Cannot use value (or macro parameter) to match 'Level_Type'.

Thanks,
Vans

ArndW wrote:Hello Vans,

The column "Level_Type" has what definition in Teradata? Is the error dependant on the data you have (i.e. put in a fixed value in a transform for Level_Type) or does it abort on the first row?

ArndW · Post by **ArndW** » Mon Feb 14, 2005 11:01 am

Vans,

does it abort on row 1? If you specify a fixed value derivation of "1" in a transform for this column instead of using the incoming data from the source, is the error the same?

vans2003 · Post by **vans2003** » Mon Feb 14, 2005 11:19 am

Hi,
I am getting the following error message when I hardcode the value "1" in transform..

TD_Main_Test..TD_ProdMast_Main: Invalid SQL column type for column Sample_Exists in stage TD_Main_Test.TD_ProdMast_Main

TD_Main_Test..TD_ProdMast_Main.trg: DSP.Open GCI $DSP.Open error -100.

Thanks,
Vans

ArndW wrote:Vans,

does it abort on row 1? If you specify a fixed value derivation of "1" in a transform for this column instead of using the incoming data from the source, is the error the same?

billsklar · Post by **billsklar** » Mon Feb 14, 2005 12:57 pm

Not sure if this will help but I needed to use the following command in the transformer when loading a binary value through DS:

Iconv(MappedColumn,"MX0C")

Apparently, DS converts binary to the numerical equivalent without this command.

vans2003 · Post by **vans2003** » Mon Feb 14, 2005 1:05 pm

still has same problem..
I tried with Iconv(DSLink1.Level_type,"MX0C")
Source is Bit Type and Target is Binary Type(Teradata)
need conversion...

Any suggessions would be appreciate.

Thanks,
Vans

ArndW · Post by **ArndW** » Tue Feb 15, 2005 1:51 am

Morning Vans2003,

I saw in the new error message
[TD_Main_Test..TD_ProdMast_Main: Invalid SQL column type for column Sample_Exists in stage TD_Main_Test.TD_ProdMast_Main
[/quote]

The the column in question is no longer Level_Type but Sample_Exists - what data type is that column?

(slowly but surely we are getting closer to a possible cause...)

vans2003 · Post by **vans2003** » Tue Feb 15, 2005 9:48 am

Sample_Exists and Level_Type are same binary datatypes on teradata

I am trying in two different jobs......

Thanks,
Vans

ArndW · Post by **ArndW** » Tue Feb 15, 2005 10:43 am

Vans2003,

I wish it were easier, but it now looks like an issue best given to Ascential Support. I don't have TeraData here otherwise I'd give it a try... I can't recall if TeraData supports ODBC connectivity - if it does it is worth trying that interface, as I've found the error messages through ODBC tend to be more descriptive and informative than going directly.

DSXchange