Search results for query: *

I have a table called "performance" with more than 108 million rows. The table has an index on the following fields: cl_id his_date his_class his_code his_type I am writing a query that uses only his_class his_code his_type Because of this the query is doing a SEQUENTIAL SCAN instead of...

Use " select first 5 * from <table name> order by <colname> desc

I installed db2 udb 8.2 EEE on Mandrake Linux and created 3 instances using db2setup tool. All the instances are working fine and Iam able to start the database manager. I manually created an instance "db2_1" under user and group id "db2_1".But Iam unable to start the db manager. when i give...

Iam trying to start the Informatica 5.1 Server in WINDOWS XP PROFESSIONAL under Informatica user and Iam getting the following error message. "The Informatica service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the...

Yes. Actually the software is IDS 9.4 for solaris 9. I tried to install in Solaris 8. I searched in google and the site exactly reflect my error. http://www.sunmanagers.org/pipermail/sunmanagers/2001-August/005325.html

Yesterday I tried to install online dynamic server 9.4 in solaris. today iam trying to install online 5.2 in solaris. but the error is same. when i give &quot;. installonline&quot; , it blews after the following steps Installing directory . Installing directory bin etc/install: etc/brand...

Iam installing IDS 9.4 in Solaris 8 (Intel) I set the informix parameters and typed . installserver After few minutes, i got the following error message Installing directory. Installing directory aaodir Installing directory bin etc/install: etc/brand: cannnot execute binary file Installed of...

I think when you took the last complete backup, the ontape might have set the tape number as 2. Check the number of tapes you used during backup.

Hey Dinakar!! As Mr.Shriyan mentioned, just load the flat file into a temp table,declare a cursor and create a report using foreach. It will work.

Yes I agree with Mr.Shriyan. You need to touch the files and recompile it. It will work.

Iam installing my Informix Dynamic Server 2000 sofware for Win NT/2000 in Windows XP Professional and Iam getting an error saying &quot;Unable to initialize server.Please check Event Security log and c:\program files\informix\i2.log&quot; I checked both the logs but I could not identify the...

Jumbalaka!! You cannot issue SET LOCK MODE TO WAIT and SELECT statement as a single statement. Execute it seperately.

Hi, This is a backend error. Generally,it is not recommended to issue the &quot;SET LOCK MODE TO WAIT&quot; statement in any critical environment. Instead set a time frame in seconds ie.,Use SET LOCK MODE TO WAIT 20. Otherwise use an isolation level to fix the same. SET ISOLATION TO DIRTY READ.

Can I get Informix Dynamic 4gl and Informix 4gl free version or where can I download the same.