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...