RDBMS Code:5356 in Datastage

Venky Sunil Kumar · Post by **Venky Sunil Kumar** » Tue Sep 25, 2012 1:55 am

Hi All,

I'm getting the below FATAL error when i run the job in DS.

RDBMS Code:5356 One of the characters or code point does not exist within the specified repertoire.
I have been using otranlsate function to search control characters(non printable characters) in custom query.

Can somebody explain about the error message...

ArndW · Post by **ArndW** » Tue Sep 25, 2012 3:36 am

Which database are you using?

If you specify the correct code page for the database in question within DataStage you shouldn't be getting mapping errors.

What is your database character set? What is the character set of your input/output data not in the database? What character set is triggering your error (Indian? Chinese? Cyrillic?)?

Venky Sunil Kumar · Post by **Venky Sunil Kumar** » Tue Sep 25, 2012 5:50 am

Thanks for your reply....
I'm using Teradata Database as source and target..we using UTF-8 for teradata.We triggering errors from Indian Character set.....

ArndW · Post by **ArndW** » Tue Sep 25, 2012 11:21 am

Is the error occurring on the read or the write?

venkateshrupineni · Post by **venkateshrupineni** » Wed Sep 26, 2012 4:21 am

if you have an issue when loading
try multi load using teradata connector stage