RE: upper with dbload
If you are on Unix, you might look at using a sed script to handle
converting the lower case data to upper case before you run the load.
The syntax you could use is:
sed 'y/abcdefghijklmnopqrstuvwxyz/ABCDEFGHIJKLMNOPQRSTUVWXYZ/g' infile
} outfile
Please test this before you run it on production data.
James May
Database Administrator,
Agency for Health Care Administration, Florida
voice 904.413.9072
email = mayj@fdhc.state.fl.us
}-----Original Message-----
}From: CDware user [SMTP:cdware@sun.com]
}Sent: Tuesday, September 02, 1997 8:16 PM
}To: informix-list@rmy.emory.edu
}Subject: upper with dbload
}
}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