|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/28/2008 12:04:31 PM
Posts: 9,
Visits: 7
|
|
Hi All,
I have exported a table to a file using the export facility of SQL Assistant.
The export was successful and the file was created.
Please help me to import the file.
Thanks.
Nisith Bhattacharya
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 6/9/2009 8:56:43 PM
Posts: 21,
Visits: 18
|
|
Insert into tablename values (?,?, etc) where each ? correlates with a field in you target table. Run the query and you will be prompted for the file that you wish to load.
Hope this helps
DavidPracy
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 7/5/2009 2:58:22 PM
Posts: 134,
Visits: 13
|
|
I believe you will have to remove the column header information from the file that you intend to load.
Thanks,
Vinay Bagare
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/28/2008 12:04:31 PM
Posts: 9,
Visits: 7
|
|
Thanks David/Vinay,
Indeed the columns headers needs to removed from the file other wise it leeds to unexpected results.
Instead while exporting if the column headers are not included then the import would be easy.
Can u please tell me some thing about ?b and ?c used while importing?
Thanks
Nisith Bhattacharya
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 1/23/2009 10:28:48 AM
Posts: 1,
Visits: 3
|
|
I was doing Import In sql Assistant and received
Code = 5. A data value on record 1 is too long for the parameter buffer. Increasing the buffer size on the Export Options may help.
Any idea?
Mjaner
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/30/2009 8:23:16 AM
Posts: 1,
Visits: 1
|
|
Increase your SQL Assistant import buffer size to fit with the size of your data field : access SQL Assistant menu/options/importexport/import/buffersize
Hope it helps,
Dr. Nguyen Manh-Tho
PS Consultant
Analytical Solutions
Teradata Certified Master V2R5
Teradata GmbH
Storchengasse 1
1150 Wien
Sitz der Gesellschaft: Wien
Firmenbuchnummer: FN 293355f
Firmenbuchgericht: Handelsgericht Wien
+43-1-891118-0 – office
+43-664-1109184 – mobile
manh-tho.nguyen@teradata.com – email
http://www.ifs.tuwien.ac.at/~tho – web
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/20/2009 1:44:00 AM
Posts: 7,
Visits: 10
|
|
Can We load only specific columns using SQL Assistance
If so please send me the process.
Thanks
kiran
KIRAN
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/27/2009 2:25:09 PM
Posts: 2,
Visits: 11
|
|
Starting at page 42 -- in the Teradata SQL Assistant for Microsoft Windows User Guide -- talks about importing. (do a web search to find the doc). I think your answer is there.
Alan
|
|
|
|