Advertisement

900 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%!

 
raterus

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Time Tested Informix Solutions: 1 - 25 of 48
 
Convert char to numeric value in Informix SQL
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...
How to get row number with SELECT statement
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...
VBA - SQL statement over multiple lines
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...
SQL - Displaying month to date sales
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...
How to do IF or CASE statement within an Informix SE SQL query
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!
Last Inserted Row ID
is there an efficient way of retrieving the last inserted row id in Informix.
Informix shutdown and startup script for RHEL cluster suite
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...
IDE like TOAD for Informix?
I am looking for an IDE for Informix similar to TOAD. Any suggestions?
informix
How to create a database in INFORMIX? I am new to DBA staff, buit I need to know that  ASAP
How to do an if/else in an Informix SQL Query
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...
string manipulation in informix tsql
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 ...
INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES, multiple informix servers on server
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...
Informix Case Statement in Where Clause
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...
Need to write Complicated SQL Update Query in Informix
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...
Informix - Datediff problem
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...
Exception "Unable to find an entry point named 'SQLGetConnectAttrW' in DLL 'iclit09b.dll'." when attempting to connect to Informix DB from .NET (C#) code
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...
Using INSERT in multiple tables that are linked with a Primary Key
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,...
SQL Server 2000 Trouble selecting distinct names
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...
Source Qualifier in informatica powercenter.
Is there any option in informatica powermart to make sure that the rows returned by the source qualifier will be processed in the top to down fashion.
SQL ho to retrieve multiple records form table1 linked to table 2
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...
SQL Server 2000, Comma problem.....saving as CSV
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...
PHP / INFORMIX insert line breaks into vchar field
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...
Delete from one table while joining to another using informix dynamic server
I think I've used this delete syntax with other databases, and it's worked ok, but it doesn't seem to in informix. I know how to get it working using a temp table, but I'm hoping there's a mor...
setting up an Informix ODBC connection
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...
Using more than one join on an Informix Database
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 ...