Re: Finding DB_LOCALE of database

EXEC SQL SELECT dbs_collate INTO :host_variable FROM sysmaster:sysdbslocale WHERE dbs_dbsname = '<your db name here>'; } } 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 } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net