SQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition

Tools & Utilities
Teradata Employee

Re: SQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition

Well, without seeing the entire script, what you have shown me is a Selector operator retrieving 2 DECIMAL columns and a VARCHAR. Therefore, your schema must match.

-- SteveF
Highlighted
Enthusiast

Re: SQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition

Hi,

I am getting error even after giving excat match in schema as database defn.

only one thing I case see as issue is DATE column. in TPT it's saying either ANSIDATE or INTDATE is to be give, I have DATE column in database with format 'YYYY-MM-DD' what should be done to resolve this issue.

I have TPT 13.10.00.02

Kindly suggest

Regards,

Geeta A. Gwalani

Teradata Employee

Re: SQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition

It is not so much the FORMAT, as whether the data is being exported as an integer value, or a character string. If you are telling the database to export the data in ANSI date mode, then your schema has to be ANSIDATE. IF you are not, then you need to specify INTDATE.

-- SteveF