To unload a database, you must have DBA privileges for the database or be user informix. To unload a table, you must either own the table, have DBA privileges for the database in which the table resides, or be user informix. (User root does not have special privileges with respect to onunload and onload.)
If you unload a database, all the tables in the database, including the system catalog tables, are unloaded. All the triggers, SPL routines, defaults, constraints, and synonyms for all the tables in the database are also unloaded.
If you unload a table, onunload unloads the table data and information from the following system catalog tables:
systables
syscolumns
sysindexes
sysblobs
When you unload a table, onunload does not unload information about constraints, triggers, or default values that are associated with a table. In addition, access privileges that are defined for the table and synonyms or views that are associated with the table are not unloaded.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]