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     
If you need a substitute for ROWID for temp tables, checkout the rownum() function I posted to my blog yesterday. That should serve either...
09-25-2012 01:38 PM
tomcaml@gmail.com Go to last post
5 68
Is there a way to stream onbar output to multiple storage manager nodes? We'd like to redundantly store Informix backups. Using IDS 11.70.FC4 on...
09-19-2012 05:14 PM
Art Kagel Go to last post
1 65
hello all we currently have this parameter disabled. I am looking for feedback on experiences using this parameter versus how we are doing it,...
09-19-2012 08:11 AM
Art Kagel Go to last post
5 56
Hi several times here have raised some questions about Informix 4gl and gently got options about Aubit 4gl. I would like to contact this people for...
09-14-2012 06:18 AM
eferreyra Go to last post
2 56
I'm chatting with a customer DBA about UPDATE STATISTICS HIGH and he's reporting some seemingly counterintuitive performance results... On a table...
John Hardin
09-14-2012 01:11 AM
John Miller iii Go to last post
2 129
Hoping to get some opinions on this. We have a public website that is currently using our main production database (IDS 11.50.FC6). The main query...
Sean Baker
09-04-2012 06:41 PM
Jason Harris Go to last post
5 304
Hello, I've searched the web and don't see any clear answer on this. Any advice would be appreciated. We have always used the default character...
09-04-2012 05:32 PM
Fernando Nunes Go to last post
1 101
I have an IDS instance running 11.50.FC4 on AIX. The OS pagesize is as follows: $ pagesize 4096 The rootdbs page size is also 4096 bytes as shown...
09-04-2012 07:27 AM
jrenaut Go to last post
2 121
Using dbaccess I am trying to keep a database connection open in a shell script until I want to close it. It may be easiest to explain what I'm...
09-03-2012 08:33 PM
Desmodromic Go to last post
6 127
Is it possible to obtain the page version information that oncheck -pT reports in the "Home Data Page Version Summary" section from the sysmaster...
08-27-2012 09:30 PM
Art Kagel Go to last post
3 184
I don't know. Marco is correct as far as it goes, but I'm not sure whether embedded SET PDQPRIORITY commands will do that. One way to check.....
John Hardin
08-23-2012 07:48 PM
Art Kagel Go to last post
7 145
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 145
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 162
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 138
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 93
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 112
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 118
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 104
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 105
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 106
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 101
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 135
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 153
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 150
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 292
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 172
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 827
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 237
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 226
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 111
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 144
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 128
Related to this old...
Francesco Veroni
05-30-2012 05:36 AM
Art Kagel Go to last post
1 88
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 89
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 97
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 117
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 117
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 117
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 103
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 93
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 95
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 153
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 101
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 117
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 97
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 98
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 122
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 145
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 123
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 152
Post New Thread

Display Options
Showing threads 151 to 200 of 6973
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 - 2015, Jelsoft Enterprises Ltd.