dbTalk Databases Forums  

Sponsored Links

comp.databases.informix comp.databases.informix

Discuss in the comp.databases.informix forum.

Post New Thread
Threads in Forum : comp.databases.informix Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Regarding this aspect, I think some examples may help to understand some differences... Not sure if I mentioned this here before... Sometime ago a...
08-23-2012 05:05 PM
Fernando Nunes Go to last post
3 84
I have an opportunity to change the fragmentation strategy on some heavily used tables. Most records on these tables are only accessed on the day...
Laurie Gustin
08-21-2012 12:20 AM
John Miller iii Go to last post
3 119
Hi, How can I write a routine in Esql/C which initialize to 0 (zero) all numeric fields (smallint, decimal, etc) and to (' ') space the other fields...
Francesco Alfano
08-16-2012 03:27 PM
Bartlomiej Lidke Go to last post
6 95
Hi, How can I determine, in ESQL, the datatype of the columns in a table without first usign a SELECT statement ? I'm looking for a sample code that...
Francesco Alfano
08-16-2012 10:27 AM
Jonathan Leffler Go to last post
3 76
I want to format data value like : let char_var = date_var using 'yy' ; ( get the year from date ) & let char_var2 = char_var1, int_var using '&&&&'...
08-16-2012 09:53 AM
Jonathan Leffler Go to last post
2 91
To change non-logged database to logged database. Anything I need to change in 4gl program ?
08-09-2012 09:00 PM
roger Go to last post
6 99
create table tab1_jj ( id serial8 not null , cr_date datetime year to second default current year to second not null , acc_id integer not...
08-08-2012 03:17 PM
JJ Go to last post
2 73
Does anyone have experience with SAN-level replication and its effect on Informix, especially with respect to disaster recovery/restore? We're...
08-08-2012 02:59 PM
mpruet Go to last post
2 90
We are planning to use DE in our development and test environment. I am aware of the limitations to CPU VP's, disk and memory as described in...
08-01-2012 06:19 AM
KN Liew Liew Go to last post
3 88
I have IDS 10.00.FC5 running on Solaris 5.8 thus I have a default page size of 2k. One of the table (NOT my design !!) has a row size of 1079 so I...
Keith Simmons
07-31-2012 09:49 AM
Keith Simmons Go to last post
3 81
We recently upgraded two instances from 11.7.FC4 to 11.7.FC5 on AIX 6.1 Strange situation arose in that the automatic firing of backing up the...
07-30-2012 08:35 AM
jrenaut Go to last post
1 91
You could parse the output from the onlog -n -t<tblspace number> for HUPDATE, HINSERT, HDELETE entries...the Administrator's ref manual gives info on...
07-17-2012 04:44 AM
malc_p Go to last post
7 133
Hi, Ifx 11.50 FC9X6 AIX 6.1 We have a table where two columns are used for filter : create table tst ( col1 int , col2 int); select * from tst...
Cesar Inacio Martins
07-06-2012 03:32 PM
Art Kagel Go to last post
4 130
This seems straight forward... hopefully someone knows a quick answer. IDS 11.7 FC5 Red Hat Enterprise Server release 6.3 (Santiago) Trying to...
Laurie Gustin
07-02-2012 02:07 PM
Laurie Gustin Go to last post
12 237
Hi, in the context of: Informix 4GL 7.50 Without C/Java procedures. Without RUN external program. Can i EXECUTE a prepared statement (an insert)...
06-29-2012 08:51 AM
eferreyra Go to last post
3 141
Hi every body, Help me please... I can`t do that : ----------------- select * from ecofin@e3500desa_tcp:cuentas_corrientes I get the following...
LUQUE Valdivia Omar
06-27-2012 11:21 AM
Art Kagel Go to last post
8 703
hello we recently upgraded from version 11.7.FC4 to 11.7.FC5 on AIX 6.1. The scripts we use for the backups and alarms are the same (except for the...
06-26-2012 01:44 PM
tomcaml@gmail.com Go to last post
3 186
HPUX B.11.31 U ia64 on HP BL870c IDS 11.50.FC6 We have two HP BL870c Integrity servers, one is the production the second is for testing and recovery...
John Adamski
06-25-2012 10:41 AM
jrenaut Go to last post
2 168
To serialize some kind of data modifications our application uses an exclusive table lock (lock table %s in exclusive mode). Process retrieves some...
Frank Langelage
06-19-2012 05:40 AM
Art Kagel Go to last post
2 93
Hi everybody, i just want to know, how to retrieve the current value of an serial in a table. For example, there is a table with a serial. In the...
Michael Weber
06-08-2012 12:44 AM
Michael Weber Go to last post
4 104
This is really silly to have to ask this.... When we do a level 0 archive, does the process start with a checkpoint? I always thought it did but...
06-01-2012 03:43 AM
Cats Go to last post
2 107
Related to this old...
Francesco Veroni
05-30-2012 05:36 AM
Art Kagel Go to last post
1 67
In a very old training doc I found this: http://dl.dropbox.com/u/3605787/sqlhosts.JPG I would ask: what kind of sense have to configure more than 1...
Francesco Veroni
05-25-2012 02:43 AM
Francesco Veroni Go to last post
2 78
IDS9.30HC5, HP-UX 11i We're running DR testing and have a backup of type "file" we're trying to load onto the DR box. I've done an ism_catalog...
Malc P
05-23-2012 02:57 AM
Malc P Go to last post
2 72
I have a table called club_members. It has 3 columns first_name,last_name,club_name Write a query to summarize how many clubs each student is in. ...
Floyd Wellershaus
05-10-2012 10:23 AM
Araujo, Daniel Go to last post
4 73
Hello all, Can anyone shed any light on the following error..... Thanks in Advance.... HP-UX sleepy B.11.11 U 9000/800 2262126760 unlimited-user...
05-04-2012 05:40 AM
Art Kagel Go to last post
1 90
Hi, 11.50 FC9X6 , AIX 6.1 We suffer with one situation at our production where just not found a acceptable way to work yet... I already open a PMR...
Cesar Inacio Martins
05-03-2012 06:36 AM
Cesar Inacio Martins Go to last post
9 70
Morning all An odd one which I have a faint bell ringing at the back of my head about.... IDS9.30HC5, HP-UX11i We run our L1 backups using onbar -L0...
Malc P
04-30-2012 08:38 AM
Jason Harris Go to last post
8 77
New Fastest Informix DBA Contest 2012 1,000 OLTP users benchmark run on a Apple Mac Mini Server Andrew Ford is the Grand Prize Winner of a new...
Lester Knutsen
04-30-2012 07:07 AM
Malc P Go to last post
1 64
Hi, ifx 11.50 FC9X6 , AIX 6.1 I'm looking about use of indexes on some tables. The mainly objective is check if this indexes still needed and who...
Cesar Inacio Martins
04-25-2012 09:39 AM
Cesar Inacio Martins Go to last post
1 60
hi, i'm looking for any solution which allow me to get database server online or export data from dbspace the state is as follows: # onstat...
Marcin Tomczyk
04-21-2012 12:16 PM
Superboer Go to last post
7 108
hello all, according to this article (http://www.jfmiii.com/informix/?paged=2) We’ve also added a new algorithm for gathering statistics to...
04-20-2012 05:16 AM
Fernando Nunes Go to last post
3 65
To keep a database normalized should a one to many relationship always use two tables? The data in the following table is used as a master record,...
04-16-2012 01:32 PM
Art Kagel Go to last post
3 83
hello, one of our developers wanted to use a function natively in Informix that behaves like DB2's row_num function. seq_num would be returned from...
04-12-2012 09:30 AM
Art Kagel Go to last post
1 78
Hello, I'm currently working on expanding my knowledge and would like to work more on the database side of things. I would like to learn more about...
04-09-2012 01:55 PM
Art Kagel Go to last post
1 65
Just for completeness - you could also try Aubit4GL ( http://sourceforge.net/projects/aubit4gl/) We *do* use normal ncurses , and because its open...
Anders Molander
03-28-2012 02:16 PM
Mike Aubury Go to last post
5 83
IDS Innovator-C V11.70UC4IE Fedora Linux V16 running on a Lenovo thinkpad T500 I've had this installation running for a month or more now but on...
Malc P
03-26-2012 08:47 AM
Malc P Go to last post
5 94
Depending on your needs and performance requirmentes there may be an easy solution. AFAIK the standard COALESCE function takes arguments that may...
03-24-2012 03:46 PM
Fernando Nunes Go to last post
3 94
Tom: Try instead to turn the SQLTRACE feature on and query sysmaster:syssqltrace instead. That accesses a different area of memory in the server...
03-23-2012 09:19 AM
tomcaml@gmail.com Go to last post
2 98
Ian Goddard
03-18-2012 04:17 AM
Ian Goddard Go to last post
4 68
On 15/03/12 13:57, Todd Roy wrote: Assuming that the logs haven't wrapped - the only way to achieve this is for advanced support to dial in and...
Marco Greco
03-16-2012 12:29 PM
Todd Roy Go to last post
8 58
Dear Informixers, why is a query containing outer joins written as LEFT JOIN so much slower than when written using the Informix-specific OUTER...
03-14-2012 10:34 AM
Richard Spitz Go to last post
8 85
Hello all. I'm running IDS 11.50.FC6. I have a situation where it would be very useful to Base64 encode a string to store in the database. ...
Sean Baker
03-13-2012 05:38 PM
Art Kagel Go to last post
1 66
System: IBM Informix Dynamic Server Version 9.40.UC6W4 Hi guys, sorry for my bad language but i'll try to describe my problem. Where is the...
Michael Weber
03-13-2012 09:07 AM
Art Kagel Go to last post
1 58
On Mon, Mar 5, 2012 at 05:45, David Linthwaite <dlinthwaite (AT) lintel (DOT) co.uk>wrote: I'm not aware of a specific problem with ON-Monitor,...
Malc P
03-05-2012 09:15 AM
Jonathan Leffler Go to last post
9 62
Good Morning - Some questions regarding using different languages. I am only familiar with English within the Database. If we currently have all our...
Tom Lehr
03-05-2012 08:56 AM
tomcaml@gmail.com Go to last post
2 58
Hello, the 2 tables fyar1sta and fyar2sta are 1:1 related with the field artikel I must copy bewprs to aktvkp in the table fyar2sta but only for...
Ralf Hackmann
02-28-2012 05:37 AM
Ralf Hackmann Go to last post
3 96
We recently moved from a physical to a virtual host (VMware) for a data warehouse DB. The migration was used Tivoli Bare-Metal Restore for O/S and...
02-25-2012 08:20 PM
Art Kagel Go to last post
1 75
Hello, We have a need for a non-informix user to be able to connect to the Informix DB via dbaccess while the DB is in Single-User Admin Mode...
Informix DBA
02-22-2012 02:28 PM
Informix DBA Go to last post
3 79
We are trying to insert data into a table and get the following error WARNING: DBspace dldata1 is full Seems pretty straight forward... except the...
Laurie Gustin
02-20-2012 09:10 AM
Art Kagel Go to last post
1 63
Post New Thread

Display Options
Showing threads 151 to 200 of 6962
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.