Troubleshooting Tips: Cannot use the system column ROWID in a Netezza Common Connector query
madavid 270001CJGW Visits (4031)
DataStage user extract the Netezza ROWID system column along with other columns from a given table.
A job containing ROWID 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:
NeteCREATE EXTERNAL TABLE NZCC
USING (DATAOBJECT ('/t
remotesource 'odbc' delimiter '' ignorezero false ctrlchars true escapechar ''
logDir '/tmp' boolStyle 'T_F' encoding 'internal' nullValue 'N' ).
Name matches an existing system attribute (CC_
Click here to find out the tech notes for resolution