I'am parsing a text field delimited by ; (see example belown). I split the file into multiple variable ($) and then execute the request. When the NO is blank: no problem the record is write inside DB but when de DATE is blank I receive a message from DB telling me that the format of the date is not good!!!
I'am using DB2 all the field in the table can be null. Someone can help me??? Thanks TEXT FILE no;date;text;blablabla
