|
More site info...
|
|
Forum profile page for Informix on http://www.dbforums.com.
This report page is the aggregated overview from a single forum: Informix, located on the Message Board at http://www.dbforums.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Informix" on the Message Board at http://www.dbforums.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Informix:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
18
|
53
|
139
|
|
Post:
|
32
|
91
|
197
|
|
|
Informix Posting activity graph:
|
Top authors during last week:
user's latest post:
Issues with Cursor in informix...
Published (2009-11-30 10:12:00)
Can you please tell me how to use foreach in this example and also how do i grant & execute this procedure
user's latest post:
Recovery mode
Published (2009-11-23 13:27:00)
Cesar, I tried the oninit -PHY you were right it did not work BTW I'm running 7.23.UC11
user's latest post:
IDS startup problem (from...
Published (2009-11-26 08:06:00)
I will try to descibe what happend after restart. 1) we make: export INFORMIXSERVER=imc05 2) we tried onstat with result: shared memory not initialised for INFORMIXSERVER 'imc05' 3) we tried ipcs with result no shared memory shown 4) we make onmonitor -> Mode -> Startup message was "Initialising, please wait ..." after several seconds we get message: "Press return to continue" after...
user's latest post:
install informix in cluster
Published (2009-11-27 08:22:00)
Hi ceinma, Thank you for you response, you can say me the link where is the information about installing informix in cluster, I have not experience installing informix in cluster. Thank you for you help.
user's latest post:
Group by alias
Published (2009-11-30 18:30:00)
Why not? If I make your query like: Code: SELECT to_char(dat, '%Y') year, count(*) number FROM table WHERE dat BETWEEN '2005-01-01' AND '2009-12-31' AND nr = 1 GROUP BY 1 I get the result you described. Regards, Hans
user's latest post:
Need your help please
Published (2009-11-24 03:03:00)
[IMG]http://s11.radikal****/i183/0910/4f/9ae7cddaec55.jpg[/IMG] dove acquistare senza prescrizione Kamagra kamagra
user's latest post:
Getting error while adding new...
Published (2009-11-23 12:41:00)
You can't use "type" as a column name because "type" is a reserved word.
user's latest post:
LIKE operator on CLOB column
Published (2009-11-26 03:23:00)
Hello, Suppose I have table TESTTABLE with columns id(INT8 PK), clob(CLOB), text(TEXT) Is there any way to use LIKE operator on these columns? select * from TESTTABLE where TESTTABLE.clob like 'sss%' or select * from TESTTABLE where TESTTABLE.text like 'sss%'
OKamagranli OKamagranli is...
1
user's latest post:
Need your help please
Published (2009-11-24 03:03:00)
[IMG]http://s11.radikal****/i183/0910/4f/9ae7cddaec55.jpg[/IMG] dove acquistare senza prescrizione Kamagra kamagra
|
|
|
|
Latest active threads on Informix::
Started 1 day, 6 hours ago (2009-11-30 18:30:00)
by Tyveleyn
Why not? If I make your query like:
Code:
SELECT to_char(dat, '%Y') year, count(*) number
FROM table
WHERE dat BETWEEN '2005-01-01' AND '2009-12-31'
AND nr = 1
GROUP BY 1
I get the result you described.
Regards,
Hans
Started 5 days, 15 hours ago (2009-11-26 09:38:00)
by ceinma
1) What IDS version?
2) You are written an ESQL/C style over SPL ... never will work...
If you work with IDS before 11.50 , you must use FOREACH can't use PREPARE+DECLARE+FETCH .
If you use IDS 11.50 this is the right syntax, this command already allowed, check the manual: Usage .
your code with corrections...
Code:
#Using DECLARE (works only in IDS 11.50)
#tested in...
Started 1 day, 12 hours ago (2009-11-30 12:27:00)
by ceinma
1) Informix use the OS user as default to authentication
2) if executed the dbaccess from a remote machine, they use your logged user to connect, if they don't exists, you got this error 951)
Quote:
>finderr 951
-951 User username is not known on the database server.
The database server that you tried to access does not accept either
your user ID, the...
Started 4 days, 15 hours ago (2009-11-27 09:42:00)
by Tyveleyn
Not in a query. What you want to do should be done in a stored function or simply in a programming environment. For instance if you're working on a UNIX system and this query is executed in dbaccess you could redirect the Output To-pipe:
Code:
awk '{a[$1] = (length(a[$1]) > 0) ? a[$1] ";" $2 : a[$1] $2}END{for(i in a)print i, a[i]}'
Regards,
Hans
Started 5 days, 14 hours ago (2009-11-26 11:05:00)
by ceinma
there a lot of "IF" there.... what kind of cluster is your desired, how is your enviroment to support a cluster, what license of IDS you have...
Read the manual... check the IIUG presentations... watch the webcasts, read the e-book of Carlton Doe about IDS 11.10 (if you are using the version 11.10 or 11.50), read the articles on the IBM site...
First learn the kinds of cluster, what you can...
Started 5 days, 13 hours ago (2009-11-26 11:21:00)
by ceinma
what version of IDS?
I not sure, but this is supported only after version 10 xC3...
in IDS 11.50 , this code works
Code:
create temp table a ( coda int);
Temporary table created.
create temp table b (codb int);
Temporary table created.
insert into b values (1);
1 row(s) inserted.
insert into b values (2);
1 row(s) inserted.
insert into b values (3);
1 ...
Started 5 days, 18 hours ago (2009-11-26 06:26:00)
by fharindogo
Quote:
Originally Posted by imczl
We can not bring our IDS into quiescent mode. After Linux server restart we run onmonitor (Mode, Startup) and the rusult is the the mode is not changed to quescent but no error message is shown. If we look in online.log there is a line "Quiescent Mode". Isn't it strange? Notes: We have IDS 7.3.
...
Started 5 days, 21 hours ago (2009-11-26 03:23:00)
by nimit77 nimit77 is offline Registered User
Hello,
Suppose I have table TESTTABLE with columns id(INT8 PK), clob(CLOB), text(TEXT)
Is there any way to use LIKE operator on these columns?
select * from TESTTABLE where TESTTABLE.clob like 'sss%'
or
select * from TESTTABLE where TESTTABLE.text like 'sss%'
Started 1 week ago (2009-11-24 03:03:00)
by OKamagranli OKamagranli is offline Banned
[IMG]http://s11.radikal****/i183/0910/4f/9ae7cddae c55.jpg[/IMG]
dove acquistare senza prescrizione Kamagra kamagra
Started 1 week, 1 day ago (2009-11-23 12:52:00)
by ceinma
yes but probably not work for your object... to change a instance from standard to secondary you must restore from an archive (hdr) or copy theirs chunks manually (onmode - c block; copy; ontape -p -e ; onmode -c unblock) ...
Exists an undocumented option : "oninit -PHY" , will keep your instance in physical recovery, but probably will not sync with the primary when you try add it to HDR.
...
|
|
Hot threads for last week on Informix::
Started 5 days, 13 hours ago (2009-11-26 11:21:00)
by ceinma
what version of IDS?
I not sure, but this is supported only after version 10 xC3...
in IDS 11.50 , this code works
Code:
create temp table a ( coda int);
Temporary table created.
create temp table b (codb int);
Temporary table created.
insert into b values (1);
1 row(s) inserted.
insert into b values (2);
1 row(s) inserted.
insert into b values (3);
1 ...
Started 5 days, 15 hours ago (2009-11-26 09:38:00)
by ceinma
1) What IDS version?
2) You are written an ESQL/C style over SPL ... never will work...
If you work with IDS before 11.50 , you must use FOREACH can't use PREPARE+DECLARE+FETCH .
If you use IDS 11.50 this is the right syntax, this command already allowed, check the manual: Usage .
your code with corrections...
Code:
#Using DECLARE (works only in IDS 11.50)
#tested in...
Started 1 week, 1 day ago (2009-11-23 12:52:00)
by ceinma
yes but probably not work for your object... to change a instance from standard to secondary you must restore from an archive (hdr) or copy theirs chunks manually (onmode - c block; copy; ontape -p -e ; onmode -c unblock) ...
Exists an undocumented option : "oninit -PHY" , will keep your instance in physical recovery, but probably will not sync with the primary when you try add it to HDR.
...
Started 5 days, 18 hours ago (2009-11-26 06:26:00)
by fharindogo
Quote:
Originally Posted by imczl
We can not bring our IDS into quiescent mode. After Linux server restart we run onmonitor (Mode, Startup) and the rusult is the the mode is not changed to quescent but no error message is shown. If we look in online.log there is a line "Quiescent Mode". Isn't it strange? Notes: We have IDS 7.3.
...
Started 5 days, 14 hours ago (2009-11-26 11:05:00)
by ceinma
there a lot of "IF" there.... what kind of cluster is your desired, how is your enviroment to support a cluster, what license of IDS you have...
Read the manual... check the IIUG presentations... watch the webcasts, read the e-book of Carlton Doe about IDS 11.10 (if you are using the version 11.10 or 11.50), read the articles on the IBM site...
First learn the kinds of cluster, what you can...
Started 4 days, 15 hours ago (2009-11-27 09:42:00)
by Tyveleyn
Not in a query. What you want to do should be done in a stored function or simply in a programming environment. For instance if you're working on a UNIX system and this query is executed in dbaccess you could redirect the Output To-pipe:
Code:
awk '{a[$1] = (length(a[$1]) > 0) ? a[$1] ";" $2 : a[$1] $2}END{for(i in a)print i, a[i]}'
Regards,
Hans
Started 1 week ago (2009-11-24 03:03:00)
by OKamagranli OKamagranli is offline Banned
[IMG]http://s11.radikal****/i183/0910/4f/9ae7cddae c55.jpg[/IMG]
dove acquistare senza prescrizione Kamagra kamagra
Started 5 days, 21 hours ago (2009-11-26 03:23:00)
by nimit77 nimit77 is offline Registered User
Hello,
Suppose I have table TESTTABLE with columns id(INT8 PK), clob(CLOB), text(TEXT)
Is there any way to use LIKE operator on these columns?
select * from TESTTABLE where TESTTABLE.clob like 'sss%'
or
select * from TESTTABLE where TESTTABLE.text like 'sss%'
Started 1 day, 12 hours ago (2009-11-30 12:27:00)
by ceinma
1) Informix use the OS user as default to authentication
2) if executed the dbaccess from a remote machine, they use your logged user to connect, if they don't exists, you got this error 951)
Quote:
>finderr 951
-951 User username is not known on the database server.
The database server that you tried to access does not accept either
your user ID, the...
Started 1 day, 6 hours ago (2009-11-30 18:30:00)
by Tyveleyn
Why not? If I make your query like:
Code:
SELECT to_char(dat, '%Y') year, count(*) number
FROM table
WHERE dat BETWEEN '2005-01-01' AND '2009-12-31'
AND nr = 1
GROUP BY 1
I get the result you described.
Regards,
Hans
|
|
Size: 604 bytes
