Sounds like you are trying to prevent a null column from the CSV from being inserted into the RDBMS.

If this is the case you can check for "null" after the fetch and before the insert via:

if ( $six eq '' ) {  # don't insert }
else { # ok to insert }

# or perhaps 
if ( length($six) == 0 ) { # don't insert }
else { # ok to insert }
[download]

Another option (possibly not available from the CVS)

INSERT INTO Customer_Information 
  (CustomerNumber, Name, Address1, Address2, City, 
   State, ZipCode, Email, DefaultPassword) 
VALUES (
   SELECT one, two, three, four, six, 
          seven, eight, nine , sixteen 
   FROM  info
   WHERE six is not null
   )
[download]