Feb 10, 2012 1:02 PM
How to ignore ^Z records while using nzload?
-
Like (0)
Records:
500|NY|111-111-1112|A^M
^Z
1000|NY|111-111-1111|F^M
^Z
When I use nzload to load into the database, the 2 records are loaded fine. But the other 2 with ^Z are written to log file stating
number of bad records: 2. I'm trying to error code this in my unix script.
grep "number of bad records: 0" test.log
errorcode=$?
If errorcode=0 , then contiue to another step, else email bad records found.
How can I code in the nzload command, so it'll totally ignore any records with ^Z.
maybe remove the ^Z lines before u do nzload?
check the dataloading guide...NZLOAD has an option cntrlchraters...should be of some heip...
Hi
Netezza_data_loading_guide.pdf ( -crInString -ctrlChars)
bye d

