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...
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...
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...
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 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...
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,...
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...
is there an efficient way of retrieving the last inserted row id in Informix.
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 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 ...
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...
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...
I have 2 tables. One table 'POHEADER' contains the address, vendor, and PO number. The second table 'PODETAILS' contains the product, quantity, pricing, etc..
I am trying to write a sequel...
I have a CSV extract of an informix database, I'm wanting to import the data into sql server 2000 along with the table properties.
I do not have access to informix.
I notice I have a sys...
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 ...
We want to migrate from Informix to oracle 10G. We have some CUI code which need to migrate as a part of this. Can you help me with my question:
How shall I migrate 4GL code its equivalent C ...
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...
This is probably either an Apache configuration or PHP configuration or PHP code question.
I am running PHP Version 5.2.0 on Apache 2.0 (Red Hat Linux RHEL v4) and running queries against a...
I have two queries that I am trying to run. The user enters a startdate, a stopdate and a program. I then dynamically build the SQL statements are run them. On both queries, the field that ...
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...
Any one knows how to store a parametrized View at Informix (v10), and then how to pass the parameters to it via VB 6 ADODB query?
