My current knowledge: Oracle does offer index-organized tables and defaults to heap-organized. I heard that SQL-Server uses only index-organized tables I am especially interested in answers for MySQL, Informix and DB2. ...
I'm curious as to how Informix (7.3) deals with temporary tables created with no log when a session is terminated without dropping those tables. I connect using iSQL: cat |isql db Then, for example, I create one or more temporary tables with no log: select first 10 * from table into temp t0 with no log; If I don't drop this table wi...
Hi SO, I'm writing a c# app that inserts a large (1GB+) amount of data into a BLOB in an informix database. However, many times the file is too large and the process runs out of memory. I have implemented the WCF Chunking Channel to mitigate this, but I need to put these chunks into the BLOB without consuming memory to store them all....
Hello, I am running 2 queries against an informix database. the queries are hitting 4 different tables with both inner an outer joins. I thought they should both return the same result set, but I am getting a 3 record difference. below are the 2 queries - query 1 (returns 65 rows) - select ... from table1, table2, outer tab...
I have evaluated several development tools for converting my informix SQL-based app. They are: Genero/4Js, FileMaker, Oracle APEX, VFP, Clarion and Access 2007. I have a CRUD pawnshop app (see video-demo www.frankcomputer.com) This app centers on customers who pawn, sell or buy merchandise. I need to have one CRUD multi-table form which...
I have recently installed Mono on our Fedora Linux system so that we are able to run ASP.NET applications on it. I was able to get this part up and running, but the problem is we use a Informix DB and Mono seems to stop the ODBC from working. Have anyone any experience of getting an ODBC to connect to an Informix DB with Mono instal...
I need to design my schema in Informix such that querying a BOOLEAN with an INTEGER type will work. e.g. SELECT id FROM mytable WHERE isavailable = ? works if I provide either a boolean False or an integer 0. I know I need to set up the schema with some kind of cast, but I'm not sure how. The reason for doing this is a bug in another par...
Hello, I am trying to connect to an informix database on a 64 bit windows 7 pc. I have been able to make the connection just fine on a 32bit pc, but I get the above error when trying to run it on the 64 bit pc. It is looking for the IBM.Data.Informix driver, but says it can't find it. I've got 2 versions of that dll in my GAC - 3.0.0....
I am on a linux system, logged in as the informix user. I have the following environment variables set: INFORMIXDIR=/opt/IBM/informix INFORMIXSQLHOSTS=/opt/IBM/informix/etc/sqlhosts.mydb INFORMIXSERVER=rep_0 The contents of sqlhosts.mydb are as follows: g_rep_0 group - - i=0 rep_0 onsoc...
I want to use column aliases while selecting the column in an informix database table. For example in the following query: SELECT hire_dt as "Hire Date" FROM employee Column hire_dt should be displayed as Hire Date. How can I do this in informix? ...
I'm quite new to Ibatis so I might be missing something, but I can't seem to be able to figure out why I'm getting this error. I'm getting this error when I try to save a Person object which has a weapon reference variable. I know the person object isn't null since I validate the object to see if the weapon reference variable isn't nul...
Is there a way to convert a list of values into a comma-delimited string in Informix? For example, I have the following query as a subselect: SELECT [State] From States I would like to convert all the values from that select into a comma-separated list. Can I do that in informix? ...
I am building a report in Reporting Services 2005, where the data is retrieved from an Informix database. The connection to the database is declared via ODBC. Here is the simpler version of the query: select prodtype, familynum, family, sum(invested) invested, month(recevdate) month, year(recevdate) year, d...
I am using the Informix.NET driver (C#) to insert a row into a database table. This works fine, except I have no idea how to get the ID of the last inserted row: Insert Command: //Sample Query: "INSERT INTO names (id, name) values (0, 'John Smith');" public static void Insert(String query) { try { ...
INFORMIX-SQL 4.10: OK, So after fixing the INTO TEMP syntax and using AS aliases, the ACE compiler complained about not having every single alias in a GROUP BY clause so I added it to each SELECT statement. However now I still get a GRAM ERR on the FORMAT statement (see updated code sample) database PAWNSHOP END define variable sfech...
I'm not sure which is the way to go for choosing a report type with my current setup. In the past I was using MS Server 2008 R2, MS SQL Server, MS.NET C# 3.5. Now I'm using something similar except my Database is IBM Informix and I'm using MS.NET C# 4.0. I'd prefer to use RDLCs since I'm used to them, but I didn't wanna jump down that a...
Hi all, I searched a lot, but couldn't find anything.. I just want to ask if there's any way to create and call a procedure (Informix) with out parameters. I know how to return one or more values (for procedures and for functions), but this is not what I want. It would be really strange, if Informix does not allow output parameters.. ...
Is there a way to connect to an Informix database using Sql Management studio? Are there any open source / free clients that can be used? ...
Using IBM Informix Dynamic Server Version 10.00.FC9 I'm looking to set multiple field values with one CASE block. Is this possible? Do I have to re-evaluate the same conditions for each field set? I was thinking of something along these lines: SELECT CASE WHEN p.id = 9238 THEN ('string',3) END (varchar_field, int_field); Where the...
The following SQL takes 62 seconds to return: select getCreditBalance(Customerid) from business_apply where serialno = '20101013000005' How to tune it? Please tell me in detail. I just want to know the steps I should do to tune it . we use IDS 9.04 . As in JDBC I cant see output with SET Explain ON shall I execute query in dbac...