Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. similici

    Problem with stored procedure on IFX10.FC5

    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...
  2. similici

    sysmaster: syssqlcurall

    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
  3. similici

    Onmonitor problem

    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
  4. similici

    Varchar/delimiter problem

    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...
  5. similici

    DDRBLOCK problems

    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
  6. similici

    UPDATE STATISTICS

    How can I see if a table is updated statistics or not or yhe last time it was updated statistics? Thank you.
  7. similici

    Informix 4GL problem

    What does init_flag do?Is it a system global variable? Thanks.

Part and Inventory Search

Back
Top