Hello everybody, I have one table in which varchar is declared as varchar(100,1) whats the significance of 1 in the above varchar(). any...

Prateek Jain

08-22-2006 04:32 PM
bozon

Folks - I've been hearing mixed(-up) stories about the usage (or non-usage) of the config parameter DRAUTO. Anyone have good OR bad stories,...

mark.scranton@gmail.com

08-22-2006 03:20 PM

Hi, i've made a delete of 43 rows without using the roolback, is there any chance to undo or recover the deleted rows?? Thx

Guedes

08-22-2006 10:03 AM
Art S. Kagel

Hello Friends, We are scoping out a project to replace a component of an old school, legacy application written in ESQL with a .NET service based...

Tam OShanter

08-22-2006 08:59 AM
Joe S

folks, I have a stored procedure that all it does is a join lookup read: CREATE PROCEDURE my_procedure ( in_parameter VARCHAR(25,0) )...

Jlukar

08-22-2006 05:52 AM
Radhika Gadde

Anyone interested in a job in Concord, NH? Here's a position my group are looking to fill. You can apply online through www.lfg.com. Anyone...

mark@vuntec.com

08-21-2006 08:52 PM
Mark

I haven't checked the manuals but I don't believe we can do this :) Just done a series of big DB changes and needed to recompile all the SPL code. I...

Paul Watson

08-21-2006 06:11 PM
Paul Watson

Hi, I have SQL: In original application we have simple SQL: SELECT field1, field2, field3, field4, field5 from table where field1=22 AND field2 IS...

JPS

08-21-2006 12:43 PM
bozon

On a brighter note....I have been very busy with Informix consulting assignments since about mid-June....week after week, back to back. Sites ranging...

mark.scranton@gmail.com

08-21-2006 11:46 AM
mark.scranton@gmail.com

Gang - I'm just curious.....any "onperf" fans? I am onsite using it for query analysis (the xtree part that is), and would hope we don't ever get...

mark.scranton@gmail.com

08-21-2006 11:00 AM
Art S. Kagel

We have a query that runs kind of slow, which is exacerbated by the fact that it has to run millions of times. It's searching on partial firstname...

Floyd Wellershaus

08-21-2006 10:57 AM
Art S. Kagel

I think I'm going crazy. I changed the SHMVIRTSIZE, LOCKS AND BUFFERS to take advantage of some new memory. Today, after reboot, I get these numbers...

Floyd Wellershaus

08-21-2006 09:19 AM
Eric Rowell

Hi all, I'm configuring Onbar with ISM and IDS 9.4, platform is RedHat Linux AS 3; one of the steps requires to insert some values...

Alessandro Vercelli

08-21-2006 06:03 AM
Alessandro Vercelli

Did you do a dbschema -d <database> -t <table> -ss I think the ss is important without it you get simple schema without the storage options. It...

bozon

08-18-2006 04:59 PM
Andreas Legner

Hello, 3 weeks ago, i posted a message on this forum asking help to tune my ids after upgrading to a new server. At first it seemed that by only...

F. LACROIX

08-18-2006 01:17 PM
Robert Seifert

Hello All, Just a quick question for you to ponder. Is it possible to include random dbscpaces in the DBSPACETEMP parameter with the onconfig file...

howie_lfc@hotmail.com

08-18-2006 10:41 AM
Simmons, Keith

Is there a way in ACE report writer to have a value go into the "prompt for" from a value entered into a Perform screen? I'm using ISQL 7.32. Rather...

Chad

08-18-2006 10:06 AM
Doug Lawry

One of customers wants to use SAN replication between remote sites for DR purposes. As recently discussed, and explained at length and in detail...

Neil Truby

08-17-2006 08:55 PM
Neil Truby

I'm looking for the best way to do version detection for IDS. I'd like to get the entire version (to the level of 7.31.xD9 for example). Best would...

Naraht

08-17-2006 03:43 PM
Andreas Legner

We have an application (web) that either was compiled with a 4gl tool completely or some part of it. I am not sure about that. The company who...

Gentian Hila

08-17-2006 11:36 AM
Gentian Hila

On the order table (IDS 9.40) I had a record locked for quite a while. I could not even read it. (Could not fetch row error appeared...

Gentian Hila

08-17-2006 11:32 AM
Gentian Hila

Hi All, Many years ago, Madison Pruet you wrote a very useful utility that shows all processes on the system and then determines which shared memory...

hariog@yahoo.com

08-17-2006 09:17 AM
Madison Pruet

The snippet of example code below os how I'm setting up a select with a where clause. I don't want to have a loop to get all the rows and I read...

kjuliff (AT) gmail (DOT) com

08-17-2006 04:54 AM
Sheshnarayan Agrawal

OK I've never seen this before, it's a prod server running Solaris 2.8 and 9.21 (yes I know it's old), it's been live for 5 years and has probably...

Paul Watson

08-16-2006 05:37 PM
Paul Watson

Informix User Forum 2006 A Two-Day User Group Technical Conference December 8-9, 2006 Washington DC, USA The Washington Area Informix User...

Donovan, Warren J. [RA]

08-16-2006 12:43 PM
Donovan, Warren J. [RA]

Hi! How to convert this condition (Informix) to MS SQL? account <> '215' account is in the table as char Thanks in advance, Max

maxskalski@gmail.com

08-16-2006 10:15 AM
bozon

Hi All, HP-UX B.11.11.11 IDS 9.40.FC4 We have got SAN setup which has got all chunks (raw devices) etc. etc. A process runs from cron which takes a...

AT

08-16-2006 08:03 AM
Neil Truby

cast(<decimal> to string) VS. substring(<decimal> from 1) which is more expensive? can test it, but wanted opinions of the crowd first....thoughts?...

mark.scranton@gmail.com

08-15-2006 04:21 PM
Paul Watson

We are getting the 408 error about twice a month while running a program while doing a fetch cursor. Informix support really has no answers and...

Floyd Wellershaus

08-15-2006 02:40 PM
malcolm weallans

Guru's, I am trying to get onload to work on a very old linux box running RH7.1 & Informix 9.21 (I know it $%^& - I will be upgrading it in the...

Will Secrest

08-15-2006 09:59 AM
Art S. Kagel

Why would this (converting doc_id from type serial to type integer): alter table docs modify doc_id integer not null constraint doc_nn1; cause...

DCP

08-15-2006 05:21 AM
scottishpoet

Hi, While trying to run a 4gl debugger on 4gl program along with c function below error comes ld: Unable to load shared library...

Prateek Jain

08-15-2006 02:26 AM
Jonathan Leffler

Neil Truby wrote: The checkpoint and block of server is necessary as IDS currently relies on a checkpoint for a start of logical recovery or...

Model-Bosch, Tilman

08-14-2006 05:03 PM
Neil Truby

Business Process Management(BPM) Tutorial, Workflow Business Process Management or BPM,is the practice of improving the efficiency and effectiveness...

management.business@gmail.com

08-14-2006 12:21 PM
management.business@gmail.com

Hi everybody With 4gl debugger this retint function is giving unsatisified symbol erro cc: "fgiusr.c", 42: 604: , line : warning : Pointers are...

Prateek Jain

08-14-2006 08:16 AM
Prateek Jain

I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested...

Yunyao (Frank) Qu

08-14-2006 03:50 AM
Jonathan Leffler

Hi all, any known problems or experiences with: SAP R3 4.6c SUSE Linux Enterprise 8 SP 4 IDS 9.4 uc8 ?? Thanks in advance for your advises.

Heinz Weitkamp

08-14-2006 03:10 AM
Christian Knappke

Hi, Does any one know if AGS (Server Studio) still offering 20% discount on thier products, specially SSJE & Sentinel Application Server (...

John

08-13-2006 08:47 PM
John

encounter stated initialization error while using onpload for Informix 9.4. Sample scpirt i used...

AT

08-12-2006 04:16 AM
david@smooth1.co.uk

I've got a question for the user community. Checkpoints are a real pain because there is a period of time in which user threads are going to be...

Madison Pruet

08-12-2006 04:14 AM
david@smooth1.co.uk

Any idea why we can't get an oncheck -cc on our big database ? We have 5 instances on this box, one of them is a terabyte, with about 80,000...

Floyd Wellershaus

08-12-2006 04:07 AM
david@smooth1.co.uk

Any idea why a query that does a join of a table on itself, doing a count and a group by, would cause the cpu usage to go drastically up, almost...

Floyd Wellershaus

08-11-2006 05:48 PM
Floyd Wellershaus

Solaris 9 IDS 9.40.FC8 A developer ran an updare on a table with 152M rows as follows: begin work; lock table in exclusive mode; update <table> set...

Colin Dawson

08-11-2006 05:09 PM
david@smooth1.co.uk

Hello - i need your brain... Is there a function that select a column from pos a until max (length of the column) ? I need something like...

Matthias

08-11-2006 12:54 PM
Art S. Kagel

We have a need to ship a level-0 ontape backup that will contain sensitive data. How secure is the data when backed up using ontape? Could a...

kxk0912

08-11-2006 12:51 PM
bozon

malcolm weallans said: Yeah, go on, Neil! -- Bye now, Obnoxio "... no bill is required as no value was provided."

GM

08-11-2006 11:55 AM
DA Morgan

We just moved to 9.40.UC8 from 9.40.UC5 and can no longer run dostats on any database. It always bombs just as it starts to update the stored...

Douglas Palmer

08-11-2006 11:21 AM
Art S. Kagel

Query to find index levels. set isolation to dirty read; select tabname, idxname, levels from sysindexes, systables where sysindexes.tabid =...

Roy Mercer

08-11-2006 10:39 AM
Roy Mercer

I'm kinda dumb about shared file usage and would like to have some idea what folks are using. Appreciate any feedback/comments/etc...

Madison Pruet

08-11-2006 08:17 AM
bozon

Hi all, We had an OS upgrade from AIX 5.1 -> AIX 5.3 yesterday and now our 4GL makefiles are dying. We cannot figure out what to fix though. ...

AT

08-10-2006 06:51 PM
Art S. Kagel