Tags » Informix

TREETIP: tcVISION now supports IAM Files – a solution of Innovation Data Processing

“The Innovation Access Method (IAM) is a transparent alternative to VSAM KSDS, ESDS, and (as a cost option) to AIX and RRDS files. The savings achieved over VSAM can vary, but IAM typically uses 40-80% less I/Os, 20-70% less CPU and 30-70% less DASD. 251 more words

Informix write listener - Rest API setup issues

For my talk at IIUG 2017 I was working with the wire listener on Informix.

When setting up a wire listener for the REST API I found some Informix packaging issues and issues with the DeveloperWorks article. 276 more words


IBM and HCL Strategic Partnership to jointly develop and market IBM Informix

by Dan Hernandez, VP Offering Management Analytics


I have some very exciting news to share with you today. I am very pleased to announce that IBM and HCL are entering a strategic partnership to jointly develop and market the IBM Informix family of products. 145 more words


What are various Informix operating modes?

The IBM Informix database server has 4 principal modes of operation:

  1. Online
  2. Single User/Administrative
  3. Quiescent/Maintenance
  4. Offline

OFFLINE  <==>  Quiescent  <==>  Single User <==> ONLINE

1. Online: 158 more words

Informix DBA(Interview Questions)

Just one month remains until the IIUG Event in Raleigh, NC. Register today!

by Rajesh Govindan, Portfolio Marketing Manager, IBM Informix

If you’ve got the time, we’ve got the space! But you’re going to want to register now — before the conference is 100% booked. 277 more words


IBM Data Server Provider (DB2) .Net Tips – Series 1

I’ve been working with IBM Informix lately and from my previous post, I’ve mentioned a couple of ways to work with Informix. Now that I’ve settled with strictly using DB2 (see my previous post on this), my colleagues and I have been developing abstractions to work with Informix via Entity Framework and/or DB2 SDK (IBM’s version). 1,000 more words

Notes in Informix

#in squirrel you can disable the colon character of parameters inline request by unloading the plugin sqlparam

#enter in interactive mode only commands
#ctrl+d for closing the program
dbaccess - -

#command to connect a DB inside to dbaccess - -:
database your_db;

#import only the schemas of the database
dbschema -t all -d sicobf3 -nw -q -ns dboutput3.txt

#schema data model of sysmaster
#see http://www.informix.com.ua/articles/sysmast/sysmast.htm

#list databases
select * from sysmaster:sysdatabases;

#create database in informix with support of autocommit in jdbc
#see https://bugs.eclipse.org/bugs/show_bug.cgi?id=218190
#see https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0368.htm
#see https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0369.htm
create database sicobf3 with log;

#see http://stackoverflow.com/questions/36165976/invalid-default-value-for-column-variable-ed-fec-sol
#Below are to know how was set the variables from your client, especially the date format
SELECT      envses_name, envses_value
FROM        sysmaster:sysenvses
WHERE       envses_name IN (
            AND envses_sid = DBINFO('sessionid')
ORDER BY    DECODE(envses_name,
                'DBDATE',           0,
                'GL_DATE',          1,
                'CLIENT_LOCALE',    2
SELECT * FROM        sysmaster:sysenvses WHERE   envses_sid = DBINFO('sessionid');
SELECT  env_name, env_value FROM    sysmaster:sysenv WHERE   env_name = 'DBDATE';
SELECT  CURRENT::DATE FROM    sysmaster:sysdual;
SELECT  TODAY FROM    sysmaster:sysdual;

#set properties in the jdbc driver of informix, in this case GL_DATE since DBDATE is deprecated
#see https://groups.google.com/forum/#!msg/comp.databases.informix/iHH3LGuiP1o/AA5czvKNYSAJ
#see https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_263.htm
#see https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_266.htm
#or with DBDATE=MDY4

#to know the current database used
select * from sysmaster:syssqlcurses

#to know the version of the DB
SELECT  DBINFO('version','full') FROM    sysmaster:sysdual;

#To know the schema of a table in informix:
dbschema -d DB_sicobf3 -t Table_t5641rstockestab