Advertisement

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

 

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

 
Top Informix Solutions: 1 - 12 of 12
  • 1
 
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 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...
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.
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 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...
hi, i am trying to connect to an informix database Version 5.06 with jdbc, the DriverManager.getConnection instruction loops up and returns nothing. i tried the same connection in a serve...
Hallo, I have a problem, until now I use only Oracle DB but now I have to change to Informix, and I have no experience about it. I have some sql statements for Oracle like below, can I use t...
I am trying to use a derived table as part of a query in informix. I am tring to show the maximum date from it. I keep getting error messages, which are not helpful i.e. Unknown error messa...
How to execute a stored procedure in informix???I am pretty new to Informix and have no clue how to run this to check the existing proc results. i am more acquainted with SQL . I would rea...
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...
Trying to determine if I can use FRx with an Informix database using the Informix ODBC conecctions.
Now I have an other clause it should meet some preconditions in Emergency mode(That's where the priority comes in,in emergency they halt the resources). -Records must be processed in due date...
 
  • 1