Search results for query: *

Hi there, I'm currently working on Informix 9.21TC5 on Windows 2000 machine. I have a program (written in E/SQL) to load all text files into a Informix database. I found several times that after re-loading, I could get the data output from SQLEditor if I do a full table scan like...

Hi, I've tried the following script(in dbacess) on IDS 9.4 TC2 on two Windows 2000 machines, IDS server will be brought down (the same script works fine on IDS 9.21) Could someone try it for me on your environment? Thanks Peng --- Start of Informix testing scripts CREATE FUNCTION...

Hi, I'm running a IDS on a Windows 2000 machine with just one CPU. Sometimes I found that oninit took 95+% CPU and caused other application failure. Is there a way to configure Informix so that it would not take too much CPU resource. Thanks Peng

Hi there, Have you guys seen the following problem before? Environment: Informix 9.21 TC5 is installed on Windows 2000 SP3 and a third party tool is installed on the same machine which has nothing with Informix but it may use ODBC. Both service is running. All test were done on the same...

Hi there, After some load test, my Informix server seemed hung there. I checked the Informix log, didn't seem to see anything wrong; and I checked the locks and no deadlock. The following is some output from onstat command, seemed to me that some user threads are waiting for a condition, but...

Hi there, I just run a complicated SQL from SQL editor. And I got the following error message: [Informix][Dynamic Server 2000][rrrpdb] SQL Error (-874): General exception error has occurred in the optimizer. But the strange thing is that I ran the same query against other servers with the same...

Sorry guys. I have solved this problem. FYI - I did a oncheck -pe on the dbspace with the extents overlap error. It shows informatio like this: Description Offset Size ------------------------------ -------- -------- RESERVED PAGES 0...

More information, I found the oncheck reports extents overlap. What does it mean? How can I resolve it? Thanks

Hi There, I'm a late comer with the informix adminstrator. One of my customer encountered an error when loading a flatfile into a table. The error message is as follows: load from 'e:\temp\accountinfo.txt' insert into accountinfo; -- [Informix][Dynamic Server 2000][rrrpdb] SQL Error (-847) ...

Sorry, Shriyan. Maybe I didn't make the question clear. What I wanted actually is how can I pass in the password without having to manually input them at Runtime. I just wanted to run a script to update the database at background without any interruption. Although I could use the using...

Thanks Shriyan! It's very helpful. But I got another problem: when I accessed another database, dbaccess doesn't like using clause to input a password except I create another SQL scipt containing the using clause. I need to pass the actual password to dbaccess. Do you know if there are some...

Thanks Shriyan, But do you have some thoughts on Windows 2000 platform? I'm thinking maybe I have to write a E-SQL program. Peng

Hi There, Can I write a command script file run by SQL Editor or something else and the script is smart enough to detect if a table or database object exists before it creates the object. I can do it in SQL Server where I can use "if exists (...)". But can I do it in Informix? Thanks

Thanks a lot. I got a sample code and am currently reviewing. Regards, Peng

Sorry, me again. Or if HPL has some programming interface so that I could invoke it from inside a C code, that would be wonderful. I know Microsft DTS has some COM interfaces allow you programtically scheduling the transformation job. I'm just wondering if Informix HPL has the similar...

Thanks a lot. But what I was trying to do is that we need a upload/load program which will do the upload/load when a certain condition happens and it would do the upload/load many times a day. I guess HPL won't meet the requirement. The program for now is using a cursor to insert row by row...

Hi There, I can use "Load" statement in SQLEditor, but when I tried to use "Load" statement in a E/SQL program, I have some problmes. Does anybody know how (if) I could do this? Basically, I'm trying to write a program to do automatically and periodly data flushing and...

Hi Guys, I'm looking for tools for Informix (or some general tools for all databases) to analyze SQL code against the schema to see if there are some performance issues? Thanks

Hi Dmooreora, Do you mean that instead of invoking a stored procedure directlt from Crystal Report, A view(or table) has to be created for Crystal Report to invoke and the stored procedure is called in the view? Can you elaborate it a little bit 'cause I have the same question. By the way...

Thanks a lot, vpshriyan