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...
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...
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...
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? ...
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 ...
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...
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...
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...
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...
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...
Hi, i'm searching for a pretty print program (script, code, whatever) for Informix-4GL sources. Do you know any ? Than you, Peter. ...
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 ...
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...
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 ...
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 ...
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 ...
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...
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&context=SSGU5Y&dc=DB560&dc=DB520&uid=swg21189712&loc=en_US&cs=UTF-8&lang=en&rss=ct632db2 It will never happen ! So maybe...
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...
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) ...