Skip navigation
1299 Views 3 Replies Latest reply: Feb 13, 2012 5:00 AM by kaucic RSS
rpusr New Enzee 13 posts since
Jan 25, 2012
Currently Being Moderated

Feb 10, 2012 1:02 PM

How to ignore ^Z records while using nzload?

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.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 4 points
  • Helpful Answers - 2 points