Rating Thread / Thread Starter	Last Post	Replies	Views
Re: Default Select Order Vijay wrote: As per SQL definitions: if you don't have "order by" in your select rows can be returned in any order and not neccessarily in the same... Michael Krzepkowski	12-17-2003 11:53 PM Michael Krzepkowski	0	29
Need help on the correct SQL syntax Hi all, What is the valid delete command in Informix that can referring to 2 tables? E.g. delete from table1 where table1.field1... miyaki	12-17-2003 02:06 PM Xuanhai Carmichael	1	34
FW: Log errors - network ? I am getting the following errors running my logical logs (continuous backup). We've been having A LOT of network problems lately, and my question... Dirk Moolman	12-17-2003 10:06 AM Dirk Moolman	0	50
Anyone seen this behaviour before ? I have a HDR pair which were working fine up until lately. The primary runs in a veritas clustered environment - secondary is... mad_villan	12-17-2003 12:36 AM mad_villan	2	43
new server Current: Sun Enterprise 6000 dedicated database server, solaris 8 - patch level current; hardware mirroring; 4 attached arrays; various mixture of... Campbell, John \(CONS FIN, MCS\)	12-16-2003 06:25 PM Art S. Kagel	1	55
Re: problem with informix cursor On Fri, 16 May 2003 09:48:49 -0400, ephesus wrote: Version? Platform? Front-end tool? Troublesome SQL? Come on, you have to give us SOMETHING to... Art S. Kagel	12-16-2003 06:23 PM Art S. Kagel	0	34
Needs Help, Error 243 / 111 by creating tmp Table Hello, I have following problem, sometimes the following Sql Command fails: SELECT distinct b.pabx_id, b.dev_cl_gr,b.dev_class,b., a.switch FROM... Thorsten Geelhaar	12-16-2003 10:20 AM John Carlson	3	83
Need the experts , Informix freeze or down Hi gurus, I need urgent help ,informix freeze for some reason and no command can be run except onstat command. I cannot stop the service and restart... shay	12-16-2003 09:58 AM Andy Kent	3	33
update, concatenation strings create table test ( test1 char(30), test2 char(30) ); insert into test values ("aaa","bbb"); insert into test values ("bbb","bbb"); Mitja Udovc	12-16-2003 08:43 AM June C. Hunt	1	48
Very slow archives - the Very Old Page bug perhaps? ( 1 2 ) Our ontape archives have suddenly gone from about 3 hours to 40+ hours. Often they fail or we end up having to abort them because they chomp up all... Andy Kent	12-16-2003 04:52 AM Andy Kent	11	101
Re: CREATE DATABASE permission.. IT'S OK!! Hi David. This parameter really worked. Thanks. Sadi ----- Original Message ----- From: "Link, David A." <DALink (AT) west (DOT) com> To: "Sadi... Sadi Gürsoy	12-16-2003 04:22 AM Hamid HABZI	1	61
Disappointing test results from 9.40 ( 1 2 ) HP-UX 11.11 I'm doing some benchmark testing on a critical process to our client - alter fragment init ... in dbspace of medium and large tables. ... Neil Truby	12-16-2003 04:12 AM Neil Truby	10	77
Informix Freeze or Down Hi All, I need the group help on this issue (Informix support doesn't seems to help). OS is window2000 RAM 3GB 2 CPU Informix 7.31 TD3.1 For some... shay	12-16-2003 03:37 AM shay	2	63
Logical log backup on XPS Hi All, We have XPS 8.40 installed on HP UX 11i. Ther server was initialised and we were trying to load data into a table . Now the server is in... Srinivas Sreekumar	12-15-2003 11:03 PM Srinivas Sreekumar	2	47
Installing IDS 7.30 on SCO Open Sever 5.0.7 Hi, I'm trying to migrate our Informix Dynamic Server 7.30 UC2 system from SCO Open Server 5.0.4 to a system running Open Server 5.0.7. Every time I... Karim Kamara	12-15-2003 06:59 PM Scott Burns	1	81
A Big cursor problem in SPL. Anybody help? ( 1 2 ) I need to open a cursor depending on a condition: if a=1 then open cursor for SELECT1.... if a=2 then open cursor for SELECT2....(same columns but... Paulo Cooker	12-15-2003 06:21 PM Paulo Cooker	14	85
Informix ODBC Driver Memory Allocation Failure Hello all, We have been running one Windows service written in dotNet. Some times the service was logging the following error in the "application... Chavan Koya	12-15-2003 11:06 AM Chavan Koya	0	59
Dbimport error 625 Hi guru I did a "dbimport" of a database, previously exporting from an IDS 9.30 OS WINXP, in an IDS 9.40 always on OS WINXP, but I obtain the... Alessandro	12-15-2003 10:44 AM Alessandro	2	69
CREATE DATABASE permission AIX 5.2 IDS 9.40.FC1 Hi, How do i revoke "create database" permisson from an informix user? The users have some permissions on some databases and... Sadi Gürsoy	12-15-2003 09:19 AM Link, David A.	3	47
Restrict create database & Space Quota on dbs Hi, How can i restrict a user from creating a database and how can i fixe the maximum amount af space used by an object (Database, Table, index... Hamid HABZI	12-15-2003 08:48 AM June C. Hunt	2	45
What do session statuses mean? What does a status of "cond wait(await_MC1)" in onstat -g ses mean? Thanks Andy Andy Kent	12-15-2003 08:07 AM Bill Dare	1	61
alter table test modify (col text) (from column type clob) needs cast? hi there if i try to change the type from clob to text or blob to byte i get the error listed below. how can i create and use this CAST i apparently... Hoyte Swager	12-13-2003 11:47 AM Hoyte Swager	0	83
Error in linking the ec program ld: 0711-317 ERROR: Hi Guys, I am getting this error while compiling the ec code using gcc thru make file.Could any of you help out with this ? The error is as... Amit Sawhney	12-13-2003 06:55 AM Frank Langelage	1	98
Perl DBD::Informix and IDS9.40 SPL display labels Hi,All I'm using: 9.40.UC1E1 on RedHat 7.3, perl5.8.0, DBD::Informix 2003.04. SPL function: create function test1(a integer) returning integer as... Sergey Leschenko	12-13-2003 12:58 AM Jonathan Leffler	1	45
Strip Size, AIX, IBM FastT Storage Questions We are in the process of bringing online a new Informix installation (current plan is 9.4 on AIX 5.1L.) I wanted to see if anyone had any input on... PEEK, CHRISTOPHER	12-12-2003 03:24 PM Alexey Sonkin	3	44
ctype_b hi, i'm looking for csdk 2.81.UC3 to use on linux RH9 because of the ctype compatibility problem. does anyone know where i can get it (beta release... __toto	12-12-2003 12:30 PM Srinivas Kolli	2	66
Missing functions?? I need a hand... I'm tying to find: chr(13) and result char code 13 (enter), or another way to concatenate control characters instr to find the first occurence of a... Paulo Cooker	12-12-2003 08:16 AM Paulo Cooker	0	37
IDS 7.3 and RedHat ES All, Anyone have any luck with the RedHat Enterprise System (RHES 2.1 or 3.0) and installing/running the IDS 7.3 Engine, SQLRT, and CLIENTSDK? RHES... Kelly Wood	12-11-2003 07:38 PM Ronald Cole	9	69
Prbolem of undefined symbol in 9.40UC1 Hello, I got the following error when I port my ec code from 9.21 UC6 to 9.40UC1: ld: 0711-317 ERROR: Undefined symbol: ._class Compile with... hantao	12-11-2003 02:38 PM hantao	0	61
What is DS memory used for? Can someone tell me exactly what DS memory is actually used for? Yes, I know it's for DS queries, but what does it hold? Session blocks? Execution... Andy Kent	12-11-2003 08:44 AM Andy Kent	0	38
Re: SYSTEM command in stored procedures [2338] Hi Alain, I have the Solaris platform as main system but i debug and test our database and softwares on NT platform as well. I managed to get the... Sadi Gürsoy	12-11-2003 08:37 AM Sadi Gürsoy	0	54
Functions in Informix SPL Hi, Where can I find information (syntax) about functions that I can use in SPL? Like, SUBSTR, COALESCE, CURRENTDATE, ROUND, ... Thanks a lot Paulo Cooker	12-11-2003 08:16 AM Paulo Cooker	5	65
BUFFERS max confusion I'm a little confused about the maximum BUFFERS parameter max is in the onconf file. We are running IDS 7.31.UD6W6 on HPUX 11.11. My manual I got... John David Adamski	12-11-2003 04:24 AM Andy Kent	1	39
Arabic Data Hi Every1. my client has got a data in Informix Online 5.x with r4gl used for the front end. the character based screen display in Arabic. The data... ramanu@vsnl.com	12-11-2003 02:32 AM ramanu@vsnl.com	2	64
ontape restore from 2 different devices We are currently using IDS 7.31 and ontape. Current box RS6000 F80 w/ internal 20/40 tape drive for full & level 0 backup & external 20/40 tape... Carlie	12-10-2003 06:14 PM Paul Watson	7	47
Examine data in temporary tables Good morning/evening, IDS 7.30 or 9.40. The command "onstat -g sql <sessid>" indicates the list of "User-created Temp tables", with their partnum,... Ph. Chantry	12-10-2003 04:02 PM Richard Thomas	2	51
C prg issue in Aix This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be... hiten.bhawsar	12-10-2003 02:05 PM Jonathan Leffler	1	99
Convert Char-->integer or Integer-->char Hello, I am a new bee with informix and I want to convert an integer to char or a char to integer. Informix 7+ CSDK + PHP My problems is the... victor	12-10-2003 01:22 PM Plausible Indirection	8	67
IDS Version 9.40.UC3 Anyone have a lead on when it will be released? --EEM Everett E. Mills Systems Administrator/Programmer National Beef Packing Co., LLC. P. O. Box... Everett Mills	12-10-2003 12:03 PM Paul Watson	2	47
good GUI client Hello All! I'm looking for good GUI client (like TOAD for Oracle) to explore all objects (tables, procedures etc.) Is there any stuff for... Vadim theHook	12-10-2003 09:10 AM Jean Sagi	5	60
SMI and onstat -g stm Hi All, We are using IDS 9.30.FC2 on HP-UX. Can anyone point me how to get the same result as onstat -g stm using SMI ? Thanks Jia-Chiy JC Shiy	12-10-2003 01:52 AM JC Shiy	0	71
how to connect informix 5.x from delphi --0-979657118-1070953981=:23768 Content-Type: text/plain; charset=us-ascii how can i connect to informix 5.x from delphi and make queries from... hilal acar	12-09-2003 05:10 PM Petarian	1	53
Antwort: Informix OLTP Server Sizing I have a Sun V480, 2cpus, 4GB RAM an 200GB of Storage, Solaris 9, IDS 7.31FD5 and 600 concurrent Users. Works fine. But these users don't do much.... Thomas Mieslinger	12-09-2003 02:33 PM Thomas Mieslinger	0	33
Informix OLTP Server Sizing Hi, I would like to know If there is any Informix reccommendations for IDS on Unix Server. Mainly for OLTP environment with hundreds of users, IDS... mak	12-09-2003 12:44 PM mak	0	37
745 error on insert trigger I am having trouble with a trigger. What I am trying to accomplish is to maintain a table in 2 databases on separate machines. (No, ER is not a... Dale Gilbert	12-09-2003 11:44 AM Obnoxio The Clown	1	52
Perl DBD::Informix and IDS 64-bit Hello, I'm curious: does anyone have any experience using Perl DBD::Informix with 64-bit IDS? If so, how well does it work (if it works at all)? ... Thomas J. Girsch	12-09-2003 11:30 AM Thomas Mieslinger	3	56
getting the next row along ordered by an indexed field oid is an opaque type with comparison and equality functions, the oid_index is a successfully created ascending index on oid. with 10,000 records,... Andrew Hardy	12-09-2003 10:34 AM Andrew Hardy	0	49
Event Management and Alerting Solution for ERP These guys offer a really cool product for adding Event Management, BAM, BPM and Alerting solutions across BAAN and other ERP... Peter Roberts	12-09-2003 10:24 AM Colin Bull	4	40
Cpying database data from IDS 7.31 (Sun OS 2.6) to IDS 9.4 Linux (RH7.3) Hi, I have installed a Linux box with IDS 9.4 but all the data I need is in the IDS 7.31. What is the best way to copy the data between those two... Efim Dimenstein	12-09-2003 09:21 AM John Carlson	2	44
Fw: Red Hat vs SuSE [720] All the linux people with internals experience that I know recommend SuSE. They tell me that SMP support is better and its generally better... Mark Denham	12-09-2003 09:10 AM Mark Denham	0	35

Page 135 of 158

135

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off