Handling Null in Load Utility
Posted: Sat Oct 06, 2007 8:40 pm
Hi,
1)I am loading a file which contains 50 million of records in to target table. If i use job design it will take atleast 1 or 2 days to load. I have written a unix script and loading data through load utility from sequential file to target table. it is getting hanged because if there is any null values in the records. Is there any way to handle null or change it to blank before using load utility.
2) In unix, how can we find is there any null values in file(Command).
1)I am loading a file which contains 50 million of records in to target table. If i use job design it will take atleast 1 or 2 days to load. I have written a unix script and loading data through load utility from sequential file to target table. it is getting hanged because if there is any null values in the records. Is there any way to handle null or change it to blank before using load utility.
2) In unix, how can we find is there any null values in file(Command).