Unable to handle the Nulls
Posted: Sat Sep 21, 2019 11:16 am
Hi
We are loading the data from netezza to yellowbricks but getting below error.
ODBC_Connector_15,0: ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 3452617: Msg = [IBM(DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: invalid byte sequence for encoding "UTF8": 0x00()
ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 3624914: Msg = [IBM(DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]Failed transaction. The current transaction rolled back. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 730)
source column is not null column and target also not null column, but loading data from netezza to netezza but not loading netezza to yellow bricks while using datastage.
while doing analysis showing blank in unix for the particular column, please help me out how to resolve the issue.
and the default value for the column is space ' '.
We are loading the data from netezza to yellowbricks but getting below error.
ODBC_Connector_15,0: ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 3452617: Msg = [IBM(DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: invalid byte sequence for encoding "UTF8": 0x00()
ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = 3624914: Msg = [IBM(DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]Failed transaction. The current transaction rolled back. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 730)
source column is not null column and target also not null column, but loading data from netezza to netezza but not loading netezza to yellow bricks while using datastage.
while doing analysis showing blank in unix for the particular column, please help me out how to resolve the issue.
and the default value for the column is space ' '.