Recent content by GRP

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

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.

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.

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

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

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.

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

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

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

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

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.

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.

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 =...

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.

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.