Informix

• Informix Questions

• • SQL to retrievemode value

    Does anyone who how I can get the mode (most frquent value) with the SQL with Informix database usin...

    By islamabadi

  • Redbrick database compatibility betn 64-bit and 32...

    Hi,Please find below the the points that i require to know:1. from a 32-bit Redbrick client applicat...

    By koustav

  • Redbrick Troubles

    Im implementing a data warehouse aplication, but my redbrick server is not supporting any queries, t...

    By vickycavazos

  • RedHat7.3 Informix SE more command

    Using Redhat 7.3 on smp 2.4.18-18.8 patched kernel with Informix-sql v7.31.uc1.If I create a shell s...

    By greyboy

  • failed initialisation after cold restore

    Env: Sun Solaris 8, Informix 9.3Hopefully someone can help me as I am no informix expert but have to...

    By ossibissa

• • how to read primary key

    Hi,i want to write a stored procedure that inserts into a tablewhich has primary key of type SERIAL8...

    By bzuborski, 3 Comments

  • How to search for a on Informix

    Hello,is there a way to search for a ' ? I tried things like :Select ... from ... where ... lik...

    By mmtw816, 7 Comments

  • Buffer Wait Ratio

    Greetings,I have a question with regards to monitoring buffer wait ratio (BR). When checking this, ...

    By ghed, 8 Comments

  • Sql statement to insert text datatype

    Dear All,We use filetoblob & filetoclob function to load data in to blob & clob datatype through sql...

    By lloydnwo, 3 Comments

  • SQL command for turning off trigger and loging mod...

    Hi,I have to load a 10000000-line file to a table which is with triggers, and the DB is with unbuffe...

    By dolphin4022, 1 Comments

• Informix: is the Category's subject.It's has 140 questions,this is No.7 pages.
• Recovering database
• Hi there,How can i recover some of my database files using command line. How will i know if there is some files that i need to recover. In oracle i think this can be seen in v$recover_files how bout in informix?Thanks,...
• nylanej, Sat, 13 Mar 2010 20:27:00 GMT, 240 bytes, 2 Answer
• How to read Time stamps of rows
• Hi,I need to read rows which are inserted later than a particular row.eg; If i have the following rows f e c a xis it possible to read only the rows after c(i.e a,b).One way i feel is to know the timestamps of rows. Is there any other method to do so.Bye....
• pathri, Sat, 13 Mar 2010 18:20:00 GMT, 331 bytes, 3 Answer
• SQL Statement Error.
• Hi..All,I have one problem.Im using informix Dynamic Server v 9.4x on Windows NT System.I have db_one,db_two databases in My instance ol_instance1I connected to db_one database using dbaccessHow can i select the table table1 from db_two database where im in @db_one database.i tried select * from...
• maruthi, Sat, 13 Mar 2010 10:37:00 GMT, 443 bytes, 1 Answer
• database deleted
• the online.log file says 14:55:06 rsinit.c, line 9932, thread 29667, proc id 557, Segmentation Violation.14:55:06 PANIC: Attempting to bring system down14:55:07 out of virtual shared memory14:55:07 shmat: [ENOMEM][12]: out of available data space, check system MAXMEM14:55:07 out of virtua...
• ranga71, Sat, 13 Mar 2010 05:59:00 GMT, 1,602 bytes, 1 Answer
• Sql Server connecting from informix
• How can I connect Sql Server 2000 from Informix DS? Informix DS version is 7.34 TD....
• mzkilic, Sat, 13 Mar 2010 03:47:00 GMT, 83 bytes, 1 Answer
• Maniplulating indexkey on sysindices
• I am assuming this is an opaque data type.Is it possible to select from the various fields in indexkey.Where are these methods documented.My background predates these structures....
• bobelliot, Sat, 13 Mar 2010 03:47:00 GMT, 208 bytes, 3 Answer
• SQL code
• In Oracle you can test wheter an SQL statement succceded or failed using the sqlca.sqlcode valueIs there such a thing in Informix (to use in a stored procedure) ?...
• artik, Sat, 13 Mar 2010 03:44:00 GMT, 172 bytes, 2 Answer
• Data Stage
• I have a question about Data Stage. I need to run a job that read a file in a FTP area. How I can do this?Thanks, Claydson...
• claydson, Sat, 13 Mar 2010 03:43:00 GMT, 127 bytes
• SQL Error -1829: Cannot open file csqli.iem
• Dear All, I have found this error when I run my Powerbuilder 6.5 application with Informix 7.3 on XP. I really do not know what happened, any advice?ThanksGary Lam...
• garylam, Sat, 13 Mar 2010 03:43:00 GMT, 194 bytes, 1 Answer
• bug with interrupt key in 4gl 7.31
• Hi. I'm using 4gl 7.31 UC1 on Linux Redhat 7.0I have a 4gl program using DEFER INTERRUPT , so I use int_flag to know if user has pressed that key.The problem is that this works only once! When user press again interrupt key, it doesn't work!(on 7.30 uc5 version this worked fine!)Any...
• eos, Sat, 13 Mar 2010 03:42:00 GMT, 336 bytes, 2 Answer
• SQL quiries(On Informix) are too slow
• Hello all,I have some quiries with joins of different tables and at the end order by clause. These quiries take very longer time from 7 Min to more.The Records in the datatbase are more than half millionWhen ever I remove the order by clause then the quiries pull out with in seconds.Here is samp...
• iahmad, Sat, 13 Mar 2010 03:42:00 GMT, 666 bytes, 12 Answer
• SQL to AS/400 using IBMDa400
• I am trying to create a linked server to the AS/400. I use the following and it is added successfully or so I believe.EXEC sp_addlinkedserver @Server=IBMTL400,@SrvProduct='IBM AS400 OLEDB Provider',@Catalog='mylibrary',@Provider=IBMDA400,@Datasrc=PRODCL400,@Provstr='Pr...
• fcib, Sat, 13 Mar 2010 03:39:00 GMT, 973 bytes, 1 Answer
• SQL syntax checking
• Does anyone know of an easy way to syntax check SQL without the statements having to run?I'm writing shell scripts containing SQL, and it's a pain to wait several minutes for valid queries to complete only to find syntax errors later on. If there is a way to syntax check the whole lot...
• dene, Sat, 13 Mar 2010 03:37:00 GMT, 367 bytes, 2 Answer
• SQL SERVER vs INFORMIX
• what's the difference between synonym and view? If i want to access in DATABASE A table AA from DATABASE B, i use create synonym AA for databasea@servera:AA, or use create a view with the same name AA on Database B, for accessing table AA in databaseA, is there any diffrence on result ? per...
• meiwen, Sat, 13 Mar 2010 03:36:00 GMT, 316 bytes, 2 Answer
• Regarding isam_err
• Hi, while executing my application, I got the following error. Please tell what it means.DBError -565: Cannot read sorted rows. , isam_err = -131, loc = 'select count from aaa'thanksSarwan...
• sarwan, Sat, 13 Mar 2010 03:33:00 GMT, 233 bytes, 1 Answer
• failed cold restore with ontape
• HelloAfter performing a "ontape -r" command the Informix IDS 7.31 server remains in Fast Recovery blocked in checkpoint.In the message log the following message appear " Warning : Recommended smallest logical log size is 2 times maximum concurent user threads. Logical log layout may cause Dynami...
• arcadian, Sat, 13 Mar 2010 03:33:00 GMT, 412 bytes, 2 Answer
• Database size
• Hi! AllHow can I get the total size of the database either using SMI tables or using any inbuilt utility.Thanks & Regardsadityanlal...
• adityanlal, Fri, 12 Mar 2010 12:14:00 GMT, 156 bytes, 2 Answer
• SQL in a batch file... strange
• Hi,Informix on NT Server.Created this batch file contining the following commands in it: e:\informix\setenv dbaccess dbname file.sqlWhen I try to execute the batch file, it executes the 'setenv' and then returns to the prompt without executing the 'dbaccess' part....
• m2001, Fri, 12 Mar 2010 09:09:00 GMT, 588 bytes, 2 Answer
• Recovering old backups
• I want to recover an older whole backup.I'm using Veritas netbackup with informix 7.3Exemple: every night there is a whole backup we are Monday I want to recover the Saturday backup how can I instruct onbar to do this?...
• alex1668, Fri, 12 Mar 2010 05:32:00 GMT, 290 bytes, 4 Answer
• Redhat linux on inspiron 8200
• Hi all,I want to buy a dell Inspiron 8200 to use redhat linux kernel-2.4-9.21, Do any of you know if the network card /video/ sound will work?nic: 3Com 3C920 10/100 Base-TX video:ATI Radeon 9000 64MB or GeForce4 Go NVIDIA 32MB Audio:Crystal CS4205 AC'97, systme de dcodage AC3 about the...
• saad, Fri, 12 Mar 2010 00:28:00 GMT, 561 bytes
• 1234567