var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Backup up table
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
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
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.
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
Attached is a unix shell script that extracts the table schema. You can extract the SQL to customize your unload script.