Re: informix newbie

Server Studio (Java edition and Win32 edition) has a full-featured data editor grid component that works like an excel spreadsheet with a difference that it supports all Informix specific datatypes and allows inserting of blobs, images, complex types, such as rows, sets, lists, etc. To insert data in Server Studio JE, select table in the Object Explorer and choose Data/Select Top Rows popup menu. The grid component that is filled with first rows will be opened. After that you will be able to edit data in the grid by typing new values in cells or by using Cell Editor dialog box. You can insert new rows using Data/Insert Row menu or by pressing + icon on a toolbar. Choose Data/Execute menu to save all changes in a table. You can also open data editor with Tools/Data Editor top-level menu. You can perform the same operations in Server Studio Win32 as well by using Edit Data popup menu on the selected table in the Object Explorer. "Daniel" <dhw377@nothing.no.spam.com> wrote in message news:<P%UTb.19095$CJ1.15845@lakeread01>... > Hi all, > > I downloaded the latest version of Informix (9+) for Windows. > > I was wondering if there was a way to do a complete database backup, save it > to a file, and bring this file to another installation of Informix (also 9+) > and do a restore? I would like to copy all tables, objects, and data. If > possible, how would I do this? > > For each database, where does Informix keep the file? I have my installation > in c:\\Database\\Informix. > > I am trying the Server Studio GUI program. Is there an easy way to insert > via a gui? Something akin to SQL Server's Enterprise Manager, where it's > Excel-like with boxes you can fill data with? If I missed in Server Side, > perhaps you can point me out to its functionality. > > Any other good GUIs for Informix? > > > > Thanks in advance.