How to Edit Create table query ?

User_L78WIFeb 3 2022 — edited Feb 6 2022

When? - while trying to do an insert from CSV using the ODI tool
What? - query generated with
create table public.C$_0NBAFILE( NAME STRING(50) , TEAM STRING(50) , NUMBER NUMERIC(12) , POSITION STRING(50) , AGE NUMERIC(12) , HEIGHT STRING(50) , WEIGHY NUMERIC(12) , COLLEGE TRING(50) ,SALARY NUMERIC(12);
Why? - Table name C$_0NBAFILE includes "$_" which is not supported.

Added on Feb 3 2022

#business-intelligence-applications, #data-integrator, #insert, #jdbc, #odi, #system-management-and-integration

2 comments

20 views