越来越觉得对于一个中国女孩来说美国并不是一个可以找到靠山的地方。# Piebridge - 鹊桥
l*9
1 楼
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
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