What's the best way to do the semantic equivalent of the traditional sleep() system call from within an Informix SPL routine? In other words, simply "pause" for N seconds (or milliseconds or whatever, but seconds are fine). I'm looking for a solution that does not involve linking some new (perhaps written by me) C code or other library...
I am trying to insert into a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL-Engine of the day (MySQL, Oracle, SQLServer, Informix, DB2). I've been wondering if there is a silver-bullet syntax coming from an SQL S...
How can you find out what are the long running queries are on Informix database server? I have a query that is using up the CPU and want to find out what the query is. ...
The source database is quite large. The target database, doesn't grow automatically. They are on different machines. I'm coming from a MSSql, MySQl background and IDS11 seems overly complex (I am sure, with good reason) ...
We are trying to duplicate one of our informix database on a test server, but without Informix expertise in house we can only guess what we need to do. I am learning this stuff on the fly myself and nowhere near the expertise level needed to operate Informix efficiently or even inefficiently. Anyhow... We managed to copy the .dat and ....
i am using informix database, i want a query which you could also generate a row number along with the query Like select row_number(),firstName,lastName from students; row_number(),firstName,lastName 1 john mathew 2 ricky pointing 3 sachin tendulkar here firstName,lastName are from Database , where as row number is genera...
I have simple application that uses dbExpress to connect Informix database. If I compile it with TurboDelphi it works on both WinXP and Win2003. When I use new Deplhi 2009 my app works ok on WinXP but do not start on Win2003. No MessageBox with error, only info in EventLog: Faulting application inf_dbexpress_test.exe, version 0.0.0.0, fa...
Let me apologize in advance for the simplicity of this question (I heard Jeff's podcast and his concern that the quality of the questions will be "dumbed down"), but I'm stuck. I'm using AquaData to hit my Informix DB. There are quirky little nuances between MS SQL and Informix SQL. Anyway, I'm trying to do a simple nested expression ...
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 running jobs never get throttled up or ...
I get the Total length of columns in constraint is too long. erro from the following sql] Failed to execute: CREATE TABLE GTW_WORKFLOW_MON ( WORKFLOW_NAME VARCHAR(255) NOT NULL, WORKFLOW_LOADED NUMERIC(20) NOT NULL, ACTIVITY_NAME VARCHAR(255) NOT NULL, FLAGS INTEGER NOT NULL, MONITOR_NAME VARCHAR(255) NOT NULL, CLASSNAME VARCHAR(2...
I am trying to create a table with the following CREATE TABLE GTW_WORKFLOW_MON ( WORKFLOW_NAME VARCHAR(255) NOT NULL, WORKFLOW_LOADED NUMERIC(20) NOT NULL, ACTIVITY_NAME VARCHAR(255) NOT NULL, FLAGS INTEGER NOT NULL, MONITOR_NAME VARCHAR(255) NOT NULL, CLASSNAME VARCHAR(255) NOT NULL, STR0 VARCHAR(255), STR1 VARCHAR(255), STR2 VARCHAR(...
In Informix, how can I cast a char(8) type into a money type, so that I can compare it to another money type? ...
What's the best way to connect to a Informix database from .Net? I'm developing a client-server application based on a legacy Informix DB which used to be connected by JDBC. I need it, from the most important to the least: To be fast DB server changes not needed No ODBC and no dependencies, other than de .Net Framework 2.0 Thanks i...
What is Informix? I understand that it is a DBMS, how well it is comparing to SQL Server in terms of learning difficulties and syntax? How to start learning Informix? And may I know the "hello world" tutorial? ...
I'm looking for a way to transform a genuine string into it's hexadecimal value in SQL. I'm looking something that is Informix-friendly but I would obviously prefer something database-neutral Here is the select I am using now: SELECT SomeStringColumn from SomeTable Here is the select I would like to use: SELECT hex( SomeStringC...
I am looking into getting an Informix certification for developers. I am not sure how this thing is run. Should I sign up a course and only then take an exam or should I just prepare on my own and take online tests? Thanks ...
What's the most efficient way of getting the value of the SERIAL column after the INSERT statement? I.e. I am looking for a way to replicate @@IDENTITY or SCOPE_IDENTITY functionality of MS SQL ...
I'm using an Informix (Version 7.32) DB. On one operation I create a temp table with the ID of a regular table and a serial column (so I would have all the IDs from the regular table numbered continuously). But I want to insert the info from the regular table ordered by ID something like: CREATE TEMP TABLE tempTable (id serial, folio ...
I have an Informix SQL query which returns a set of rows. It was slightly modified for the new version of the site we've been working on and our QA noticed that the new version returns different results. After investigation we've found that the only difference between two queries were in the number of fields returned. FROM, WHERE and OR...
What SQL query shows me the tables & indexes used by a view on Informix? I know how to find the "original create statement" for a view in SYS_VIEWS, but that requires a human brain scanning/grokking that select. I believe I can find if the tables are indexed, once they have been identified. Background: I need to make certain that some...