RE: Log at the table level?

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