Hello Guru,
Thank you.
I am using IBM Informix Extended Parallel Server Version 8.32.FC2X4, since i have never worked on external table in previous version, i am having little difficulty in undestanding external table.
I tried creating one, and found that if i create ext. table, with datafile and rejectfile mentioned, then when i insert data, it's in the seq. file.
Now, as i understand from some reading that ext. table is used to load and unload both. So, that's where i am.
I am searching thru' net and not getting exact details on the same.
To thoroughly understand the use and what it is, what manual should i refer ? SQL ref and user have very less details on the same.
Regards,
PD
Quote:
Originally posted by Roelwe
Hi, it depends what you mean with an external table.
What version of Informix do you have?
If it i sversion 9, you have the possibility to implement external tables with the Virtual table interface and Virtual Index Interface. All this is described in the manuals of virtual table interface.
One implementation of th eVirtual table Interface, can be th eC-Isam datablade. If your external table is a C-Isam file, I would suggest you use this interface. it treats C-Isam files as it were tables.
If this is the case, yes you can load data from a data file with all load and unload tools, described in the migration guide.
|
dBforums
>
External table
10-01-03, 05:58
Linear Mode
