Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create inserts on table data

Status
Not open for further replies.

toxickpi

Programmer
Oct 20, 2009
2
UA
Hi!

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

Thanks

Artem
 
I guess i described the situation not clearly.

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.

Thanks.

Artem
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top