DSXchange

Looks like and character set conversion issue. 0x1A is substitue character and I think it will remain the same for all the bad characters. So, you can try ereplace() on that.

Hi, When reading a varchar column in an excel sheet - that can also contain numeric values too- using the unstructured data stage, the long numeric values are getting converted to float. The target column is also a varchar column. E.g., C101,4566 --->is read as ---> C101,4566 but 946253745 ---> is r...

Hmmn... Will see if it an issue from the database side. Just wanted to check if there is this issue was faced someone else who has a quick root cause.

Thanks Ray for your replies.

No. The same user id is used. The script that invokes this job has a retry logic. It resubmits the job after a initial failure. The job succeeds in the 2nd try.

Thank you.

HI, We are getting the following errror frequently in our jobs. We are using a ODBC connector stage to connect to Informix databases. Native error code = -211; Cannot read system catalog(systables). This is resolved when we run the job again. We are not reading any system catalog tables in our custo...