FW: upper with dbload

Shashank wrote: > Hello, > I've a dump of sybase database. (bcped one). I'm trying to load > it on informix using dbload. I've created the necessary command files. > I need tp upcase the char data in some of the columns. (I've the UPPER > procedure which works). > My question is : Can I use UPPER in the insert statement of > the command file to upcase the data while loading??. Any experiences?? > thanks > shashank If you have the High Performance Loader (7.2x), you can use it to perform = this function, although this is swatting flies with a sledge-hammer. A = much flatter learning curve, would be to use nawk (gawk) or perferably = perl to perform the conversions on the flat files themselves. If this is = not possible (because of disk space etc), esql/C or 4GL are other = alternatives to do both tasks at once. cheers RET +--------------------------------------------------------------------------= --+ | Richard Thomas (DBA) richard_thomas@yes.optus.com.au +61 2 9342 = 7188 | +--------------------------------------------------------------------------= --+