l******9
发帖数: 579 | 1 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: error of importing data from txt file to IBM netezza SQL database
发信站: BBS 未名空间站 (Fri Nov 21 14:55:51 2014, 美东)
I would like to load data from a txt file (9 KB) to SQL IBM netezza database
in Aginity workbench.
After creating the table:
I right-clicked the table and go to "import data" tab and chose "comma" as
field delimiter and skip the first row for the header in the file.
The SQL query is:
INSERT INTO username.my_table // the table has 12 columns and all are
characters
SELECT * FROM
EXTERNAL 'C:\mypath\my_file.txt'
USING
(
DELIMITER ','
LOGDIR 'C:\temp'
Y2BASE 2000
ENCODING 'internal'
SKIPROWS 1
REMOTESOURCE 'ODBC'
ESCAPECHAR ''
)
But, I got error:
Unable to export the data to a file. Error: operations canceled.
Why it is "export", I want to do import.
Any help would be appreciated.
thanks |
|
