Re: problem loading data

"Parker, Jack" wrote: > > Aside from Raw, standard and temp, in XPS we have operational, static and > scratch. Finer gradations than the simplistic standard/raw dichotomy. > > Scratch is a non logging temp table. > Static is a non-updated table (hence no locks, no logging etc.) > Operational is between standard and raw, you can have indexes, but it isn't > a logged table. > > Of course I'm doing that from memory - TFM may phrase it slightly > differently. My memory is subject to lost pages - today I found myself, for > the first time that I remember, telling a joke that I didn't remember part > of. I immediately started an oncheck -cD. Sigh, age is a wonderful thing. Yes...., thanks for sharing Jack! We know you love XPS, although I thought it was called IDS-EPO these days! ;-) EPO is great for Data Warehouses, but not much good for OLTP databases. Us mere mortals who run OLTP systems also have to load data occasionally. Some of us even have to run Data Warehouses using OLTP database servers!! :-)) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+