Tags » Informix

Importing and exporting data and schema from Informix

SOURCE

To get schema :

dbschema -d db_name db_name.sql -nw

To get table data :

unload to 'export/table_name.unl' select * from table_name;

DESTINATION

Restore schema : 34 more words

Using appRules to Read and Process Stored Procedure Records

appRules Studio includes workflow activites for reading records from a stored procedure.  By utilizing the stored procedure related activities, the stored procedure records and the fields they contain can be read from the database and utilized in appRules just like any other records and fields. 393 more words

Databases

Informix/IDS: dbschema utility

You can use dbschema utility to get the schema of a database and redirect the dbschema output to a file.

To get the complete syntax of dbschema just type “dbschema” from command prompt and press enter. 71 more words

Informix

Informix/IDS: Checkpoints

A checkpoint is a point in time in the log when a known and consistent state for the database system is established.

A checkpoint can occur in one of these situations: 41 more words

Informix

Informix/IDS: Monitoring log file

The message file records the activities performed on Informix server instance such as starting, stoping etc.
There are 2 ways you can monitor the message file: 214 more words

Informix

Switching between Informix Server Modes

The Informix database server has three principal modes of operation: Online, Quiescent and offline.

Online Offline Quiescent Online              —

onmode –ky (or) onmode -k Gracefully: 28 more words

Informix