Unanswered: DB2 -IMPORT FILE , How to add validation
Hi All Gurus,
I am trying to load a CSV file from my PC (windows XP) to Db2 v8.1 (UNIX server). The file is an excel sheet (user input) converted to a CSV. I am able to load the file to the table but the problem I am facing is that there are some null rows in the file which are getting inserted in the table (like all columns are null or have spaces). Is there a way I can put a validation criteria so that it checks for a null row before it loads, as I cannot restrict on the row count .
-------Code being used ----
IMPORT FROM 'C:/data/DD Limits Dec 2007.csv' OF DEL COMMITCOUNT AUTOMATIC
REPLACE INTO DDN.DD_LIMITS
I am very new to DB2 so don’t have any Idea what I should be looking at , I tried searching the documentation but couldn’t find any thing good ,any help in this direction would be great .