Search results for query: *

Hi Techies, We have a requirement in getting a customer count in the cube using IBM DB2 OLAP Server which is not an additive measure. Has somebody worked on how to load data in all levels of the cube and not to be calculated. We have a solution by having defined the dimensions as parent/child...

Hi All, We need to know, for the cube building functionality which software provides the better feature. Is it db2 olap server or Cognos Transfornmer. Customer count is one of the requirement, for which we tried to use cognos transformer and IBM DB2 OLAP Server. I found that congos...

Hi All, I found that Cognos transformer will be best fit for our requirement of customer count than IBM DB2 OLAP Server as they have a built in feature to count for no. of customers (Unique and non unique). To acheive the functionality of a unique or distinct customer count, we created a...

Hello Techies I need a certain input on how to invoke a java stored procedure from the data ware house center in db2. I'll write down the steps I did and the place I got stuck. 1. I created a java stored procedure using IBM DB2 Stored procedure builder. Executed successfully 2. Created a...

Hello Techies, I need a certain input on how to invoke a java stored procedure from the data ware house center in db2. I'll write down the steps I did and the place I got stuck. 1. I created a java stored procedure using IBM DB2 Stored procedure builder. Executed successfully 2. Created...

You cannot query in a single sql in two databases in db2 unless you use IBM DB2 Data Joiner software HTH GK

Try using describe select * from the tablename. Gives you column names and also the description of each column Hope this helps Gk

Hi, Here is a sample query which will get the altest of two dates. The table used is employee table on sample database. Hope this helps. DB2 "WITH TEMP AS (select case when (hiredate > birthdate) then 0 else 1 end as value from employee where empno = '000010') SELECT CASE VALUE WHEN 0...

Hello Techies I need a certain input on how to invoke a java stored procedure from the data ware house center in db2. I'll write down the steps I did and the place I got stuck. 1. I created a java stored procedure using IBM DB2 Stored procedure builder. Executed successfully 2. Created a...

hi, Either you need to connect to db2 using your command window or you can insert the statement on top of all sql statement as "connect to sample user db2admin using db2admin" where sample is ur db name and db2admin being ur user id and password. next in your command window, change...