Informix to ASCII

cmgood13 · #1 (**permalink**) 09-12-02, 14:45

I'm trying to dump an entire Informix 5 database to ASCII or dbf files for conversion. What is the easiest method for doing this? Can this be done from the dbaccess utility?

Help!!!!

ladwig · #2 (**permalink**) 09-13-02, 01:56

Hi,
you can try dbexport for the whole database, or dbaccess with the sql unload to file select * from table.

cmgood13 · #3 (**permalink**) 09-13-02, 08:29

Quote:

Originally posted by ladwig
Hi,
you can try dbexport for the whole database, or dbaccess with the sql unload to file select * from table.

OK thanks. will the dbexport disturb the current database? Is it more of a copy or will it detach and move the database?

Roelwe · #4 (**permalink**) 09-16-02, 04:30

dbexport will place an exclusive lock on the entire database while exporting.

Internet Services

Web Development

Digital Marketing

Consumer Tech