Import data from a tap-delimited file

[mittit]

Could anyone show me how to import data from a tab-delimited file (txt or csv) into a new Teradata table without having to write the CREATE TABLE statement again, given the column names defined in the source txt file? Is there a import function similar to the DTS in SQL Server?

 

[tdatgod]

without having to write the CREATE TABLE statement again....


When did you write it the first time? In teradata or another database?

Is it already defined somewhere in the Teradata database?

If so you could use the

Create Table as ....
with no data;

syntax.

 

[mittit]

Well, this is the scenario

I am working with Teradata RDBMS from 2 servers P, D. I have got an answer set from P and exported to a txt file in my workstation and want to import that table into the D server. Given that I have only Queryman 6 to do the task and don't want to create a table structure manually again.

Thanks

 

[tdatgod]

There is another tool for Doing this sort of thing called OLE-DB LOAD but I don't know if we still support this program.



does the answer set reflect a

sel *

or only specific columns?

you could do a

show qualified <query>

where <query> is the query you are running that will sipt out all the DML of all the views and tables involved in your query.

the word QUALIFIED is optional and if given will fully qualify the table names with the database names. I don't know if you need thast for what you are doing.

then you could open another queryman window on the second server and cut and paste the output from the first window to the second.


or if CUT and PASTE doesn't work write it out to a file and then read it back in.


you might want to ask this question over on

http://www.Teradataforum.com

as the developer who wrote SQL assistant monitors that web site .