Urich Ann queried:
> Is it possible to turn logging off for a single table?
> ... beside using a temp table with no logging, or using a raw
> table.
That is what a raw table is, a non-logged table.
You can alter the table to raw mode, if it has no indexes, constraints or triggers, then do the load, then alter it back to standard.
This is a trick I have used often and regularly.
Your other choice is the High Performance Loader in Express Mode:
http://publib.boulder.ibm.com/epubs/html/25122860/hplmst238.htm#sii-15manage-13087
Read the book; don't wait for the movie.
Sincerely,
Christopher Coleman
Database Analyst
Pharmacy Division
Mediware Information Systems, Inc.
913/307-1073
sending to informix-list