02-13-2018 07:38 AM
I need to run a query of historical bank transactions, in Hadoop. I usually query in Netezza.
I received the following error, and was wondering if anyone had a tip to offer.
NOTE: Updated analytical products:
NOTE: Additional host information:
IBM AIX AIX 64 1 7 00C030A74C00
02-16-2018 05:33 AM
There seems to be corrupt/invalid data in the file.
Does the query work outside of SAS? Is the data in text files? Are the text files UTF-8? Can they be UTF8? Can you run a validation?
02-16-2018 07:46 AM
thanks for ur reply. I ended running the variable but excluding a variable. The output was good.I didn't look further into this. A colleague later gave me, which i'm listing here in case in can help anyone:
Pls add this option in libname statement
DBMAX_TEXT=255 TRANSCODE_FAIL=SILENT LOGIN_TIMEOUT= 0 ;