Backup up table

stanislav.ondac · #1 (**permalink**) 12-12-05, 16:51

Hi
I need to back up the table using sql code.
I need something like mysqldump in MySql.
Is something like this in informix?

Thank you in advance

artemka · #2 (**permalink**) 12-12-05, 18:09

dbschema -d database_name -t table_name -ss

to get the schema

unload to "table_name.unl"
select * from table_name

to unload the data

if you want to unload the whole database you can use dbexport

stanislav.ondac · #3 (**permalink**) 12-12-05, 19:52

Thanks, but Can I do this with some Informix SQL command?
I know about output and unload commands but they only write a data
to file, they dont write a schema.

Thanks

artemka · #4 (**permalink**) 12-13-05, 16:36

The only way to do this is by querying systables and syscolumns, take a look how the values are stored. I did this long time ago and dont remember that value coresponds to what datatypes

blackguard · #5 (**permalink**) 12-14-05, 09:12

Attached is a unix shell script that extracts the table schema. You can extract the SQL to customize your unload script.

Internet Services

Web Development

Digital Marketing

Consumer Tech