有一只狗给我们的shelter赢了1万块钱# pets - 心有所宠
l*9
1 楼
I would like to export a data table from IBM netezza SQL daatbase in Aginity
workbench to a txt file on win 7.
I called The sql query from C# in visual studio 2013:
CREATE EXTERNAL TABLE 'C:\path\my_name.txt'
USING
(
Y2BASE 2000
ENCODING 'internal'
REMOTESOURCE 'ODBC'
ESCAPECHAR ''
)
AS
SELECT *
FROM admin.my_table
I logged in as admin in the database. But, I got error:
Exception captured: System.Data.Odbc.OdbcException (0x80131937):
ERROR [HY000] ERROR: CREATE EXTERNAL TABLE: permission denied.
Also, I got the same error when I used "export table" wizard in Aginity
workbench.
But, I can export the table by running SQL query in Aginity workbench.
Any help would be appreciated.
workbench to a txt file on win 7.
I called The sql query from C# in visual studio 2013:
CREATE EXTERNAL TABLE 'C:\path\my_name.txt'
USING
(
Y2BASE 2000
ENCODING 'internal'
REMOTESOURCE 'ODBC'
ESCAPECHAR ''
)
AS
SELECT *
FROM admin.my_table
I logged in as admin in the database. But, I got error:
Exception captured: System.Data.Odbc.OdbcException (0x80131937):
ERROR [HY000] ERROR: CREATE EXTERNAL TABLE: permission denied.
Also, I got the same error when I used "export table" wizard in Aginity
workbench.
But, I can export the table by running SQL query in Aginity workbench.
Any help would be appreciated.