Re: OpenLink, Powerbuilder, and Informix

roger@stratsoft.com (Roger Meyers) wrote: >On Thu, 26 Jun 1997 13:23:46 GMT, jay@ulife.com (Jay Aymond) wrote: > >>We are using Powerbuilder 5.0 and the OpenLink ODBC Drivers. Using >>these drivers, Powerbuilder cannot display fields from the database >>that are defined as "money" --- decimal works fine. >> >>Has anybody else experianced this, and is there a workaround? >> >Yes. > >In your reqest broker .ini (oplrqb.ini) file in the Environment section >for informix add the following line: "DBMONEY = ." (w/o Quotes). >Your infomrix manuals document this. It tells Informix to not "display" >the money column with a preceding dollar sign to the request broker. > >HTH > >Roger Meyers >roger@stratsoft.com >Strategic Software Solutions >San Francisco... > > Thanks for the info --- adding the "DBMONEY=." parameter did fix the problem. Have you ever tried fixing the problem in the Powerbuilder file named "pbodb050.ini"? There are some other ODBC / Powerbuilder mappings in this file. Also, have you ever compared the Openlink driver performance against the Informix Native Drivers for Powerbuilder? We have noticed the native drivers to be 2 to 3 time faster than the Openlink drivers. ___________________________________________________________ Jay Aymond United Life & Annuity Insurance Company Email: jay@ulife.com