INFORMIX ESQL/C 2.10.06E for MS-DOS 6.22 or 5.0
Anyone know where I can get a copy of ESQL/C 2.10 which will work with INFORMIX-SQL 2.10.06E running on MS-DOS 5.0 or 6.22?.. I would also need to find Microsoft C compiler Version 6. ...
informix
Maintaining application/system accounts for database access.
(rephrased...) How do you manage 'application' database accounts that have to follow the same policy as regular login-capable user accounts. We have many processes in our system that run, unattended all the time, or part of scheduled jobs that need to access the database (Informix). These have been, up until now, nologin/noexpire acco...
ignore insert of rows that violate duplicate key index
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 the database to ignore those rows, and not insert them and continue inserting the other rows. The DB in question is Informix 11.5. Curre...
how do I get more info for 'invalid format' error with onpladm on Windows?
This is my first time trying to use Informix. I have around 160 tables to load, using pipe-delimited text files. We have an older series of batch files that a previous developer wrote to load Informix data, but they're not working with the new version of Informix (11.5) that I installed. I'm running it on a Windows 2003 server. I've mo...
Proper way of declaring cursor for huge number of updates
Hi, I need some suggestions as to whether my idea is ok or not. I have a situation where: I need to do updates to every row of a table. There is some logic involved in the updation. The logic is very simple, but it needs to be done for every row. There is a possiblity of every row getting updated. Currently, I'm thinking about writing...
Informix apostrophe SQL error
I get [Informix][Informix ODBC Driver][Informix]A syntax error has occurred when running the query below. When I remove the double apostrophes the query executes successfully. Everything I can find by Googling tells me I'm doing the right thing. Seven years ago I used Informix without this sort of problem so I think I've forgotten someth...
"FOR UPDATE" clause is throwing error in esql program
Hi, We are developing a migrate program. There are nearly 80 million records are there in DB. The code is as follows: static int mymigration(struct progargs *args) { exec sql begin declare section; const char *selectQuery; const char *updateQuery; long cur_start; long cur_end; long serial; long number; ch...
how to add line breaks in a query (informix)?
I need to do a query that updates text with line break, I tried using \n but it inserts "\n" literally. Example: update table set text = "first line\nsecond line" I want it to show that text as: "first line second line" and not as "first line\nsecond line". When I do this with .net it works, but not on a stored procedure Does an...
How to start with an R-tree index in IBM Informix
I have an assignment in which I need to build R-tree indexes on a table and query them. But I am not getting proper tutorial or guide which specifically deals with R-tree in IBM Informix and querying an R-tree. I tried to Google but without much success. Can anyone can provide me with a good startup? ...
Anyone have experience developing with ESQL/C for INFORMIX-SQL?
Does anyone have experience developing with ESQL/C for INFORMIX-SQL, as in calling C funcs within "Perform" screen generator and "ACE" report writer? I have ISQL without ESQL/C. I experimented compiling a perform screen, where in the instructions section I put "ON BEGINNING CALL userfunc() END" and although I don't have ESQL/C, the Perf...
String concatenation within INFORMIX-SQL "Perform" screens.
How can I concatenate two char columns within a perform screen? example: table sample col1 char(1), col2 char(1) . . after editadd of sample let label_3 = sample.col1 + sample.col2 .. this didn't work, I even tried using subscripts for the 2 cols but no dice! ...
Can IfxConnection and threading get along?
We have an application using the IBM Informix driver. Whenever we try to open connections in parallel, we start getting some really weird errors. This is the smallest reproduction code I could come up with: const int Count = 10; const string ConnectionString = "Host=the_host;Service=the_service;Server=the_server;Database=the_database;U...
SELECT only a certain set of rows at a time
I need to select data from one table and insert it into another table. Currently the SQL looks something like this: INSERT INTO A (x, y, z) SELECT x, y, z FROM B b WHERE ... However, the SELECT is huge, resulting in over 2 millions rows and we think it is taking up too much memory. Informix, the db in this case, runs out o...
which sql consumes less memory
Yesterday I asked a question on how to re-write sql to do selects and inserts in batches. I needed to do this to try and consume less virtual memory, since I need to move millions of rows here. The object is to move rows from Table B into Table A. Here are the ways I can think of doing this: SQL #1) INSERT INTO A (x, y, z) SELEC...
How to reference the same parameter more than once in a Informix query?
I have a query which I am executing through ODBC on an Informix database. The query is being passed a Parameter (StartDate). I need to use the year of the StartDate numerous times get the data from the correct fields. When I use the query as listed below, it thinks there are 9 parameters. Therefore, I know this syntax is incorrect, h...
How to improve Java performance on Informix for Windows
I have problem with performance of Java UDR functions on Informix on Windows. On this server I already have some functions in C and SPL. I chose one function to write it in those 3 languages and I measured performance of this function on test table. Function calculates some kind of checksum so it does not use any db libraries etc. only ...
Migrating schema and SP from informix to mysql
We need to redo a database in MySQL that has been already done on Informix, is there a way to migrate not only the schema, but the stored procedures as well? Thanks. We have a client whom we built a web application that uses an Informix database. Now the client wants to be able to implement the same software but on multiple closed netw...
Users Login Info in INFORMIX-SQL
INFORMIX-SQL 4.1 - There's this ASCII UNIX file called "passwd" in /usr/informix/etc which holds all the user id's and encrypted passwords to log into ISQL. Is there a system catalog table which holds the logged in users? I see a SYSUSERS.DAT file but when I queried it, it didnt show my login id, date or time. ...
IBM Informix using spatial datablade
I need to use IBM Informix for my project where I have point coordinates and I need to find which points are present in query rectangular region. Informix has spatial datablade module with ST_POINT and ST_POLYGON data objects. I know how to create, insert and create r-tree index on tables with such objects. But problem is how to do a S...
Convert varchar to numeric in Informix
I have problem while converting varchar type to Int type in Informix. Actually I don't know if the value is really varchar or not which I want to convert to INT. It's a sandbox system. As Example: I am trying to run this kind of Select telnumber from numbers n where Cast(n.telnumber AS INT) between 1234 and 9999 I got this error:...