Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

create inserts on table data

create inserts on table data

create inserts on table data


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



RE: create inserts on table data

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.



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close