Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Informix | Forum profile

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.

Site: dBforums - Database Support Community - Informix (site profile, domain info dbforums.com)
Title: Informix
Url: http://www.dbforums.com/informix/
Users activity: 14 post per thread
Forum activity: 18 active threads during last week
 

Posting activity on Informix:

  Week Month 3 Months
Threads: 18 53 139
Post: 32 91 197
 

Informix Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
ceinma
8
user's latest post:
Issues with Cursor in informix...
Published (2009-11-30 12:34:00)
manual v10 : FOREACH manual v11 : FOREACH
pbangalore
7
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
obwan
2
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
imczl
2
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...
georgipa
2
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.
Tyveleyn
2
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
OKamagranli
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
mjldba
1
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.
nimit77
1
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::

dBforums - Database Support Community
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
Thread:  Show this thread (2 posts)   Thread info: Group by alias Size: 604 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Why not? If I make your query like: Code:

SELECT to_char(dat, '%Y') year, count(*) number
FROM table                                     
WHERE dat... :: Informix :: dBforums - Database Support Community"
dBforums - Database Support Community
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...
Thread:  Show this thread (5 posts)   Thread info: Issues with Cursor in informix procedure Size: 1,615 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: 1) What IDS version?
2) You are written an ESQL/C style over SPL ... never will work...

If you... :: Informix :: dBforums - Database Support Community"
dBforums - Database Support Community
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...
Thread:  Show this thread (2 posts)   Thread info: dbaccess command line help for newbie. Size: 1,687 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: 1) Informix use the OS user as default to authentication
2) if executed the dbaccess from a remote machine,... :: Informix :: dBforums - Database Support Community"
dBforums - Database Support Community
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
Thread:  Show this thread (3 posts)   Thread info: Split rows into one row as comma delimited string Size: 662 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Not in a query. What you want to do should be done in a stored function or
simply in... :: Informix :: dBforums - Database Support Community"
dBforums - Database Support Community
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...
Thread:  Show this thread (3 posts)   Thread info: install informix in cluster Size: 686 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: there a lot of "IF" there.... what kind of cluster is your desired, how is
your enviroment to support... :: Informix :: dBforums - Database Support Community"
dBforums - Database Support Community
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 ...
Thread:  Show this thread (5 posts)   Thread info: Error while inserting into temp table Size: 821 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: what version of IDS?

I not sure, but this is supported only after version 10 xC3...

in IDS 11.50... :: Informix :: dBforums - Database Support Community"
dBforums - Database Support Community
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. ...
Thread:  Show this thread (3 posts)   Thread info: IDS startup problem (from offline to quiescent) Size: 1,144 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Quote:

	Originally Posted by imczl We can not bring our IDS into quiescent mode. After Linux server restart we... :: Informix :: dBforums - Database Support Community"
dBforums - Database Support Community
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%'
Thread:  Show this thread (2 posts)   Thread info: LIKE operator on CLOB column Size: 326 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: LIKE operator on CLOB column :: Informix :: dBforums - Database Support Community"
dBforums - Database Support Community
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
Thread:  Show this thread (2 posts)   Thread info: Need your help please Size: 282 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Need your help please :: Informix :: dBforums - Database Support Community"
dBforums - Database Support Community
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. ...
Thread:  Show this thread (3 posts)   Thread info: Recovery mode Size: 889 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: yes but probably not work for your object... to change a instance from
standard to secondary you must restore... :: Informix :: dBforums - Database Support Community"
 

Hot threads for last week on Informix::

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 ...
Thread:  Show this thread (5 posts)   Thread info: Error while inserting into temp table Size: 821 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: what version of IDS?

I not sure, but this is supported only after version 10 xC3...

in IDS 11.50... :: Informix :: dBforums - Database Support Community"
Informix
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...
Thread:  Show this thread (5 posts)   Thread info: Issues with Cursor in informix procedure Size: 1,615 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: 1) What IDS version?
2) You are written an ESQL/C style over SPL ... never will work...

If you... :: Informix :: dBforums - Database Support Community"
Informix
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. ...
Thread:  Show this thread (3 posts)   Thread info: Recovery mode Size: 889 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: yes but probably not work for your object... to change a instance from
standard to secondary you must restore... :: Informix :: dBforums - Database Support Community"
Informix
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. ...
Thread:  Show this thread (3 posts)   Thread info: IDS startup problem (from offline to quiescent) Size: 1,144 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Quote:

	Originally Posted by imczl We can not bring our IDS into quiescent mode. After Linux server restart we... :: Informix :: dBforums - Database Support Community"
Informix
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...
Thread:  Show this thread (3 posts)   Thread info: install informix in cluster Size: 686 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: there a lot of "IF" there.... what kind of cluster is your desired, how is
your enviroment to support... :: Informix :: dBforums - Database Support Community"
Informix
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
Thread:  Show this thread (3 posts)   Thread info: Split rows into one row as comma delimited string Size: 662 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Not in a query. What you want to do should be done in a stored function or
simply in... :: Informix :: dBforums - Database Support Community"
Informix
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
Thread:  Show this thread (2 posts)   Thread info: Need your help please Size: 282 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Need your help please :: Informix :: dBforums - Database Support Community"
Informix
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%'
Thread:  Show this thread (2 posts)   Thread info: LIKE operator on CLOB column Size: 326 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: LIKE operator on CLOB column :: Informix :: dBforums - Database Support Community"
Informix
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...
Thread:  Show this thread (2 posts)   Thread info: dbaccess command line help for newbie. Size: 1,687 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: 1) Informix use the OS user as default to authentication
2) if executed the dbaccess from a remote machine,... :: Informix :: dBforums - Database Support Community"
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
Thread:  Show this thread (2 posts)   Thread info: Group by alias Size: 604 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Why not? If I make your query like: Code:

SELECT to_char(dat, '%Y') year, count(*) number
FROM table                                     
WHERE dat... :: Informix :: dBforums - Database Support Community"