Troubleshooting
Problem
User wishes to extract the Netezza ROWID system column along with other columns from a given table.
Symptom
A job containing ROWID or a reserved word as a Netezza column will compile without warning. Upon running the job, the job will fail and an error similar to the following will be logged to the IIS Director Log:
Netezza_Connector_1,0: Failed to execute SQL statement:
CREATE EXTERNAL TABLE NZCC_20120313101217_19835_0(ROWID BIGINT NOT NULL, COL1 CHAR(10) NOT NULL)
USING (DATAOBJECT ('/tmp/Redhat6485_19835_nzw_0_0')
remotesource 'odbc' delimiter '' ignorezero false ctrlchars true escapechar ''
logDir '/tmp' boolStyle 'T_F' encoding 'internal' nullValue 'N' ).
Reason: [SQLCODE=42S21][Native=30] ERROR: Attribute 'ROWID' has a name conflict
Name matches an existing system attribute (CC_NZConnectionRep::executeDirect, file CC_NZConnectionRep.cpp, line 172)
or
Netezza_Connector_0,0: Failed to execute SQL statement: CREATE EXTERNAL TABLE NZCC_20160706122520565670_7891_0(SUID CHAR(10) NOT NULL, LOAD CHAR(6) NOT NULL, ...) USING (DATAOBJECT '/tmp/XXXXX_###_0_0_20160706122520565653') remotesource 'odbc' delimiter '?' ignorezero false ctrlchars true escapechar '\' logDir '/tmp' boolStyle 'T_F' encoding 'internal' nullValue 'N' ). Reason: Failed to get error details (CC_NZConnectionRep::executeDirect, file CC_NZConnectionRep.cpp, line 201)
When run manually outside of DataStage receive the following error:
ERROR [42000] ERROR: 'CREATE EXTERNAL TABLE NZCC_20160706115641480005_6067_0(SUID NCHAR(10) NOT NULL, DIST NCHAR(8) NOT NULL, LOAD NCHAR(6) NOT NULL, ...) USING (DATAOBJECT '/tmp/NNNN_###_0_0_20160706115641479987')'
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5;11.5;11.3","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
25 April 2025
UID
swg21588159