I am a new to Informix and as part of my testing activity I am in need of creating 2TB+ size data for Oracle, Informix & Sybase. Is there a database-neutral way of doing this? I am looking for any freeware or open source tools as well; I can find a few for Oracle but hardly any for Informix & Sybase. ...
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 into sometable values ('NextRecordI...
I'm just found cmake and I want to use it to create make files for a little project that uses the esql compiler. ...
How can I get the execution plan for a query in Informix? I need something similar to what I get in Oracle with explain plan or in SQL Server with set showplan_all on. I'm connecting from a .NET application (using IBM.Data.Informix), if that's important. Thanks! ...
So we have an AIX (ugh) server that runs an ERP system. This system's built in reports suck so I am of course tasked with building the reports we need. I've got many reports I run and most of course are for specific dates, etc. The coding is done in C# running in ASP.net on a Windows 2003 Standard Server box. It uses the Informix CSDK t...
Hi, Imagine I have a db table of Customers containing {id,username,firstname,lastname} If I want to find how many instances there are of different firstnames I can do: select firstname,count(*) from Customers group by 2 order by 1; username | count(*) =================== bob | 1 jeff | 2 adam | 5 H...
With Informix I can grant select on a table like; grant select on 'dba'.mytable to someuser as dba; How can I perform this on all tables in the database? ...
We have an old Windows 2000 server running SQL Server 2000 Standard Edition, SP3. This has a linked server setup to connect to an Informix DB via an ODBC connection. For most of the year, running OPENQUERY against the linked server works fine without any problem. However, every few months this linked server fails, and does not work again...
I don't think this configuration is supported (maybe gcc isn't supported at all) because the esql script uses xlc options only. But I want to know if other people are using this configuration gcc and informix 64 bits in AIX. ...
I am using Informix DB and I need to take a backup of create table queries of each table present in the DB.I don't need to clone the database because my need is only the create scripts.I am using WinSql to access the DB.Any help would suffice.TIA ...
How, in Informix IDS 11.5, do I determine in which SmartLob space does a BLOB reside? So really it's two questions: How can I get something like the dbschema command to produce the PUT clause. How can I find from which sblobspace did a particular SmartLOB come from? ...
Imagine I have a db table of Customers containing {id,username,firstname,lastname} If I want to find how many instances there are of different firstnames I can do: select firstname, count(*) from Customers group by 2 order by 1; firstname | count(*) ==================== bob | 1 jeff | 2 adam | 5 ...
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 shows table.field for all tables and all fields? LEFFLER!!!! HELP!!!! ...
While trying to connect to the database I get a strange error: DatabaseError: SQLCODE -1829 in CONNECT: ì¦à : Cannot open file 'os.iem' ì¦à : Cannot open file 'os.iem' I can confirm that the file is present in $INFORMIXDIR/msg/en_us/0333/ directory. The environment variables INFORMIXDIR, INFORMIXSERVER and ONCONFIG are set corre...
I have some images in an informix database, as a binary blob field (jpg), how can i write the images onto disk with an SQL? ...
Hi, Can any one help me in increasing the performance of below sql. Database using is informix SELECT informix.set_reason_codes.description as reason_code, count(*) as number_of_calls FROM informix.contact_history, informix.set_reason_codes, informix.customers WHERE (informix.contact_history.reason_code = informix.set_reason...
I would like to calculate some sort of hash or checksum value for a column value in Informix SQL. The problem: We need to anonymize personal information in test data, and would like to do so by hashing the relevant values, as in: UPDATE personal_data SET name=HASH(name), employee_no=HASH(employee_no) We want to use a hash, rather th...
I am accessing a database that I can't change and it has a column named valid defined. Anytime I try to access an attribute, I get this exception: valid? is defined by ActiveRecord (ActiveRecord::DangerousAttributeError) The exception makes sense, but since I'm not able to change the database, how can I get around this error? I tried ...
A while back I was looking for a way to insert values into a text field through isql and eventually found some load command that worked out for me. It doesn't work when I try to execute it from Perl. I get a syntax error. I have tried two separate methods and both are not working so far. I have the SQL statement variable print out at...
I need to select some values from an Informix database via Oracle ODBC. One of the columns is a timestamp, and when I just select it all I see in SQL*Plus is the date value. How do I get the time as well? ...