DSXchange

Posted: **Tue Apr 28, 2009 11:06 pm**

Hi,

My datastage job structure is like

Oracle table ---
                      --CDC-- target table (sybase)
Sybase table--

while running the job, job is aborting .
Error msg :No default type conversion from type "raw[max=10]" to type "string

In the both sources I have used SQL function to convert column into Varchar(Though the column is Varchar in both source & target). Still job is aborting with same error message.

Thanks in advance .

Posted: **Wed Apr 29, 2009 12:55 am**

Where is the Raw data type being generated?

Posted: **Wed Apr 29, 2009 1:10 am**

In the both tables datatype of column is varchar and in all stages (datastage), propragated the column value as varchar only. In the job or tables no where Raw datatype is mentioned.

One more observation : The column which is giving error, is present in Changed values of CDC( as per design requirement). If we remove that column from Changed value of CDC then job is running.
And error is in CDC stage (as per Log).

Thanks,

Posted: **Sun May 03, 2009 11:01 pm**

Hi,
Thanks for reply.
code is working now.
Thanks,

DSXchange

No default type conversion from raw[max=10] to string

No default type conversion from raw[max=10] to string