informix Questions
2
Solved
I have problem when I try insert some data to Informix TEXT column
via JDBC. In ODBC I can simply run SQL like this:
INSERT INTO test_table (text_column) VALUES ('insert')
but this do not work i...
28
Solved
I make an outer join and executed successfully in the informix database but I get the following exception in my code:
DataTable dt = TeachingLoadDAL.GetCoursesWithEvalState(i, bat);
Failed to ...
3
I need to split a field(Name) into Two (First Name and Last Name) based on a comma in Informix.
Example: "Mark, Wheeler J" has to be split as Mark and Wheeler. I have tried using SQL syntax but i...
6
Solved
I want to sort according to date first and then if date is similar then according to id..How to do that in Informix/HSQL query?
7
I'm looking for a way to transform a genuine string into it's hexadecimal value in SQL. I'm looking something that is Informix-friendly but I would obviously prefer something database-neutral
Her...
7
Solved
I need something similar to these 2 SO questions, but using Informix SQL syntax.
Concatenate several fields into one with SQL
SQL Help: Select statement Concatenate a One to Many relationship
...
Conners asked 3/4, 2009 at 19:30
7
I am using informix database, I want a query which you could also generate a row number along with the query
Like
select row_number(),firstName,lastName
from students;
row_number() firstName la...
Smut asked 23/9, 2008 at 5:27
9
Solved
So, I asked a question this morning, which I did not phrase correctly, so I got a lot of responses as to why NULL compared to anything will give NULL/FALSE.
My actual question was, what is the ti...
2
I would like to know if there is a way to see queries executing on Informix.
If I use onstat -g sql it just shows me the SQL statement type (if it is insert or select). But I want to see the comple...
4
Solved
Informix iSQL has a command "info tables;" that shows all tables.
The syntax for viewing the fields and their respective data types is "info columns for table;"
Is there a similar command that sho...
5
Solved
I want to insert multiple rows with a single insert statement.
The following code inserts one row, and works fine:
create temp table mytmptable
(external_id char(10),
int_id integer,
cost_amount ...
3
Solved
I need to select hardcoded values in one column, so I will be able to join them with table in Informix DB. So I try in different variations to do something like this:
select a from ( values (1), (...
1
Has anyone successfully configured two hikari connection pools with different datasources in a spring boot application? How do I do it using application.properties?
Cook asked 8/1, 2018 at 15:46
1
Solved
I'm very interested in using testcontainers in my project.
However, I'm having a hard time setting it up to work with Informix.
Note that I can start an informix container using Docker-for-Mac a...
Joappa asked 6/7, 2019 at 0:46
2
I cannot connect my spring boot application to IBM Informix database. I have added the informix data source in application.yml file.
I am using spring 4.
I get the following error.
no writeable ...
Druce asked 23/9, 2016 at 8:34
4
Solved
What is the best way to use a only the date part of a datetime field in a query?
I have a datetime field and want to group/count it by date.
4
Solved
I have a statement that needs writing (with generic names for stuff, since this is for work) to update a column 'updCol' in table 'tUpd'. tUpd also has a column 'linkCol' which is present in anothe...
Adna asked 19/9, 2012 at 11:13
3
Solved
I want to use EF6 with Informix database .
I have searched a lot and find that i can get
EntityFramework.IBM.DB2 6.0.2 from NuGet for Both Informix and DB2 but my main problem is the connection ...
Signalize asked 25/10, 2015 at 10:2
5
Solved
Is this the correct syntax for an Informix update?
update table1
set table1.code = 100
from table1 a, table2 b, table3 c
where a.key = c.key
a.no = b.no
a.key = c.key
a.code = 10
b.tor = 'THE'
a.g...
3
Solved
I'm trying to get multiple columns(insuredcode, insuredname in this case) from a single CASE statement.
The following query has been tried but it concatenates both insuredcode and insuredname as ...
5
I perform an insert as follows:
INSERT INTO foo (a,b,c)
SELECT x,y,z
FROM fubar
WHERE ...
However, if some of the rows that are being inserted violate the duplicate key index on foo, I want t...
2
Solved
This question seems to be asked quite a bit and the answer seems to change with time. I've spent the weekend getting the IBM Client SDK for Informix working on Debian (because most directions on th...
2
Solved
I want to use column aliases while selecting the column in an informix database table.
For example in the following query:
SELECT hire_dt as "Hire Date" FROM employee
Column hire_dt should be di...
Disinfest asked 21/9, 2010 at 10:26
2
Solved
I am trying to optimize my SQL query, so that we will not have to process the response on our JVM.
Consider we have following table with entries:
+-----------+-------------+
| Column1 | Column2 |...
Leaf asked 30/6, 2017 at 9:34
4
Solved
I'm looking for a way to list all the stored procedures in my database running on Informix.
Is there a table in the "informix".* database that lists stored procedures along with detail informatio...
Barbary asked 5/8, 2011 at 15:35
1 Next >
© 2022 - 2024 — McMap. All rights reserved.