Home » Category » Informix

Informix

• Session ID

• Is the session id created on DB connection re used, what I mean is if I have a session ID 2 and then I disconnect from the DB, is it posible that this seesion ID be re used again w/out restarting the database...
• Fri, 03 Sep 2010 06:55:00 GMT | 208 bytes

• Informix 4.10.UE2 (SCO) + linux-abi = 922: Cannot get name of

• Robert Giles wrote:> Howdy folks - I'm at a loss on this one.> I have a copy of "INFORMIX-SQL Version 4.10.UE2", originally installed> on a SCO 3.2v4 machine, dumped onto a Linux machine running 2.6.11> (and the 2.6.11-rc1 linux-abi kernel patches).I4GL 4.10 - circa 1989, 1990 a...
• Fri, 03 Sep 2010 05:55:00 GMT | 2,838 bytes

• Problem with DTS and IBM Informix OLEDB Provider

• Hi, I have a problem with DTS and the IBM Informix OLEDB driver. I have a SQL Server 2000 database on a Windows 2000 machine. Informix is installed on a Linux OS on a separate machine. My job was to copy data from a table in the Informix database to a table in the SQL Server database on a p...
• Fri, 03 Sep 2010 04:55:00 GMT | 3,030 bytes

• Senior Oracle DBA now Learning Informix by Request

• Neil Truby said:> "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message> news:mailman.573.1166117478.29126.informix-list@iiug.org... > OK, I'll take the bait. Which is the "English vice"?Other usesCaning is also a more severe but not uncommon sadomasochistic practice...
• Fri, 03 Sep 2010 03:55:00 GMT | 1,183 bytes

• Debugger is already open?

• After using the Server Studio Stored Procedure Debugger without anytrouble in days past, I went to use it again but could not. Theinvocation was:1. Tools -> Stored Procedure Debugger -> Open to get the Connectwindow.2. OK to get the Select Database Object window.3. Enter name of existing r...
• Fri, 03 Sep 2010 02:55:00 GMT | 877 bytes

• Fwd: Insider #75: Highlights: IBM Information On Demand 2006,

• And another 1800 euros for room only accomodation, the price justracks up and upOn 01/10/06, Captain Pedantic <theharlequin36@hotmail.com> wrote:> Why is the customer un-named?>> _______________________________________________> Informix-list mailing list> Informix-list@iiug....
• Fri, 03 Sep 2010 01:55:00 GMT | 526 bytes

• Informix versus Oracle Spatial

• Can anybody say that Informix is better than Oracle in terms of spatialcapability? Is there any references on the web where I can compare the two?Michael...
• Fri, 03 Sep 2010 01:55:00 GMT | 165 bytes | Answers (1)

• Urgent (Blobs and Smart Blobs)

• "Jonathan Leffler" <jleffler@earthlink.net> wrote> BYTE and TEXT blobs can be stored IN TABLE; that is, in the same dbspace> as the data in the rest of the row. When that happens, the blob data is> on separate pages. IIRC, in table blobs are logged through the log files> and bu...
• Fri, 03 Sep 2010 01:55:00 GMT | 778 bytes

• System or internal errorDSRA0010E: SQL State = IX000, Error Code

• pedro wrote:> Hi,> We have a web application deployed on a websphere 6 application server> that's used to make some queries over an informix database. When> executing a specific operation the apps executes a query on the> database and gets the following exception:> com.ibm...
• Fri, 03 Sep 2010 00:55:00 GMT | 5,278 bytes

• buffered or unbuffered loging

• HiWhen querying sysmaster:sysdatabasesthere are fields: is_logging and is_buff_log I'm assuming one is for unbuffered and the other one is for buffered.I have two values 1 and 0 I'm assuming 1 for yes and 0 for no right?also, one database has 1 and 1 in both columns, how is that possi...
• Thu, 02 Sep 2010 23:55:00 GMT | 547 bytes | Answers (1)

• Informix ODBC driver

• I was testing a C++ ODBC library which access Informix databasevia unixODBC open source Driver Manager. Reading from databaseworks fine but in inserting the data I got error message:"Exception type: DBExceptionMethod: DBStmt::ParamData()Error Message: SQLParamData() call failed in statement "IN...
• Thu, 02 Sep 2010 23:55:00 GMT | 1,396 bytes | Answers (1)

• I4GL licenses

• I have a query regarding I4GL Compiler licenses.What is the difference between development and runtime (concurrent users)licenses? That is, when are they required?As far as I understand, if I have 3 developers, each using 5 simultaneousi4gl sessions, then I need 3 developer licenses and 3 X 5 =...
• Thu, 02 Sep 2010 23:55:00 GMT | 488 bytes | Answers (5)

• Error connecting to Informix Database

• I compiled PHP with the informix client sdk mod to allow me to connect to an Informix database using php commands. Everytime I try to connect though I get an error and I have no idea what the error is referring too. Here is the code and error.$conn_id = ifx_connect ("XXX.XXX.XXX.XXX", "user", "p...
• Thu, 02 Sep 2010 22:55:00 GMT | 630 bytes | Answers (5)

• Error code -957

• Hi there,I have got this error "Cannot create/access database on NFS mount. "(-957 Code ERROR) when I try to connect to INFORMIX SE 7.24 (runningon Solaris 2.4) from a PC using INFORMIX ODBC driver 4.1. sqlhosts file on Linux Redhat 7.2 is:betatcp setlitcp beta betatcp/et...
• Thu, 02 Sep 2010 22:55:00 GMT | 681 bytes | Answers (1)

• Pls Help: Cannot install IDS 7.30.UC7-1 on Fedora 8. Segmentation

• Hello good people,SElinux is disabled. After IDS rpm install:cd /opt/informix./installserver #after entering the licence key produces the followingerror:etc/install: line 197: 4956 Segmentation fault $BRAND -n -s$SERNUM $KEY $NAMInstallation of Informix Dynamic Server failed.Looks like FC8 does...
• Thu, 02 Sep 2010 21:55:00 GMT | 437 bytes | Answers (4)

• Postcards - 2nd set

• http://www.db2mag.com/postcards2.shtmljgp...
• Thu, 02 Sep 2010 21:55:00 GMT | 131 bytes

• help me please.

• Hi, I have a flat file, exaple.aaaa bbbbb cccc ddddd eee ffffaaaa bbbbb cccc ddddd eee ffffaaaa bbbbb cccc ddddd eee ffffaaaa bbbbb cccc ddddd eee ffffI need put it a pipe line in aech field, the flat file must beso as.aaaa|bbbbb|cccc|ddddd|eee|fff...
• Thu, 02 Sep 2010 15:55:00 GMT | 491 bytes | Answers (5)

• Upgrade to IDS 10

• We are planning to upgrade form IDS 7.3 to IDS 10.? In a few months.At the moment, we are running 4gl 7.20.UD. Does this version runs withIDS 10 ? We would like to wait to upgrade our 4gl because we arethinking of replacing the 4gl by something else (4js, egl, ...) in thenear future.sending to i...
• Thu, 02 Sep 2010 13:55:00 GMT | 328 bytes | Answers (2)

• Insider #75: Highlights: IBM Information On Demand 2006, The Next Informix IDS Rel

• > I don't think our croatian friend was objecting to having to pay. It's just> that it's a lot of money. I don't know what Croatian salaries are like but> I think they are probably a lot less than a DBA would get in UK.Sorry maybe I wasn't as clear as I hoped.I...
• Thu, 02 Sep 2010 13:55:00 GMT | 833 bytes

• Working around with informix

• Hi Guys,I am very new to informix.I got a copy of informix IDS 9.4 and installed it.It went succesfull except datablade which needed VC++.But after the installation,I had these programes in my startupInformix Dynamic Server 9.4>DOcumentation Notes>Release Notes>Informix Error Messages&g...
• Thu, 02 Sep 2010 12:55:00 GMT | 1,038 bytes