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...
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...
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!
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...
is there an efficient way of retrieving the last inserted row id in Informix.
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...
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?
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 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...
Hello experts,
I have trouble using my TSQL knowledge to create queries on Informix Databases. I want to do a daily grouping. I have a column with whole date time expression including time ...
Hi, I'm trying to run the following query in SQL Server 2000:
Select DISTINCT (lname + ', ' + title + ' ' + fname) AS Name, pho As Phone, (unit + ', ' + jobtitle) As UnitTitle,
eadd As Em...
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...
Hi, I'm trying to run the following query in SQL Server 2000:
Select DISTINCT (lname + ', ' + title + ' ' + fname) AS Name, pho As Phone, (unit + ', ' + jobtitle) As UnitTitle,
eadd As E...
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 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,...
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...
Hi experts,
I have 2 tables
one is made of
id
values
docid
reference
the other one has several fields
...
serial
...
reference in table 1 is linked to serial in table 2
now I ne...
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...
Hi All,
I have a informix database in solaris 10 operating system and I want to migrate my database to Mysql in RHEL5 Operating system.
It will be great help if somebody suggest some tools...
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 ...
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...
Hello Experts,
I need to prepare an ODBC connection for Informix to be used with Infomaker. I have database and sql experience however, I have no knowledge of informix. I require help setti...
Hi Experts
I am currently working on an Excel sheet which, with the aid of VBA populates a sheet with data from an Informix database.
My problem is that when I try to use more than one ...
