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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: GRP
  • Order by date
  1. GRP

    Date arthmetic.

    Hi friends, I am using IDS 7.31 on HP-D370 Server. In SQL query I would like to find out the time difference between two days. For. E.g Previous day say 19/04/02 22:30:00 to 20/04/02 06:30:00 Hrs. I would like to know the time difference i.e 8 Hrs, 9 Hrs etc. I tried same thing in 4GL also...
  2. GRP

    Informix SQL Query

    Hi Jamie, You can use this query, Select client.accountnum, client.opendate, sum(transaction.amount) from clients, transactions where clients.accountnum = transactions.accountnum and (client.opendate + 3 unit months)>= transactions.date group by 1, 2; G.R.P.
  3. GRP

    Informix syntax

    Hi Tankem, ON EVERY ROW will work on all rows selected in foreach statment. It is like a FOR loop selecting a set of records from the table. G.R.P.
  4. GRP

    Table fragmentation

    Hi, The update statics should be done when extensive modifications to a table or when changes are made to tables that are used more frequently. You can monitor system activity and do update statictis. Or else you can schedule the update staticts daily or alternative days based on your system...
  5. GRP

    Informix syntax

    Hi Tankem, Whatever you have asked is all part of 4GL Report in Informix. ON EVERY ROW is used to print or manipulate each row sent to the report from the main routine. The main routine sends rows one by one for printing and any operation to be carried out on that data and actual prnting of...
  6. GRP

    Compressing executable size!!

    I am using strip command regularly to compress the size. But there is no considerable decrease in size after using strip. Basicallly, I am looking out for any other means and was eager to know how others are mananging. Thanks for your suggestion, G.R.Patil.
  7. GRP

    Compressing executable size!!

    We are using Informix IDS 7.31 and earlier we were using Informix online 5.x. Now as I observed the executable file size (*.4ge,*.x) is bigger in Ver 7.31 compared to older one. Is there any way out to reduce the file size? I tried some of the steps which were given in manual, but it did'nt...
  8. GRP

    Returnning more than one field in FUNCTION

    I am working on Informix V 7.31, what we do to return the result set is like this. a) Create a temporary table before call to the function. b) In Function insert the result in to the temporary table. c) The resultset in the temporary table can be accessed any where in the program like...
  9. GRP

    ODBC Configuration!

    Dear Partha, Thanks for your Suggestion. My problem is solved. It was a very silly problem. My Configuartion parameter everything was O.K. The only thing which we need to take care is the entries in hosts file should start from the begining of the line. There was a space which was creating...
  10. GRP

    ODBC Configuration!

    We are using INFORMIX dynamic server 7.31 and HP-UX 10.20. The telnet and ftp connection between PC (Windows 98 II Edition) and UNIX serve is working fine. We are trying to access the database on HP-D/370 from PC using ODBC. I have set the evironment parameters (INFORMIXDIR,PATH) & made entries...
  11. GRP

    Index and Priviledges relation

    It seems Informix while rebuilding the Index goes into single user mode i.e it won't allow others to select or update the table on which it is recreating the Index. To achieve this Informix might have revoked the access permissions on that table. G.R.P.
  12. GRP

    Performance drop while executing StoredProcedure in Informix

    Check the query in your SP. Fine tune your query in SQL and implement the same in your SP. I don't find any reason for drop in your system performance. G.R.P.
  13. GRP

    Choosing the right index in a SELECT statement

    The select statemnt which use should have the same key sequence, then the informix will automaticaly refer to the related index. For E.g: If you have two indexes one on emp_code field and the other one on grade_code. The select statment select * from employee_mast where emp_code =...
  14. GRP

    Hi all, I would like to know c

    Hi Surachai, Thanks for your suggestion. I had tried out your suggestion, our connection is not through ontlitcp. It is by onsoctcp. I changed the /etc/services and /etc/hosts.equiv file and could able to access the remote database successfully. Thanks again for your tip, G.R.P.
  15. GRP

    missing index node pointer

    Can you please tell me how you are taking backup. Give the shell script file if possible which will give clear idea of what exactly it is doing. G.R.P.
  16. GRP

    INFORMIX ONLINE DYNAMIC SERVER

    This can also be done by using where clause. where owner != "informix". Since he wanted to know all the records in database, I did not include where condition. G.R.P.
  17. GRP

    missing index node pointer

    Hi, Can you please elaborate your problem. If possible kindly give the Error Number. It might be back because of corruption in Index tables. Backup your table and drop & recreate the index. G.R.P.
  18. GRP

    missing index node pointer

    Hi, Can you please elaborate your problem. If possible kindly give the Error Number. G.R.P.
  19. GRP

    Hi all, I would like to know c

    Hi all, I would like to know configuration set up for accessing remote database on other server by INFORMIX. Both ther servers are having IDS 7.31 and Unix. Telnet & remote copying is already working between two servers. GRP
  20. GRP

    setnet32

    Dear DT, Did you got the solution? Inform me on g_r_patil@rediffmail.com G.R.P.

Part and Inventory Search

Back
Top