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

[Roopanwita]

Hi,

My datastage job structure is like

Code: Select all

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 .

[ray.wurlod]

Where is the Raw data type being generated?

[Roopanwita]

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,

[Roopanwita]

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