Re: informix newbie

The following is valid from version 7.x on and it works also on 9.x. Note that in versions 9.4+ (I'm not completely sure about the subversion) there are some additional settings you could use to set a character set. You should also set DB_LOCALE environment variable. Value is a string of a form: "LL_CC.<codeset>" where CC is 2-letter ISO country code, LL is a two-letter language code and <codeset> is character set code. DB_LOCALE should match the locale of a database, you are trying to use. For example "cs_cz.8859-2" stands for Chech Republic, Chech language and ISO 8859-2 (ISO Latin 2) character set. Another example could be "en_us.8859-1" which stands for English language, United States and ISO 8859-1 (ISO Latin 1) character set. For a full list of available values search the documentation. The same can be done with CLIENT_LOCALE environment variable, but it is usually unnecessary. Gorazd "Daniel" <dhw377@nothing.no.spam.com> wrote in message news:K9_Tb.19447$CJ1.12112@lakeread01... > > "Gorazd Hribar Rajteriďż˝" <REMOVE_gorazdh@hotmail.com> wrote in message > news:FUWTb.4021$%x4.424455@news.siol.net... > > Hi Daniel! > > > > [SNIP] > > > > > > 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? > > > > > > > The easiest way to do this is using dbexport utility. Dbexport will create > a new directory with the same name as your database's > > name and an ".exp" extension. Inside that directory you'll find one SQL > script for recreating the database and a bunch of .unl > > files - one for each table in your database. Dbimport utility knows how to > insert the data into a new database. You should be > > carefull with your environment settings (variables like DB_LOCALE, > DBMONEY, DBCENTURY,...) They should be the same at the time of > > database xport as at the time of database import. > > > > I tried running dbexport and I got the following error: > C:\\Database\\Informix\\bin>dbexport > ERROR: Could not initialize the security subsystem. Please ensure that this > account has the nec > essary privileges and ensure INFORMIXSERVER value exists in the registry and > environment. > > The user is and administrator of the system. > > I put down the name of what I thought the INFORMIXSERVER should be ( > ol_mymachinename ), and tried running it again and got this message: > > C:\\Database\\Informix\\bin>dbexport > -23101 Unable to load locale categories. > > Where can I find what environment variables I should set? > > > > > > For each database, where does Informix keep the file? I have my > installation > > > in c:\\Database\\Informix. > > > > > > > I have no idea for Windows... We always used raw devices (unformatted disk > partitions). > > > > > 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? > > > > > > > ServerStudio is a good start. You could also try WinSQL > (http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp). > > > > Gorazd > > > >

Thanks. "Gorazd Hribar Rajteri'" <REMOVE_gorazdh@hotmail.com> wrote in message news:W3cUb.4060$%x4.434460@news.siol.net... > The following is valid from version 7.x on and it works also on 9.x. Note that in versions 9.4+ (I'm not completely sure about the > subversion) there are some additional settings you could use to set a character set. > > You should also set DB_LOCALE environment variable. Value is a string of a form: "LL_CC.<codeset>" where CC is 2-letter ISO country > code, LL is a two-letter language code and <codeset> is character set code. DB_LOCALE should match the locale of a database, you are > trying to use. > > For example "cs_cz.8859-2" stands for Chech Republic, Chech language and ISO 8859-2 (ISO Latin 2) character set. Another example > could be "en_us.8859-1" which stands for English language, United States and ISO 8859-1 (ISO Latin 1) character set. For a full list > of available values search the documentation. > > The same can be done with CLIENT_LOCALE environment variable, but it is usually unnecessary. > > Gorazd > > "Daniel" <dhw377@nothing.no.spam.com> wrote in message news:K9_Tb.19447$CJ1.12112@lakeread01... > > > > "Gorazd Hribar Rajteri'" <REMOVE_gorazdh@hotmail.com> wrote in message > > news:FUWTb.4021$%x4.424455@news.siol.net... > > > Hi Daniel! > > > > > > [SNIP] > > > > > > > > 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? > > > > > > > > > > The easiest way to do this is using dbexport utility. Dbexport will create > > a new directory with the same name as your database's > > > name and an ".exp" extension. Inside that directory you'll find one SQL > > script for recreating the database and a bunch of .unl > > > files - one for each table in your database. Dbimport utility knows how to > > insert the data into a new database. You should be > > > carefull with your environment settings (variables like DB_LOCALE, > > DBMONEY, DBCENTURY,...) They should be the same at the time of > > > database xport as at the time of database import. > > > > > > > I tried running dbexport and I got the following error: > > C:\\Database\\Informix\\bin>dbexport > > ERROR: Could not initialize the security subsystem. Please ensure that this > > account has the nec > > essary privileges and ensure INFORMIXSERVER value exists in the registry and > > environment. > > > > The user is and administrator of the system. > > > > I put down the name of what I thought the INFORMIXSERVER should be ( > > ol_mymachinename ), and tried running it again and got this message: > > > > C:\\Database\\Informix\\bin>dbexport > > -23101 Unable to load locale categories. > > > > Where can I find what environment variables I should set? > > > > > > > > > > For each database, where does Informix keep the file? I have my > > installation > > > > in c:\\Database\\Informix. > > > > > > > > > > I have no idea for Windows... We always used raw devices (unformatted disk > > partitions). > > > > > > > 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? > > > > > > > > > > ServerStudio is a good start. You could also try WinSQL > > (http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp). > > > > > > Gorazd > > > > > > > >