Questions tagged [informix]

Question 1

I'm able to create a new dbspace using the semi-gui tool onmonitor (running a headless Linux server) But how can I do this from cmd-line / script? It seems you can use onspaces like onspaces -c -d $...

Question 2

I have inherited an Informix installation that contains a large amount of business logic in the form of procedures. The company also uses SQL Server, MySQL and Postgres for various roles. We're very ...

Question 3

I have an example query below that I am running that is only on one column, but multiple rows can be displayed: SELECT dbspace FROM tab_info_script WHERE database = 'dwh_vodac' AND tabname = '...

Question 4

Assuming a user has sufficient privileges on the server, is it possible to copy a database in its entirety within the same server/host, using SQL only (i.e. without having shell access to the Linux ...

Question 5

I want to explore (=looking at the first 100 rows) databases using the Informix SQL dialect. In Oracle SQL I would use SELCT* FROM table_name WHERE ROWNUM < 100 In Postgress SQL I would use SELCT* ...

Question 6

Is the analyzer discussed here same as Lucene analyzers? I am confused because most of them show similar properties to Lucene analyzer but the blog posts don't say a word about Lucene; instead they ...

Question 7

I am writing a query where I need to know if a column is of the "BLOB" type of column. According to this documentation 41 is the number for "BLOB" types of columns, in general. ...

Question 8

I have some necro-project using Informix Dynamic Server Version 7.31.UD1. I need to backup-restore database between servers. The thing is, the onload just silently exits and doesn't create a database, ...

Question 9

I have troubling issue where I want to only select the first 2 chunks of every dbspace created. query used: SELECT a.dbsnum, b.chknum, a.name, b.fname FROM sysdbspaces a, syschunks b where a.dbsnum = ...

Question 10

How is it possible to convert a float number of seconds to HH:MM:SS in Informix? I have a column that has a run duration of 1449.448520410. I want to convert this to a human-readable format. I have ...

Question 11

I have an Informix database. I want to take a snapshot, make some changes, then restore the database from that snapshot. (If Informix supported nested transactions, I would be using transactions.) ...

Question 12

I have a table that I am trying to pull a single return value on a select saying that either compressions on table is enabled or disabled by using a sum calculator for column value compressed must be ...

Question 13

I'm troubleshooting a "sudden" issue on our somewhat old Informix server (11.50.UC9GE). After years of running without issue (and connecting w/o issue), suddenly today we can't connect to the server ...

Question 14

I am trying to convert some PostgreSQL into Informix and factor out the WITH statements in the query below. I have been unable to locate a solution to factoring out multiple with statements. The ...

Question 15

My customer uses an IBM Informix environment to track production information. In the current SharePoint 2013 he was able to show those infos with this query: Select stillst_grund,sum(charge_bis-...

Stack Exchange Network

Questions tagged [informix]

Create initial Informix dbspace on a new server from script

Configuring Informix to access data on another server

Convert Column multiple rows to single row output sql

In Informix, is it possible to copy a database within the same server/host?

Rownum equivalent in Informix SQL?

Are the Informix and Lucene analyzers similar?

What are the various Informix column data types?

Informix onunload/onload between different arch

count duplicate records and select first 2

Convert seconds into HH:MM:SS

Informix onunload/onload to take a snapshot and then restore

case statement using characters for sum value

Informix JDBC login fails, local login succeeds

Informix v12 substitute for query using multiple with statements

IBM Informix - cast decimal to time format

Hot Network Questions