I have created a table with 50+ columns and trying to insert records into that table and I am getting error code 6706 : The string contains an untranslatable character.
Is there any function I can find which column is causing this problem. or Do I have to go through each column to find where this error occuring ?
If I just run select statement from Insert statement it works fine.
Provide more details on the interface being used to do the insert e.g., TPT, JDBC, fastload, BTEQ, etc.
You will have go through each column to check which one has untranslatable character.
Look into columns defined as CHAR.
Go through knowledge article KAP1F83B6 which provides more details about this issue.
You might try to create an error table for the target table and then do the INSERT/SELECT with LOGGING ALL ERRORS (I don't know if error 6706 is catched).
ETC_FieldID hopefully contains the ColumnId which can be matched to dbc.ColumnsV to get the column name.