Trim and custom functions with High Performance Loader (HPL) 
Author Message
 Trim and custom functions with High Performance Loader (HPL)

Hi !

I'm a new user of the Informix High Performance Loader.
I mapped a small test file to a table and everything worked fine. One
of the fields is a text field (varchar) and i want to clear the
"extra" spaces before and after the text before inserting it into the
table. Informix as a built in function that does that, the TRIM
function but i don't know how to use it with HPL. Any ideas ???

I thought building a custom function and calling it in the "function"
field in the "mapping options" but this matter is barely covered on an
appendix on the HPL documentation. Anyone knows how to build custom
functions in HPL or where can i find extra info on this ???

      Thanks,
             Miguel Carvalho



Sat, 05 Jun 2004 19:37:24 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. High Performance Loader (HPL)

2. Money field loaded through high performance loader off by 2 place

3. High Performance Loader

4. High Performance Loader

5. High Performance Loader

6. High-Performance Loader guide line

7. Emergency: Help with High Performance Loader

8. Question about High Performance Loader

9. High Performance Loader - HOWTO

10. Command line interface to High Performance Loader

11. High Performance Loader Express Mode

12. High Performance Loader - Violations


 
Powered by phpBB® Forum Software