I have been using sql loader for transfering data from flat files to oracle. Suddenly now we are getting data from the source with blanks on the rigth side of the data. The flat file is being generated from IBM DB2 export utility. Does anyone know how to remove blanks in the ibm db2 export command ???
Also while using the sql loader utlity, I made some changes in the control file. I have attached the file here.
But when the command is runned, the log file shows no error, but the data in the columns is NOT PRESENT ??????
Reply With Quote