Problems using High Performace Loader (onpload)
Posted in 1998
Topics: Performance & Tuning
The High Performance Loader (HPL) does not recognise Control-M (^M) and EndofLine ($) characters. I have used the GUI interface of HPL to define the upload process. This was a very straightforward process. I tried Running the process and most of the records were not uploaded because of errors. I then read the file using cat -vet | more. This showed me the hidden control characters. To test my theory ie HPL not liking these characters. I used unix2dos to remove the (^M) character. I also added an extra field to pick up the end of line character. This filler is not mapped to any field in the informix database. This worked perfectly. I then used the original input file ie with control characters and HPL uploaded errorneously. I know the easiest way to the problem is stripping the control characters before sending them to be processed by HPL. But what I really want is for HPL to be able to recognise these characters. Note: The input files are from a Novell server mounted as NFS on the Database server. Regards,