I don't have a 9.2 instance that has been upgraded from 7
right to hand.
You could try it as user informix, try it as the owner of the
database, try it as the owner of the procedure, try it as a
user who has DBA privileges on the database.
Brian W.
"Jarman, Andy" wrote:
> Hi Brian,
>
> Marco beat you to the answer by about five minutes. Thanks guys.
>
> Unfortunately, although this environment variable allows me to send this
> SQL statement to the engine, it returns "-389 No DBA permission.". But
> 'informix' is the database owner ???
>
> Any pointers ?
>
> Andy Jarman
>