Hello.
I am writing some VBA so it can grab the information i require from the database and put it into excel. No problem really, except for one apparent simple hurdle. One of my SQL statem...
I'm running Informix SE, not sure which version exactly.
What I want to know is whether it's possible (and how) to use an IF statement or CASE statement within an SQL query?
Thanks!
Hi, I have a query which I want to go something like:
select fw_year
from table
where fw_year[1,4] between 2002 and 2007
and fw_year <> "BLAH"
The fw_year column contains values like "2...
Hello,
Quick Question:
I wrote an SQL statement that selects the sales value for each day throughout the month chosen.
Statement as follows:
select sphwhseno, extend (spddate, mon...
I would like to know whether it is possible to get row number with SELECT statement in Informix. If yes, how?
For example, SELECT Some_Function() AS ROWNUM, Col1, Col2 FROM TableA
My expec...
Hi experts,
In one of my projects I am having some strange Problems. Even if they occur about every 3-4 Months, I would like to get rid of them.
The problem is that I have a JDBC connec...
is there an efficient way of retrieving the last inserted row id in Informix.
How to create a database in INFORMIX?
I am new to DBA staff, buit I need to know that ASAP
I am looking for an IDE for Informix similar to TOAD. Any suggestions?
Hi All,
i'm trying to connect to an informix server using jdbc . i am running into problems connecting to some Informix Servers. The server has multiple instances of Informix servers instal...
I am querying an informix database, using the following command in SQL
SELECT count(wdheader.ch_caseid) as completed
FROM arista01:root.wdheader wdheader, arista01:root.wdactfs2 wdactfs...
If I generate data in a text file, is there a way to create a scheduled task which will import it to Informix table?
Thanks in advance
I am new to SQL and need to figure out how to insert coulmns into two tables that are linked by a primary key.
I tried:
INSERT INTO tableone(data1, data2, data,3)
VALUES (1,...
Good day. Can you give us a sample shutdown and start up script for Informix database that is running on a RHEL 4 cluster suite so that if one node fails, the informix database will start auto...
I have a case statement in the where clause of a query on a linked server. No matter what I do, I keep getting where row_date >(today-4)
I want it to be row_date between (today-4) and (tod...
I'm having trouble installing JDBC for informix on a linux machine (fedora core 4 & ubuntu 7.10). I downloaded it from de IBM site, and proceded to install it. Fist of all, what you download i...
I am trying to write a complicated SQL update query (at least it's complicated to me, probably simple to others). I need to update table a (adm_rec) with the data from table s (sch_rec). But a...
I need to migrate the informix DB to mysql. However, the database schemas of the source/destination are slight different. (2 tables from informix are merged into 1 in mysql)
informix table1 i...
I have multiple rows that I want to insert into a table. All of the data for the other columns are the same, so once I get these rows inserted I can do a simple update statement. I have severa...
After executing the folowing query this error pop up and I don't know Informix. The question is what was the cause and how to solve this problem:
---------------------- awas1c@awasuat_shm ...
I am attempting to connect to an Informix database from C# (.NET 2.0) code using the IBM.Data.Informix client libraries from the Informix Client 2.90. I have successfully created an ODBC conn...
Hi Experts,
I'm working on an ooooold INFORMIX 5.10 database, and want to change the "primary" extent (if that's what it's called) to say 1.5 times the current size of the loaded data, to m...
I am developing an application that inserts medical chart notes into an existing Informix database.. I have come across this issue.. I am unable to enter line breaks into a field. There are ex...
I am doing a simple select, but I am not sure of the syntax for an if/else statement in informix.
I want the mobile number to be from A2.phone but if A2.phone is null and A4.phone is not null...
I have tried to perform the following SQL to no avail (if the semicolon is removed, it works):
Does anyone know how to insert a ; into any field in Informix SQL?
My record definition...
