I've just upgraded from IFX10.FC4 and the stored procedure I'm executing (which worked on previous version of Informix - IFX10.FC4 ) "freeze". I've tried runing UPDATE STATISTICS FOR PROCEDURE and drop and recreate the procedure but I had no luck in executing it.
Has anybody encountered that...
After I restore a database (onbar -r -n ) I have to use the "grant select on sysmaster: syssqlcurall to 'user' " because otherwise I don't have the select permission.
Is there any other way to avoid doing this after every restore?
Thank you.
Similici
When I try to use onmonitor I get this error msg :
"Cannot display information since $INFORMIXSERVER is on a remote machine" . The server I'm working on has both IFX10 and IFX9.4 instances , with separate sqlhosts. This error msg appears only on the IFX9.4 instances .
Thanks
I have a table with a field declared varchar(15,0) .
When I make a statement like "select nume_field from table_name ..." the record returned is
AMI/|? IT 00
but when I'm unloading into a file
("unload to file.txt select nume_field from table_name...")
it looks like this:
AMI/^S|^M...
DDR Log Snooping - DDRBLOCK phase started, userthreads blocked"
I have a message like this in my log file. Can you tell my what produced it ?
Thank you
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.