Questions tagged [informix]

1

votes
1

answer
38

Views

How to know what causes constraint failure during inserting enrties to a table using a DAT file?

I'm inserting multiple entries to a table using a DAT file. How will I know what records are causing constraint failures (eg. duplicate constraint)? I'm using informix dbaccess to load the entries. Here is a sample code of how I load it: load from 'table.dat' insert into table ( col1, col2, col3 );...
ligero50
1

votes
0

answer
13

Views

Confusing install error with ifxnjs in Node 10

Running a project's npm install on the official node:10 docker image quits with a confusing build error. I can provide other details, but I don't know what's relevant. ../src/odbc.cpp: In static member function 'static v8::Local ODBC::GetSQLError(SQLSMALLINT, SQLHANDLE, char*)': ../src/odbc.cpp:1184...
Reid
1

votes
0

answer
130

Views

Informix. How to insert data in blob field

I have the Informix database and I have to create the one more table that contents a field for the byte array data storing. Which data type I need to use for these goals in db. Also I tried to insert test record, but unsuccessful.
user3525444
1

votes
0

answer
1.3k

Views

2 Hikari CPs with different datasource configurations?

Has anyone successfully configured two hikari connection pools with different datasources in a spring boot application? How do I do it using application.properties?
ramkris
1

votes
0

answer
196

Views

Informix - Insert result of dbinfo('sqlca.sqlerrd1') into a table

I want to insert multiple records into a table with a SERIAL column using a single statement if possible. I also need to know what values were generated by the inserts. My approach has been to try and store the result of dbinfo('sqlca.sqlerrd1') within a temporary table after each insert and then re...
Kenspeckle
1

votes
0

answer
413

Views

Connecting to Informix Connection Manager Using JDBC

I need some clarification on how (some) JDBC drivers connect to (Informix) Databases. We had the issue of 'connection refused' when trying to connect to Informix connection manager from a Java application via JDBC,although access was granted via firewall. When we consulted Informix Team,they told us...
selman
1

votes
2

answer
320

Views

Column with Null values from a query

I'm trying to translate a query from Informix to Oracle. In Informix this query SELECT a.base_imp, b.num_exp, c.tip_canon_unit, b.cod_tip_ben, b.dat_cr_ini, b.dat_cr_fi, b.cod_emb, b.nif_Abo_liq, 0 as usuari, '' as nom_usu, '' as acotacio FROM OUTER dpt_mant_can_reg_3 a, dpt_mant_canreg_2 b, OUTE...
1

votes
0

answer
68

Views

Get DatabaseException trying to run Liquibase generateChangeLog under informix

I try to run the command: ./liquibase --changeLogFile=./changelog.sql --defaultSchemaName=informix generateChangeLog with the liquibase properties file: driver: com.informix.jdbc.IfxDriver classpath: ifxjdbc.jar url: jdbc:informix-sqli://manitoba:9005/fair:INFORMIXSERVER=mf2 username:informix passwo...
Todd M. Roy
0

votes
0

answer
5

Views

Can a development team works without the complete source code in TortoiseSVN repo or Informix?

In my company, our boss told me that most of the development projects going on in-house do not have source codes. How can i verify this fact? Development team is using .net framework and Informix as programming languages. In fact, TortoiseSVN is used to manage versions of different projects using .n...
Wageesha De Alwis
1

votes
0

answer
103

Views

What is the value of hs_language for a codeset conversion from cp850 to utf8 for the Oracle gateway

I have setup an Oracle gateway connected to an Informix IDS database created with an utf8 codeset. In my dg4imfx file I have HS_LANGUAGE=AMERICAN_AMERICA.WE8MSWIN1252. With HS_FDS_TRACE_LEVEL=DEBUG it seems that the Oracle client sends the value of e acute in the update statement with a cp850 codes...
jacques
1

votes
0

answer
1.5k

Views

Error: Could not do a physical-order read to fetch next row

We're facing an issue Error logged in application server log: 'Error: Could not do a physical-order read to fetch next row' We are using IBM informix 12.10 database. I've checked for the locks using onstat -k, it shows the intent exclusive lock. While we are doing an insert operation we are facing t...
Mukesh Tanuku
0

votes
0

answer
8

Views

How to execute an Informix ISQL query with a join

I have a table that already has values in it. The value I want to update is g_fuel_prft.billed_qty. I need to multiple a number from this table times a number from another table to get the value. So table names are inv_header which contains inv_header.rpt_factor and g_fuel_prft which contains g_fue...
Josh Emmick
1

votes
0

answer
110

Views

SQL tool to run an select query against multiple Informix servers?

I was using SQL Explorer to connect to an Informix server and get the output. Now I wish to run the same select query on multiple servers and get the results in each server. Could someone tell how its done with SQL explorer or if there is any other tool that will get the work done? Steps to do will...
Sundar
1

votes
0

answer
51

Views

How to drop db2 source connection and reopen it after the lookup is done in SSIS

I am getting a connection timeout error on one of the package that I am running into. Error: ' SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt' I have talke...
Seshu
1

votes
0

answer
272

Views

Creating an instance of Informix with UTF8 character set

Overview: I am trying to create an Informix instance with a character set of UTF8. Details: I understand that the default character set in informix when creating an instance is ISO Latin 1 (819). However, I am trying to convert my informix instances over to a UTF8 character set. I have created the...
michael.moyer
1

votes
0

answer
281

Views

Working with Execute SQL Task with ODBC source in SSIS

I have created an Execute SQL Task in which SQL Source Type is variable. The variable created are below. startTime: Provides current time endTime: Provides end time startTimeFormat: It is used to Format Date into required format to parse record startTimeFormat = (DT_WSTR, 4)DATEPART( 'yyyy', @[User:...
1

votes
0

answer
93

Views

Domino/Notes nhttp spikes on JDBC query to Informix

When connecting to an Informix server via a Bean (or Jar - I've tried both) in an NSF, the nhttp task it spiking and staying spiked. I do not get this problem if the code is run in Eclipse. Here is what I trigger from an XPage (via a managed bean): public void InformixSQLRS() { try { String url = 'j...
Brian M Moore
1

votes
0

answer
70

Views

Informix External Tables DROP

I am trying to unload data from an internal Infomix table into an external file using the following stored procedure. create table table_name( column1 int, column2 int ) insert into table_name(column1, column2) values(1, 1); insert into table_name(column1, column2) values(2, 2); insert into table_na...
nhesuru10
1

votes
0

answer
100

Views

Unable to import data from Informix non transactional database to HDFS

I'am trying to import a table from an Informix DB to HDFS. I'am using Cloudera distribution. I have made sure that the jars are correctly placed under /var/lib/sqoop folder on the host where I'am running the command. Below is the command and the error that I'am receiving. Sqoop Command: sqoop import...
Carol
1

votes
0

answer
222

Views

Identity in Informix

I'm using Informix and I want to create a table like this: CREATE TABLE increment_table ( id SERIAL NOT NULL, increment_column INTEGER IDENTITY (START WITH 2000, INCREMENT BY 1), name VARCHAR(255) NOT NULL, PRIMARY KEY (id) ); But when I run the statement, the result is a syntax error after the I...
Maggie Fortelli
1

votes
2

answer
120

Views

Decimal data not stored correctly in database by doctrine

Within one of my Symfony applications I encountered a strange behavior of the doctrine ODM. What I'm trying to do is simply saving decimal typed data to our Informix database. Whenever I try to do so everything behind the decimal separator is cropped. I tried several ways of assigning data such as:...
Torben
1

votes
0

answer
117

Views

Euro symbol not allowed

I have a problem with the euro (€) symbol insertion (or update, or load, or unload... anything) on informix. When I try to insert/update it just throws the error: 'SQL Error (-79716): System or internal error java.io.IOException: Code-set conversion function failed due to illegal sequence or inval...
taiko
1

votes
0

answer
37

Views

Delete file after load

I'm preparing a migration on an Informix database and I'm wondering if it's possible to delete a file after loading its information to a table. I mean, in theory it should be possible, since you can create it and read it. If possible I don't want it to remain there occupying needed space.
taiko
1

votes
0

answer
288

Views

Informix error on read: could not do a physical order read

Problem in nutshell executed data updates on couple of tables using dbeaver later reads from these tables started failing looks like the rows/pages in these tables are locked by the session where updates are done cant seem to get the locks released The details connected to an informix db using dbea...
Schu
1

votes
1

answer
186

Views

Execute informix content from file

I need to execute a script (Informix code) in a .sql file for migration purposes. The thing is, I want to load it from a function to be able to use the exception, therefore being able to do a rollback in case of an error. So, this is the code (still experimenting): DROP FUNCTION IF EXISTS 'informix'...
taiko
1

votes
1

answer
78

Views

informix DB with RobotFramework

I am trying to connect to informix DB from Robotframework script running on Mac. I have installed Robotframework-Database-Library[1.0.1] from http://franz-see.github.io/Robotframework-Database-Library/. tried to install Informix DB per https://wiki.python.org/moin/Informix. Ran into issue error: C...
MSQA
1

votes
0

answer
82

Views

Segmentation fault (core dumped) informix

im using node informix module which can be found here https://github.com/nukedzn/node-informix, below is my sample code, let opts = { database : '[email protected]', username : 'informix', password : 'xxxxxxx' } let informix = require('informix')(opts) let create_table = CREATE RAW TABLE IF NOT EXIS...
tony chen
1

votes
1

answer
26

Views

Enable Network Access to Informix v2.0

I have the pleasure of migrating data from an old IBM server running SCO unix and informix 2.0. The server/db work fine- the db however isn't available over tcp/ip. Trying to find out how to enable access to informix over ip. Any help/direction would be appreciated! Thanks!
helicopterjeff
1

votes
1

answer
81

Views

Date format is failing in php query using informix (SQL-based)

I'm running a service which (should) returns a json with a response from a sql query to fill a table. For debugging purposes i've added the resulting query string to the response to try it directly on the database and the query works in my database. Actually im getting the following errors when i r...
Mbotet
1

votes
2

answer
88

Views

Convert Informix file into pdf

Is it possible to convert file into PDF directly from Informix? Is there a command for it? If its not possible, then what should I do? For example: I want to convert file sm2026.4gl into PDF.
Fazri Badri
1

votes
0

answer
42

Views

How do I use --logLevel in Liquibase

It doesn't seem to matter what I set it to, I don't get anything that looks like additional information: liquibase --url='jdbc:informix-sqli:INFORMIXSERVER=informix01_tcp;SQLH_TYPE=FILE;SQLH_FILE=/opt/informix/informix/etc/sqlhosts;DATABASE=wallet' --logLevel=debug --logFile=./lb.log --classpath=/op...
Spokey Wheeler
1

votes
0

answer
52

Views

Access Informix using C# (Net Core 2.2) inside a Windows Docker container

I am working on migrating a NET Core application that accesses an Informix database so that it can run in a Windows Docker container. I have done a POC and when I run it on my local machine it works correctly. But when I want to run the same application inside a container, an exception is thrown: Ex...
jdelm
1

votes
0

answer
52

Views

Parallel processing large SQL table with Camel

I am trying to process about 7 million rows daily from an Informix table with Apache Camel but I can't figure out how it can be accomplished. My first attempt that was working with a very low set of data (about 50k rows) was using .split(body()).parallelProcessing() like so: from('quartz2://transacc...
jmhg92
1

votes
1

answer
26

Views

Is there a way that a crashed Informix Trigger can write out a log?

I have a trigger on a table in Informix 11.7 that writes to a log file all updates and deletes of a master data file. The log file has a self-generating sequence number on it to prove that no records have been deleted from the log. But if the trigger crashes for any reason, the sequence number doe...
Jon Rogers
1

votes
0

answer
28

Views

After importing about 130 informix databases I get error

I have the following problem: I have a default Informix database with many tables. I used the command dbexport to export that database to disk. After that, I imported about 130 databases from that export. I end up with the following error which I cannot solve: 212: Cannot add index. 136: ISAM error:...
Sebastian Mechler
1

votes
1

answer
399

Views

Setting PDQ inside an SPL - local scope?

In order to fine tune allocation of PDQ resources depending on the time of day that batch jobs run, we have a utility that sets PDQPRIORITY based on some day of week / hour of day rules, eg: PDQPRIORITY=$(throttle); export PDQPRIORITY However, this is fixed at the time the script starts, so long run...
RET
1

votes
1

answer
936

Views

How can I just get an IfxBlob from am Informix query in .net?

I can't seem to find a way to get just the locator object of a column under .Net. It seems that Informix is automatically converting the blob column to Byte[] and not leaving a way to change that behavior. IBM.Data.Informix.IfxConnection c = new IBM.Data.Informix.IfxConnection('...'); c.Open(); IBM...
hometoast
1

votes
2

answer
389

Views

Why Python informixdb package is throwing an error!

I have downloaded & installed the latest Python InformixDB package, but when I try to import it from the shell, I am getting the following error in the form of a Windows dialog box! 'A procedure entry point sqli_describe_input_stmt could not be located in the dynamic link isqlit09a.dll' Any ideas wh...
gath
1

votes
1

answer
1.1k

Views

Lost RPC connection to remote Agent error with Oracle connected to Informix

I am having a problem with a simple data importer / updater that takes data from Informix, inserts it into a table in Oracle, and updates a flag in the original table. The set up is this Pro*C program calls a PL/SQL procedure The procedure opens a cursor on Informix, loops through each row insert...
Greg Reynolds
1

votes
3

answer
6.6k

Views

informix check if table exists and then read the value

I have a table in informix (Version 11.50.UC4) called NextRecordID with just one column called id and it will have one row. What I want to do is copy this value into another table. But don't want my query to fail if this table does not exist. Something like if table NextRecordID exists then insert i...
sriharsha

View additional questions