Include Tables from Files into Database
Posted in 2003
Topics: Installation, Setup & Upgrades
Hi, I've got the follwing problem: From a customer Informix installation I got the follwing database files, which represent the table 'wsart' (at least I think they do). -rw-rw---- 1 informix informix 299748 May 27 10:14 wsart00310.dat -rw-rw---- 1 informix informix 92500 May 27 10:14 wsart00310.idx -rw-rw---- 1 informix informix 0 May 27 10:14 wsart00668.dat -rw-rw---- 1 informix informix 3072 May 27 10:14 wsart00668.idx -rw-rw---- 1 informix informix 1173544 May 27 10:14 wsart00725.dat -rw-rw---- 1 informix informix 54547 May 27 10:14 wsart00725.idx No I need to integrate these files into my test database. With databases like MySQL I can simply copy the files into the database directory and the tables are available but obviously it's not that easy with Informix :-) So anyone got an idea how I can access these tables? Thanks Christian Ciao Christian
Christian Robert wrote: >Hi, > >I've got the follwing problem: From a customer Informix installation >I got the follwing database files, which represent the table 'wsart' >(at least I think they do). > >-rw-rw---- 1 informix informix 299748 May 27 10:14 wsart00310.dat >-rw-rw---- 1 informix informix 92500 May 27 10:14 wsart00310.idx >-rw-rw---- 1 informix informix 0 May 27 10:14 wsart00668.dat >-rw-rw---- 1 informix informix 3072 May 27 10:14 wsart00668.idx >-rw-rw---- 1 informix informix 1173544 May 27 10:14 wsart00725.dat >-rw-rw---- 1 informix informix 54547 May 27 10:14 wsart00725.idx > > They represent more than one table which name started with "wsart" Get your customer to send you a schema of the table and unloaded to ascii data from the table (or tables). >No I need to integrate these files into my test database. With databases >like MySQL I can simply copy the files into the database directory and >the tables are available but obviously it's not that easy with Informix >:-) > >So anyone got an idea how I can access these tables? > >Thanks >Christian > >Ciao >Christian > > HTH Michael