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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by similici

  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