Can you help me?
I need to create inserts on table data in order to make installation script.
I looked up in Sql Assistant, Teradata Administrator but haven't found.
it is possible to write smth on VBA or C#, but I haven't time
I have to make some procedure, programm or use functionallity of some tool to make inserts on any table in Teradata. Usually, RDBMS have management tools with such functionallity.
I used PL/SQL Developer to make such inserts in Oracle (ofcourse it is 3d party tool, but it is free for use).
But I haven't found such functionality in Teradata tools.
I started to make procedure, wich would make inserts on any table.. it uses 2 parameters: database name, table name, and works with DBC.Columns to know the structure of the table.
But my knowledge of Teradata is poor.. in Oracle I would make it much faster.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.