SQL Type Bit to Binary Data Conversion Problem
Moderators: chulett, rschirm, roy
SQL Type Bit to Binary Data Conversion Problem
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
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
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?
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Bit to Binary Conversion error
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
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?
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?
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
SQL Type Bit to Binary Data Conversion Problem
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
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?
Re: SQL Type Bit to Binary Data Conversion Problem
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...)
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...)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>