Re: Finding DB_LOCALE of database

Posted in 1997

Dale Forrey — 31 Jul 1997 18:18:14 -0400 — source: Informix-list mailing list archive (1991-1998)

Within the SYSMASTER database is a table named sysdbslocale. This table lists the locale of each database that OnLine manages. I believe you can also look in the SYSTABLES table within the database to which you are attached. Look for tabname = GL_COLLATE or GL_CTYPE and the site column has the database locale information. At least it does in OnLine 7.23 running under AIX 4.1.4. Good luck. At 06:15 PM 7/31/97 GMT, you wrote: >Hi, > >Within an ESQL/C client application, I would like to find >the setting of the database locale stored in the system >catalog of the database that my application has attached to. >Does anyone know how I could do that? > >Your help is greatly appreciated. > >Vinhson >Email: nguyenv@cognos.com > > Dale Forrey, DBA email: forrey@wsu.edu Information Technology FAX: (509) 335-0540 Washington State University Phone: (509) 335-7098 Pullman, WA 99164-1222