error of importing data from txt file to IBM netezza SQL da (转载) - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Programming - 葵花宝典

error of importing data from txt file to IBM netezza SQL da (转载)

error of importing data from txt file to IBM netezza SQL da (转载)# Programming - 葵花宝典

s*r2014-11-21 08:11

1 楼

去年雇主有contribute HSA，列支在W2 box12的W项中。现在的问题是
用Turbo tax计算会把这部分钱加入schedule CA(540) C栏第12格中，但是用加州自己
的FTB在线E-file输入时，却没有出现这部分额外的税前收入，请问到底该听Turbo tax
的还是FTB efile的？非常感谢

s*k2014-11-21 08:11

2 楼

到哪里可以看到白金推荐作者，给个链接。
俺在起点网页上转了半天都没找到。

M*e2014-11-21 08:11

3 楼

有些替换下来的配件也不值当再买了，除了扔掉还有更好的处理办法么。

l*92014-11-21 08:11

4 楼

【以下文字转载自 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