Informix database development

How to insert a web link?

Hello Guest

• Login
• Register…
• Start blog

• Who, Where, When
• What can I do?
• What to Read?

• Polls
• Avatars
• Interests

• Cities and Countries
• Random blog
• Users search

• Search
• Games
• Tests
• QAIX

• Talxy Chat
• Horoscope
• Online

Зарегистрируйся!

QAIX > Informix database development

Go to page: « previous | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | next »

Recent blog posts:

I love you qaix.comyou`re so…
I love you qaix.com you`re so great! amazing site with only 3 normal users!!!!!!! with all my heart I…

ppc xD
ppc xD

TuneClone Audio Converter 1.03…
TuneClone Audio Converter is a very easy to use software that converts DRM protected iTunes M4P music…

So....I am good girl
Please write me some coments

hello
my name is emoSk8!

it's my brother and my band
It's Tommy: It's me and Tomas: It's Tokio Hotel:

Greetings to all!
Greetings to all. My name is Bill, me eighteen years, I live in Germany. I am a singer and I groups…

Hello

It's me

Hallo
I greet all of you in the diary. My name is Kate.14 years.I am from Russia(from Saint-Petersburg) .I can…

Forums:

tag feeds

• QAIX all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous

Discuss:

Ontape to disk - getting…
Hello all - this is my first post to this forum, so please excuse any faux pa's. We are currently…

I want a String from Position N…
Hello - i need your brain... Is there a function that select a column from pos a until max (length of…

Performance tuning: troubling…
Hello All, Here's some quick history... Recently the number of users has increased to over 500…

rshd: 0826-813 Permission is…
just running an input screen and doing some updating... got following error msg: rshd: 0826-813…

fragmentation
Hi: It wanted to know that type of fragmentation is but the optimal one: 1. Using line of commandos 2…

Recent forum topics:

Volunteers sought to help with…
The Oracle::OCI module provides access to the entire Oracle OCI interface. Every feature Oracle offers…

Re: Problem with DBD::Oracle…
"Martin Evans" <martin.evans@easysoft.com>, "dbi-users"…

neopets hacking
for all of ya'll who play neopet this is a great way to get rich quick okay see this link at the bottom…

Recent forum comments:

RE: Re: Problem with DBD::Oracle…
Wer lesen kann, ist klar im Vorteil: List-Post: <mailto:dbi-users@perl.org> List-Help…

RE: Problem with DBD::Oracle…
Hi Martin I found the bug (well actually an omission) and fixed it so now It will return the data you…

RE: perl dbi
On Thu, Jul 17, 2008 at 7:19 PM, gene golub <gene_golub@hotmail.com> wrote: Often the…

RE: neopets hacking
http://www.gopetition.com/online/20627.html

RE: hostme.co.uk
Hi there. I am trying to track down Hostme too. Had mega problems with them last year when both my…

RE: [PATCH]…
Torsten Foertsch wrote: + /* use the same error message as perl core's read() */ +…

RE: Problem with DBD::Oracle…
Martin Evans wrote: I guess this must be one of these circumstances. When you try to get a LOB…

RE: Problem with DBD::Oracle…
John Scoles wrote: Well that is what I'm after clarification on. The pod for ora_auto_lob says…

RE: Problem with DBD::Oracle…
Ouch nasty one Martin. But I think that DBD oracle is doing the correct thing here. I think when you…

RE: perl dbi
Hi Tim I read your post on…

Moderators:

Administrator
Protorioris

Friday, 7 July 2006


4ge to 4gl conversion Gary Cobden 14:34:52
	Hi I have a compiled Unix Informix 4ge file, but cannot find the Source 4gl file anywhere Is there a way to convert the compiled version to original source code? Thanks
		1 answer \| Add comment


9.40.FC8 and TRIGGERS Colin Dawson 12:05:46
	We upgraded a server from 7.31.FD7 to 9.40.FC8, the stored procedures were all dropped/recreated as advised by Informix however we seem to have come across another problem in that an update trigger that invokes 3 stored procedures was failing (hence my question yesterday about SP's). We dropped the trigger and recreated it and everything now works perfectly. Am I right to surmise that triggers are affected by a V9 migration in the same way stored procedures are? Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Windows Live™ Messenger has arrived. Click here to download it for free! http://imagine-msn.com/messenger/launch80/?locale=en-gb
		1 answer \| Add comment


Find a query using very CPU Cristiano Torres 01:50:15
	Hello, someone know How can I find query using very CPU the Informix ? Thanks Cristiano
		1 answer \| Add comment


Full Name help Dave 01:47:09
	So I'm importing a file into a temp table using DBLoad. This file though does not have the same format as the table it will move into. It needs to be "Last, First M" but within the file it is "First M Last". Not all people have middle initial as well, and if they don't have a middle initial there are 2 spaces in between. The file is just a list of names,address,phone,etc. My boss and I decided to load it into the temp table and figure out how to seperate the First, Last, and Middle initial into sepearate fields and then move it into the appropriate table using an Informer but we're not experienced with String parsing. Anyone got any tips? I can't imagine this is a new problem, but we've never dealt with it. Thanks much. David Bannister Jr. bannisd@gmail.com
		2 answer \| Add comment


Informix KAIO Error Guest 01:22:59
	Hi people !! I have a problem with Informix 7.31 with HP-UX 11i, during the KAIO initialization. Following the online.log Tue Jul 4 08:57:38 2006 08:57:38 Event alarms enabled. ALARMPROG = '/sgbd/informix/etc/log_full.sh' 08:57:44 DR: DRAUTO is 0 (Off) 08:57:44 Informix Dynamic Server Version 7.31.UC7 Software Serial Number AAC#J955102 08:57:44 Can't open /dev/async. KAIO disabled 08:57:44 Assert Failed: kaiothread() ERROR 08:57:44 Informix Dynamic Server Version 7.31.UC7 08:57:44 Who: Session(0, @, 0, 0) Thread(54, kaio, 0, 8) File: kaio.c Line: 2141 08:57:44 stack trace for pid 3757 written to /sgbd/informix/af.41e57b7 08:57:46 See Also: /sgbd/informix/af.41e57b7 08:57:46 kaio.c, line 2141, thread 54, proc id 3757, kaiothread() ERROR. 08:57:46 PANIC: Attempting to bring system down Anybody can help me, please !!! Tks, Eduardo
		7 answers \| Add comment

Thursday, 6 July 2006


receive error 951 when running ilogin Pgizard 20:05:48
	I recently get error 951: "Incorrect password or user informix is not known on the database server" when trying to connect to the database install on my laptop using ilogin or informix sql, it was working but I do not recall installing any new software (except windows update) Informix server 9.40 is installed on a Windows XP laptop. Informix connect 2.90 TC5 is installed. Setnet32 is configured server and host information. I can use dbaccess without any problem using different user. but when I try to connet using ilogin, informix sql or odbc connection i get the error 951 even using the informix user. I even try to reinstall informix server and connect and I still get the same error... Any ideas? Your help would be greatly appreciated!
		2 answer \| Add comment


I-SPY Neil Truby 12:37:47
	Did I read somewhere that I-SPY has a bug and will not work with IDS 10.0 xC4? I thought I did, but just did a Google search and can't find any mention, so must have it wrong. Is anyone using I-SPY successfully with IDS 10? Thx -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com
		Add comment


Difference between INFORMIX IDS Server 7.0 and 10.0 ? Michael Andreas 10:28:58
	Hi, using the following SQL-Commands I copy a informix table-structure and later very fast the table-rows to a MS-access DB: SELECT * INTO tab1 FROM [ODBC;DSN=InfomixDB;UID=myINF;PWD=myPWD;].tab1; INSERT INTO tab1 SELECT * FROM [ODBC;DSN=InfomixDB;UID=myINF;PWD=myPWD;].tab1; source: INFOMIX IDS Server 7.0 destination : MS Access 2000 ODBC-Driver : INTERSOLV 3.11 32-Bit INFORMIX 9 If I change the source DB from INFORMIX IDS Server 7.0 to INFOMIX IDS Server 10.0 for both commands I get the error-message: reserved error : there is no message for this error (message from MS-query). I changed the field-types but the result is the same. The table dont includs a serial field. My Question: What is the difference between Version 7 and 10? Who knows a solution for my problem? michael
		Add comment


Joined Row Update Jose da Fonseca 07:58:57
	Can anyone tell me if it is possible to do a joined row update (available in XPS) on ids 10 ?? syntax on XPS Update table1 set table1.col1 = table2.col3 from table1, table2 where table1.col1 = table2.col1; Thank you in advance JosГ©
		3 answer \| Add comment


informix performance degrade after one of out EMC drive fail Guest 02:14:18
	Hi all, Our scripts that use informix server as the DBMS become very slow after one of our EMC hard disk fail. We have not change the failed disk yet because currently a spare EMC disk is temporarily replacing it. Some of our jobs that normally took 4 hours to run now seems to can only finished after 10 hours. We have perform update statistics on the tables being used by the scripts but it does not help much. Can anyone please help us? This server is a production server and we cannot afford our jobs to be continue suspended like that. Thanks a lot! ps: we have tried to reboot the informix server as well as the host server but it does not help much ps: our dba claim that the failure of EMC disk will not cause performance degradation Thanks
		6 answers \| Add comment


Informix programmer Position Guest 00:14:02
	We are in need of a Senior Programmer analyst with Informix development experience for our client in NH. This is a full time perm poition with a very stable employer. Please send a word doc resume and let's talk! Tom Tom Murphy Members Information Services Information Technology Search Specialists 75 Gilcreast Rd Ste 305 Londonderry NH 0305 603-434-2500 x201 fax 603-432-2533 Laconia Office: 603-528-4777
		Add comment

Wednesday, 5 July 2006


FAST Recovery problem Anand Iyer 23:57:59
	hi I am having IDS 940UC2 . It has reached into a fast recovery mode.Also it is taking long time in the recovery mode IS there any way that i could bring up my INFORMIX instance ONLINE mode bypassing this fast recovery mode. or SKIP checking this logical log & what is the process to do a manual recovery of this logical log file Help would be appreciated rgds iyeranandmail@yahoo.co.in
		4 answer \| Add comment


IDS 9.40.FC8 and Stored Procedures Colin Dawson 21:37:02
	This may be a silly question but here goes. As V9 can have multiple Stored Procedures with the same name but with a different number of arguments what happens when you call a stored procedure with (say) 8 arguments, 4 of which have a default, and you only supply the other 4. How does IDS find it? Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Windows Live™ Messenger has arrived. Click here to download it for free! http://imagine-msn.com/messenger/launch80/?locale=en-gb
		2 answer \| Add comment


Update Statistics, Error -647 Reinhard Habichtsberg 21:21:38
	IDS 9.40 FC4W2 Solaris 9 Two questions about update statistics: 1. onstat -g sid reports: 761708 UPDATE STATIST aze CR Not Wait -647 0 9.03 Off Current SQL statement : update statistics medium finderr 647: Error evaluating math library function function-name The data type of the argument is correct, but the value passed to the function is not appropriate for the math function. Check that you are passing a legitimate value to the function. The session is running and causes some workload. I have no idea of the reason and implications of that error. Any suggestions? 2. I cannot kill sessions which are running update statistics with onmode -z sid. Also killing the calling unix process has no effect. Is it standard behavior that update statistics session cannot be killed? TIA, Reinhard.
		4 answer \| Add comment


Re: oninit -i Tbp 20:38:26
	Hamilton, Jerry wrote: Hmmmmm,,,,did you change your servernum? ------------------------------------------------------------------------ From informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Quman Sent Wednesday, July 05, 2006 11:28 AM To informix-list@iiug.org Subject oninit -i HI, I am using "oninit -i " to creat a new instance. Following is message log, 18:07:00 IBM Informix Dynamic Server Started. 18:07:01 Segment locked: addr=0x40000000, size=441319424 Mon Jul 3 18:07:01 2006 18:07:01 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure permissions 18:07:01 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alarmprogram.sh' 18:07:01 Booting Language <c> from module <> 18:07:01 Loading Module <CNULL> 18:07:01 Booting Language <builtin> from module <> 18:07:01 Loading Module <BUILTINNULL> 18:07:06 DR: DRAUTO is 0 (Off) 18:07:06 AIX MP latch code enabled 18:07:07 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial Number AAA#B000000 18:07:09 IBM Informix Dynamic Server Initialized -- Complete Disk Initialized. 18:07:09 Checkpoint Completed: duration was 0 seconds. 18:07:09 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x73 18:07:09 Maximum server connections 0 18:07:09 Dataskip is now OFF for all dbspaces 18:07:09 On-Line Mode 18:07:09 Building 'sysmaster' database ... 18:07:10 Logical Log 1 Complete, timestamp: 0x41a5. 18:07:11 Logical Log 2 Complete, timestamp: 0x7689. 18:07:11 Checkpoint Completed: duration was 0 seconds. 18:07:11 Checkpoint loguniq 3, logpos 0x18, timestamp: 0x76ab 18:07:11 Maximum server connections 1 18:07:11 Booting Language <spl> from module <> 18:07:11 Loading Module <SPLNULL> 18:07:12 Unloading Module <SPLNULL> 18:07:12 Loading Module <SPLNULL> 18:07:12 Logical Log 3 Complete, timestamp: 0x8c8e. 18:07:12 Unloading Module <SPLNULL> 18:07:13 Loading Module <SPLNULL> 18:07:13 Logical Log 4 Complete, timestamp: 0xcc4e. 18:07:13 Checkpoint Completed: duration was 0 seconds. 18:07:13 Checkpoint loguniq 5, logpos 0x104, timestamp: 0xcc94 18:07:13 Maximum server connections 1 18:07:13 Aborting Long Transaction: tx 0x6025eaac username: informix uid: 3000 18:07:14 'sysmaster' database built successfully. 18:07:14 'sysutils' database built successfully. 18:07:14 Error building 'sysuser' database. see output file /tmp/blduser.out. I looked at file : /tmp/blduser.out: 458: Long transaction aborted. 12204: RSAM error: Long transaction detected. Error in line 16 Near character position 31 I have no idea why iit says: 18:07:14 Error building 'sysuser' database. see output file /tmp/blduser.out. IDS 10 UC4 on AIX 5 Thanks, Quman What have you got set for LOGFILES and LOGSIZE and LTXHWM and LTXEHWM?? Possibly, maybe, perhaps related to the "Long transaction aborted" ... just a guess tho'
		Add comment


sqlexec thread migration from CPUVP to JVP Davorin Kremenjas 14:59:13
	Hello everyone. A few days ago I've had a situation at client's place regarding poor performance. They started using Java UDR's (for a very simple thing they were unable to do any other way). Java UDR was beeing called only once, during user's logging into application. Everything else was identical as before and application is already in production for a few years. This is what I observed together with client's DBA: if a user runs a Java UDR in his/her session, sqlexec thread for that session migrates it's execution to JVP. All successive atempts to run a query execute on JVP - and they execute a lot slower! I setup a simple test on my test instance like this: 1. Connect to database. 2. Run a "heavy" query. Result: sqlexec thread executes on cpu vp. 3. Run a simple Java UDR. 4. Run that same "heavy" query. Result: sqlexec thread executes on jvp. 5. Run a trivial C UDR designed to run on cpu vp (modifier: WITH(class='cpu')). 4. Run that same "heavy" query once again. Result: sqlexec thread executes on cpuvp. So I concluded that sqlexec migrates from one VP to another after it encopasses UDR's with explicitly set VP type. So, the client decided to use the "workaround" with calling C UDR to get sqlexec back to cpuvp. Since JVP's seems to execute a lot slower (much more threads in ready queue), with response times around 10 times longer, do you think I can consider this a bug/misfeature and place a call with Tech Support?
		Add comment


Question for experts / Copy from Informix to access Michael Andreas 11:19:15
	Hi, using the following SQL-Commands I copy a informix table-structure and later very fast the table-rows to a MS-access DB: SELECT * INTO tab1 FROM [ODBC;DSN=InfomixDB;UID=myINF;PWD=myPWD;].tab1; INSERT INTO tab1 SELECT * FROM [ODBC;DSN=InfomixDB;UID=myINF;PWD=myPWD;].tab1; source: INFOMIX IDS Server 7.0 destination : MS Access 2000 ODBC-Driver : INTERSOLV 3.11 32-Bit INFORMIX 9 If I change the source DB from INFORMIX IDS Server 7.0 to INFOMIX IDS Server 10.0 for both commands I get the error-message: reserved error : there is no message for this error (message from MS-query). I changed the field-types but the result is the same. The table dont includs a serial field. My Question: What is the difference between Version 7 and 10? Who knows a solution for my problem? michael
		Add comment

Tuesday, 4 July 2006


dbexport and different rows number Ph 19:49:27
	Hi, I exported informix database using dbexport buildin tool. I have many tables and in same cases there are difference between row number reported in sql exported file and real number of rows in unl file: eg. { TABLE test row size = 8 number of columns = 2 index size = 24 } { unload file name = test101.unl number of rows = 91425 } but real number of rows is 91320 While is this? ph
		4 answer \| Add comment


4GL Survey Jean Georges Perrin 19:47:00
	Hi all, A few months ago, I ran a survey, and while I am already working on the results, some of you expressed the wish to continue participating in the survey. Please feel free to go to http://www.jgp.net/4glsurvey. I took a little delay in processing the survey, so I have extended to July 14th for additional input. The benefit of being late is that YOU HAVE A WEB FORM now! It only takes 5 minutes. I promise results for before the end of July! Thanks! Jean Georges Perrin (aka jgp) IIUG (International Informix Users Group) - Board of Directors http://www.iiug.org jgp@iiug.org -- GO FURTHER...with DB2 and Informix. Attend the IDUG 2006 European Conference. Vienna, Austria. 2-6 October 2006. Visit http://www.iiug.org/conf for more information!
		Add comment


Re: Regarding Debuuger Art S. Kagel 19:16:31
	Prateek Jain wrote: Hi, We currently have Informix c4gl and want to have debugger(fgldb) which comes along with r4gl. We want to have Informix Debugger fgldb. Is Debugger free , In short how to get it or have c4gl application get debugged like the fgldb debugger. The best you can do is to compile the c4gl app with -g and use a conventional debugger. If it gets a bit weird, then use -G and -keep to eliminate the 4Gl line numbers and debug at the .c file level. The only 4GL level debugger for Informix 4GL is fgldb for which you need r4gl since it debugs the pcode not machine code. Art S. Kagel
		2 answer \| Add comment


Informix and the World Cup Neil Truby 19:01:23
	Around about the turn of the year there was a flurry of mails about Informix technology being embedded into the World Cup balls for tracking purposes. David Williams wrote for example: "And the big Euro 2006 (or whatever soccer event). IBM will have chips in the ball and players boots and realtime tracking all via an IDS database. Where is the publicity that IBM beat (who?) to this? That was mentioned at the UK Usergroup meeting but we were not asked by Michelle to keep quiet about it!" Did this in fact ever happen? I've read absolutely nothing about it since. Incidentally, on the front page of today's Computing ""At the Wimbledon Tennis Championships (sic) IT partner IBM is operating real-time wireless badge scanning ... The (database) being checked against - IBM's DB2 - holds personal data and photographic records ..." (Wayne Rooney's been embedding his studs in balls, of course, but that's a different matter ...) -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com
		5 answers \| Add comment


Scripts - URL Dirk Moolman 18:59:50
	Found some good scripts on this link - for those interested: http://www.prstech.com/downloads.shtml Dirk Moolman Database and Unix Administrator Digicare Technologies (HealthCorp) The other day I was trapped on an escalator for hours....the power went out!!! The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way. No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.
		Add comment


select (display) problem Dirk Moolman 15:43:27
	I have a problem with one of the tables I am trying to move to another database. The one field in the table is a char(30), and when I unload it, I get this value in the unload file (the example is 1 column only, which contains a pipe and carriage return): HOSPITAL\|emergency^M\ When I select this record in dbaccess or isql, only the word "HOSPITAL" is displayed on the screen. Why does the full value not display on the screen during the select ? This is in IDS7.31 FD3 The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way. No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.
		1 answer \| Add comment


ISAM Error SQL error -243 Devtakh 09:03:16
	Hello, I am hoping you cold help me. I have a program written in C with embedded SQL (CESL) code. In running the program, in one of the delete steps, I get an error SQL ERROR -243 SQL Message = [owner.tabname] ISAM error=[-113] ISAM error: the file is locked. I know that there are no other processes running simultaneously to have caused a lock on this table. What might have caused this issue?. The problem is if I run the program again, it rUNs fine.. Thanks, Jernand
		2 answer \| Add comment

Monday, 3 July 2006


distribution only? Guest 20:00:10
	Hi teachers, I could not understand what is the meaning of "distribution only" in the update statistics statement. Kindly please teach me. Thanks a lot.
		1 answer \| Add comment

QAIX > Informix database development

Go to page: « previous | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | next »

	see also: _POST incorrect output... New commercial software needs beta… UPDATE MySQL		see also: Is there any way to resize an image? How to cache PHP on Apache posible bug, require and symlinks		see also: Syntax Help how to generate ms-word files passing multiple variables in a url

Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:

If you would like to report an abuse of our service, such as a spam message, please .

How:		anonymous ( Register )
		user:
		Логин: Пароль: Войти?
		Комментировать могут: Премодерация:
Topic:


Receive comments by e-mail Add to favourites

Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

Add new topic: