Re: 668 System command cannot be executed - 1: Not owner
Posted in 2006
Topics: Stored Procedures & SPL, Internationalization & Character Sets
Reece Wrote: > If the Informix engine is either: > 10.00.xC4 or later > 9.40.xC8 or later > > Then the problem may be APAR IC49554 and a work around would be to > explicitly specify CLIENT_LOCALE and DB_LOCALE in the URL used to > connect to the database. > > As suggested by Jonathan, the stored procedure is most likely > failing... the above mentioned APAR results in the 4GE failing with a > database locale mismatch unless CLIENT_LOCALE and DB_LOCALE are > explicity specified. > > If you're not using the above engines, modify your script to determine > the reason the 4GE fails (such directing output of the 4GE to a file) > and then take corrective action. > > Thanks, Thanks, The version is 9.40.FC8 , so this APAR does apply. I have managed to get things to work correctly by just changing the System settings to the appropriate locale. Where can I get find the details of this APAR, so that I can explain the issue to management. Thanks Gavin -- gavinrifkind ------------------------------------------------------------------------ gavinrifkind's Profile: http://www.dbtalk.net/m553 View this thread: http://www.dbtalk.net/t320415