Mozilla Skin

Informix

From YourSupportStoreWiki

First to log in you type

dbaccess databasename

then you can use the menus to run queries.


a simple search

select * from table where column = 'value'

to make changes

update table set column = 'value' where anothercolumn = 'value'

to make deletes

delete from table where column = 'value'


now to export your data to a file


unload to /path/filename
select * from table where column = 'value'