|
More site info...
developerWorks : Information Management Forums - www.ibm.com/developerworks/db2/ | Site profile
|
|
Site profile page for http://www.ibm.com/developerworks/db2/.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.ibm.com/developerworks/db2/.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.ibm.com/developerworks/db2/ is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) 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 site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on developerWorks : Information Management Forums:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
181
|
853
|
2,604
|
|
Post:
|
260
|
1,413
|
4,346
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for developerWorks : Information Management Forums (http://www.ibm.com/developerworks/db2/)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
developerWorks : Information Management Forums posting activity graph:
|
|
http://www.ibm.com/developerworks/db2/ Alexa graph:
|
Top authors on developerWorks : Information Management Forums during last week:
user's latest post:
Why is NOT EQUAL invalid SQL...
Published (2009-11-16 02:51:00)
This is just the syntax that db2 gets not equal is not part of it you can use is distinct from in order to check if 2 values are different and it will also returns answers if either value is null Not equal to another value or one value is equal to null => IS DISTINCT FROM => PHONENO IS DISTINCT FROM :PHONEHV http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_retrievedataselect.htm
user's latest post:
Errors when compiling the sample...
Published (2009-11-13 11:57:00)
I fixed the nmake problem but I still get the following message: DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL20204N The user defined function or procedure "U000591.TWO_RESULT_SETS" was unable to map to a single Java method. LINE NUMBER=10. SQLSTATE=46008
user's latest post:
Add a picture in an email to...
Published (2009-11-20 11:25:00)
I tried it in a scheduled email on a report and in Event Studio in an email task (since you had mentioned E.S. before) and neither works in Outlook. Can you tell us where you did that - a regular schedule or Event Studio? It might just be an Outlook problem and I'm curious.
user's latest post:
Value Prompt
Published (2009-11-20 10:25:00)
Hi claoker, A couple of questions to clarify this: did you develop the reports in 2 pages (one for USA, one for EURO)? If so, reorder the pages. did you make the report in 1 page, sectioning by USA and EURO? If so, change ordenation of the Data Item which stores those values. Hope it helps. If not, could you explain a bit more about how you have developed the report? AlexPM
user's latest post:
How to use Currency Rate widget...
Published (2009-11-20 13:30:00)
Hi Jay - I had hoped to have something final to say about this issue but it looks like there will not be decisions made on wheter to fix the widget until after the holidays. For what it may be worth here is what I know at the moment. As you may have noticed the article "Demo of how to use the StrikeIron widget in a mashup" has been removed from the WIKI because this (what I believe you were trying) no longer works. We confirmed that...
user's latest post:
syntax for member unique names...
Published (2009-11-12 14:53:00)
I don't understand the proper syntax for specifying member names in Cognos expressions. When I look at a member unique name in Report Studio for an item in my cube (Microsoft cube) I get something like this: [Cube Name].[Time].[Month].[Month]->:[YK].[[Time]].[Month]].&[200911]]] in case the brackets get mangled by the forum, everything above up to the second occurrence of "Time" is enclosed in single brackets. Time...
user's latest post:
DB2Client does not work on...
Published (2009-11-15 09:07:00)
There are also some bugs in W7 which prevents some DB2 functions from running correctly, some DB2 W7 fixes are waiting for Microsoft until MS release appropriate W7 fixes.
user's latest post:
Crosstab measure : Not getting...
Published (2009-11-19 13:22:00)
Hello Cognos users, I have one table containing Hour and servername. Each hour have more than one server Like( 1, server1), (1,server2) (2,server2), (2,server3). I am preparing one crosstab report where Hour is at both coordinates. And I want to get count of common servers for that hour pair. For example for hour(1,1) common server are (server1, server2) so desired count = 2, for hour(1,2) common server is ( server2). So desired count = 1. I...
user's latest post:
Who uses what cube?
Published (2009-11-16 05:19:00)
Is there a way of finding what powerplay cubes are accessed and even by which users within the business. I managed to find this out once before in one of the txt/log files on our old powerplay server, but on this new installation, I cant find it...any help much appreciated. Thanks
|
|
|
Top 10 active forums on developerWorks : Information Management Forums during last week:
|
|
Top 10 forums on developerWorks : Information Management Forums:
Cognos 8
- 5,176 posts
|
IBM WebSphere Transformation Extender
- 5,013 posts
|
IBM DB2 Express Forum
- 4,265 posts
|
.NET Development with DB2, IDS and U2
- 3,623 posts
|
IBM OmniFind Enterprise Edition
- 2,964 posts
|
DB2 for Linux, UNIX, and Windows
- 2,916 posts
|
IBM WebSphere DataStage
- 2,129 posts
|
DB2 for z/OS forum
- 1,921 posts
|
DB2 for i5/OS
- 1,523 posts
|
IBM Data Studio - Design, Develop, Manage, and Govern your data
- 1,273 posts
|
|
|
|
|
Latest active threads on developerWorks : Information Management Forums:
Started 2 weeks ago (2009-11-09 09:25:00)
by repanzer
He had posted a while back that he was leaving. Then he came back for a bit, then he posted he was leaving again, and what he thought was for good. If the threads are kept that long, I'm sure you can search the forum for the post.
He was great. Extremely knowledgeable.
Started 3 days, 11 hours ago (2009-11-20 13:29:00)
by ocgstyles
Not sure which you were looking for:
select distinct job
from employee
where MF = 'F' ;
select distinct job
from employee
where MF = 'F'
and job not in (
select job
from employee
where MF = 'M'
);
Substitute MF with you know what...
HTH
Keith
Started 3 days, 17 hours ago (2009-11-20 08:02:00)
by NancyR
One of your earlier posts showed the entry in the trace file as:
(Level 2: Offset 2478, len 23, comp 1 of 33, #1, DI 00000026:)
Data at offset 2478 ('0001400000009905...') fails minimum size requirements
TYPE X'0007' (Item_Count Field Root).
WTX is seeing the data for Item_Count Field Root as 23 characters long (possibly because the next character is the record terminator). ...
Started 1 week, 4 days ago (2009-11-12 19:16:00)
by mgibson
Wow, that looks stuffed - open a case with Cognos Support.
Mick
Started 1 week, 3 days ago (2009-11-13 05:12:00)
by ianbjor
Have you tried using the universal ("jcc") driver instead? It's got both Type 2 and Type 4 drivers.
I have used it (with the Type 4 driver) to execute java apps on the mac that talk to DB2 (even before IBM released the 9.5.2 beta).
|
|
Hot threads for last week on developerWorks : Information Management Forums:
Started 4 days, 13 hours ago (2009-11-19 11:32:00)
by Angela_F
You absolutely should have the ability to edit the email body but I just tested it and it doesn't accept image tags. So I have no idea how to get an image in the body. Maybe someone else has an idea.
Started 3 days, 17 hours ago (2009-11-20 08:02:00)
by NancyR
One of your earlier posts showed the entry in the trace file as:
(Level 2: Offset 2478, len 23, comp 1 of 33, #1, DI 00000026:)
Data at offset 2478 ('0001400000009905...') fails minimum size requirements
TYPE X'0007' (Item_Count Field Root).
WTX is seeing the data for Item_Count Field Root as 23 characters long (possibly because the next character is the record terminator). ...
Started 4 days, 2 hours ago (2009-11-19 22:20:00)
by Phil W
Is this a relational model or a dimensional model?
The approach for a relational model will be to use the percentage function.
percentage( Measure )
A dimensional model can make use of a tuple function to divide the current measure value by the tuple referencing the value for the total of the set of tasks.
Measure /tuple( Measure , Column Total )
Started 4 days, 10 hours ago (2009-11-19 14:41:00)
by marichu
OK, I didn't realize you were using the Integrated Query Editor for SQL scripts. When I copied the statement into a SQL Script, I am able to reproduce your error. However, I found a sequence of actions that fixed the problems.
1) create a new script
2) right-click on opened IQE editor >Set Statement Terminator
3) Replace the default statement terminator ";" with "@". Click OK
4...
Started 3 days, 11 hours ago (2009-11-20 13:29:00)
by ocgstyles
Not sure which you were looking for:
select distinct job
from employee
where MF = 'F' ;
select distinct job
from employee
where MF = 'F'
and job not in (
select job
from employee
where MF = 'M'
);
Substitute MF with you know what...
HTH
Keith
Started 4 days, 1 hour ago (2009-11-19 23:35:00)
by gsauer
Hi,
Basically if "LocalService" is a userid, you can try something like this:
"Server=127.0.0.1:50000;Database=Mydb;UID=LocalSe rvice;PWD=XXXXXXX;"
Please, substitute the XXXXXXX for the LocalService password.
You can find more useful information in the following URL:
http://publib.boulder.ibm.com/infocenter/db2luw/v 9r7/topic/com.ibm.swg.im.dbclient.adonet.doc/doc/t 0010472....
Started 3 days, 19 hours ago (2009-11-20 05:50:00)
by HBcognos
Input Scale default was 0. We tried various scenarios with input and output scale but non of them worked. Instead the 1.78 in the datasource would be displayed 1.00 or 1000 or 0.1000
Started 4 days, 6 hours ago (2009-11-19 18:43:00)
by Stan
When do you get this exception? Server startup?
Please check the SystemOut.log and javamashuphub.log for additional information about what is happening related to this failure.
Started 3 months, 4 weeks ago (2009-07-28 09:48:00)
by RanjanTham
screen shot crosstab sub.doc
(282.0 KB)
Started 4 days, 4 hours ago (2009-11-19 21:00:00)
by Cognos_help
Hi TurkeyTodd,
Yes, it's exactly what I want. I created this PowerCube form a report (in Report Studio). This monthly report is generated from a DMR model with very low level of granularity (e.g., sales transactions of each customer every day). The Forecast is a calculated measure based on history data. After refreshing the cube at the month-end, users use this cube to re-calculate...
|
|
Size: 363 bytes
