Aqua Data Studio 15.0.0-dev-70
Build #: 35519
Built on: 2014-Jan-13 03:38:49 PM
O.S. : Windows 8
Database : Netezza
Issue : Import is not working for NVARCHAR and NCHAR data type in Netezza database.
Steps to Reproduce :
1. Connect to Netezza Database.
2. Expand Databases tree node and expand any database(Here MASTER_DB is expanded).
3. Create a table with NVARCHAR and NCHAR data type.
e.g.
CREATE TABLE "a_nstring" (
"a" NVARCHAR(25) NULL,
"b" NCHAR(25) NULL
) DISTRIBUTE ON ("a")
GO
4. Insert value into table "a_nstring"
e.g.
INSERT INTO "a_nstring"("a", "b")
VALUES(N'testing', N'for export_import')
GO
5. Right click on table "a_nstring" and select Tools->Export Data option.
6. Export data as shown in Screenshot(i.e. export.png).
7. After Exporting data, again click on table "a_nstring" and select Tools->Import Data option.
8. Import data as shown in Screenshot(i.e. import.png).
Here it is observed that, in Status tab java exception error is displayed.
IBM/Netezza documentation said that NCHAR and NVARCHAR are mapped as string so changed to use setString instead of setNString.