I am using Teradata Parallel Transporter SQL Selector Operator Version 13.10.00.12.
I have a table with 5 columns , and have created a view on it for TPT by casting all columns as VARCHAR. A schema file gets created but the utlity fails with the error " TPT15105: Error 13 in finalizing the table schema definition"
I have read the posts regarding this error on this forum and checked the data format with the table definition and it seems to be matching. I have pasted below the table , view and schema definition.
CREATE MULTISET TABLE TABLE1 ,NO FALLBACK ,
I notice you tripled the size of each column in the schema (probably because you will be using a client session character set of UTF8?), except for the last one (active_ind).
Was this on purpose?
Thanks for your response.
Yes , we are using character set of UTF8 and for columns which are of CHAR datatype, are mutiplied only 2.
For all character types, while using UTF-8 character set, you have to triple the size. You have tripled it for the first four columns, and have doubled for the last column.