All Forums Database
Shishir 2 posts Joined 11/06
28 Jan 2008
import from csv to directly teradata table

Hi friends,Can anyone have the idea "how to import csv data directly into teradata tables?" I am using mload but i want to do it directly from csv to teradata table without using mload etc.

gander_ss 74 posts Joined 02/07
28 Jan 2008

Shishir can u tell how many cols and rows are there ???

Shishir 2 posts Joined 11/06
30 Jan 2008

There are approx 1000 rows and 10 columns

30 Jan 2008

If it is a one time thing, you can import from SQL assistant. If this is a task that should be done daily you have to create a MLOAD/FLOAD.assume the table name is TABLEAin the sql assistant click on FILE----->IMPORTDATAand in type this sqlInsert into tableA(?,?,?,?,?,?,?,?,?,?);? stands for col'sSQL assistant prompts for a file to import from choose the file name and the import is done.make sure that in SQL assistant TOOLS---->OPTIONS (EXPORT/IMPORT) tab In IMPORT sectionspecify the delimeter type and check the box (Ignore first record in the file) as per you file details.once the load is done click on FILE---->IMPORTDATA to disable this option.hope this helps.

You must sign in to leave a comment.