Wednesday, August 6, 2014

DataStage Netezza Connector Sparse Lookup Error: Count field incorrect

Error Message:
Unexpected ODBC error occured. Reason: [SQLCODE=07002][Native=8] Count field incorrect (CC_NZStatement::executeSelect, file CC_NZStatement.cpp, line 137)
 One or more fields in the data stream are used multiple times in the lookup SQL statement.

Duplicate the field(s) so that each is used exactly once.

No comments: