informix

Informix SQL count() comparisons

I'm trying to build a SQL query that will count both the total number of rows for each id, and the number of 'FN%' and 'W%' grades grouped by id. If those numbers are equal, then the student only has either all 'FN%' or all 'W%' or a combination of both. I need a list of all the id's who only have stats of 'FN%' or 'W%' example id # 6...

Upgrading Informix - Switch to Oracle, Sybase or stay with Informix?

Hi, Previously I posted a question so I could confirm our current (albeit archaic) version of Informix here: http://stackoverflow.com/questions/682154/how-do-you-identify-informix-version-on-solaris (Thank you Jonathan and RET for clearing that up) We are definitely planning on upgrading but are first discussing if it would make more...

Show a one to many relationship as 2 columns - 1 unique row (ID & comma separated list)

I need something similar to these 2 SO questions, but using Informix SQL syntax. http://stackoverflow.com/questions/37696/concatenate-several-fields-into-one-with-sql http://stackoverflow.com/questions/368459/sql-help-select-statement-concatenate-a-one-to-many-relationship My data coming in looks like this: id codes 63592 PE...

Career in Informix

I am currently working as a MySql Database Designer (2+ years of experience, earlier in MS SQL) in Some Company. I am getting an oppoortunity to work with Informix Database in a big company. Will it be a good decision to shift to a new field? How's the career in it? Can anybody show me the light? ...

Migrating Informix ESQLC to Oracle Pro*C

Hi, Currently tasked with migrating Informix ESQLC files to Oracle Pro*C and have a few questions. First, we use a lot of proprietary Informix functions within our embedded ESQLC code such as: rstrdate( ), rtoday( ), rjulmdy( ), etc. Any pointers on how to convert these in Oracle Pro*C? Another thing I'm struggling with understanding ...

How can I just get an IfxBlob from am Informix query in .net?

I can't seem to find a way to get just the locator object of a column under .Net. It seems that Informix is automatically converting the blob column to Byte[] and not leaving a way to change that behavior. IBM.Data.Informix.IfxConnection c = new IBM.Data.Informix.IfxConnection("..."); c.Open(); IBM.Data.Informix.IfxCommand c...

Why Python informixdb package is throwing an error!

I have downloaded & installed the latest Python InformixDB package, but when I try to import it from the shell, I am getting the following error in the form of a Windows dialog box! "A procedure entry point sqli_describe_input_stmt could not be located in the dynamic link isqlit09a.dll" Any ideas what's happening? Platform: Windows Vi...

Informix to Oracle: Dealing with Fetching Null Values

A bit of background first. My company is evaluating whether or not we will migrate our Informix database to Oracle 10g. We have several ESQL/C programs. I've run some through the Oracle Migration workbench and have been muddling through some testing. Now I've come to realize a few things. First, we have dynamic sql statements that are n...

Why does Perl's DBI complain about "Fetch attempted on unopen cursor"?

Here is my script: $db_handle=DBI->connect("$dbstr", "", "", {RaiseError => 0, AutoCommit => 0, PrintError => 1}) || die "Connect error: $DBI::errstr" ; $result=$db_handle->selectrow_array("set isolation to dirty read"); Note: $dbstr is a valid database name. I am not a database programmer. What am I doing wrong which is causing the...

How can I avoid the program quitting when Perl's DBI encounters an error preparing a statement?

I'm making a script that goes through a table that contains all the other table names on the database. As it parses each row, it checks to see if the table is empty by select count(*) cnt from $table_name Some tables don't exist in the schema anymore and if I do that select count(*) directly into the command prompt, it returns...

Pretty Print for (Informix-)4gl code

Hi, i'm searching for a pretty print program (script, code, whatever) for Informix-4GL sources. Do you know any ? Than you, Peter. ...

Informix - ALLOW_NEWLINE

Hi there, I understand how ALLOW_NEWLINE works. However I don't understand why the option is there in the first place. I would have thought that having it on permanently would be more useful rather than not. Then you can control when you want newlines to appear by inserting "\n" in your code. Can anyone explain why the option is ...

How to use genxmlquery function of informix using JDBC?

I have the need to extract result of the database query in XML format. I have planned to use JDBC as my programming language. I came across the XML publishing function of IDS 11.0 and planned to use that. Have configured the database settings to perform XML publishing and am able to execute a query in command prompt (dbaccess databasenam...

Informix defining an INTERVAL with a parameter

I am doing the following in Informix to delete rows more than 20 seconds old. delete from sometable where someDateColumn < (current - interval (20) second to second); However, I want to make the interval configurable in a stored procedure, but I can't do CREATE PROCEDURE i_hate_informix (prm_timeframe int) DELETE sometable ...

Lost RPC connection to remote Agent error with Oracle connected to Informix

I am having a problem with a simple data importer / updater that takes data from Informix, inserts it into a table in Oracle, and updates a flag in the original table. The set up is this Pro*C program calls a PL/SQL procedure The procedure opens a cursor on Informix, loops through each row insert the data into an oracle table ...

Script to copy data from one Informix database to another

Hi, I have a need to copy data from one Informix database to another. I do not want to use LOAD for doing this. Is there any script that can help me with this? Is there any other way to do this? Thanks in advance! Ravilla ...

Informix subqueries with FIRST option

What is the best way of transcribing the following Transact-SQL code to Informix Dynamic Server (IDS) 9.40: Objective: I need the first 50 orders with their respective order lines select * from (select top 50 * from orders) a inner join lines b on a.idOrder = b.idOrder My problem is with the subselect because Informix...

How to do a NVL (or DECODE or CASE) statement within an Informix SE SQL query ?

Hi, IBM is very clear on his Informix Standard Engine, it doesn't support neither CASE nor DECODE. "Please upgrade to a new version" : http://www-01.ibm.com/support/docview.wss?rs=632&amp;context=SSGU5Y&amp;dc=DB560&amp;dc=DB520&amp;uid=swg21189712&amp;loc=en_US&amp;cs=UTF-8&amp;lang=en&amp;rss=ct632db2 It will never happen ! So maybe...

Informix & .NET

I'm connecting to Informix 6.5 using the IBM OLE DB Driver. Some clarification: Informix Dynamic Server Workgroup Edition. Please note that there are many versions of IDS/WE - it helps to be precise about which version you have. It might be something like 10.00.TC1; the version number could be as old as 7.xx.TCx, or as new as 11.50.TC...

Informix 7.3 isql insert statement - text/blob/clob field insert error

Is a way around this?? I am trying to insert some data into a table whose structure is: Column name Type Nulls crs_no char(12) no cat char(4) no pr_cat char(1) ...