Answer / thanjairajan@gmail.com

The WITH clause may be processed as an inline view or resolved as a temporary table. The advantage of the latter is that repeated references to the subquery may be more efficient as the data is easily retrieved from the temporary table, rather than being requeried by each reference.

For example:

WITH dept_count AS (
SELECT deptno, COUNT(*) AS dept_count
FROM emp
GROUP BY deptno)
SELECT e.ename AS employee_name,
dc.dept_count AS emp_dept_count
FROM emp e,
dept_count dc
WHERE e.deptno = dc.deptno;

Answer / krishna

Specifies whether to send a request to the database using
an SQL WITH clause. When set to Yes, and if the database
supports WITH clauses, a WITH clause request is generated.
When set to No, or if the database does not support WITH
clauses, a request using derived tables is generated

we have package it contain Query subject (123456). If u generate report with 6 query subject error will occure how to resolve this problem

1 Answers   IBM,

---

What are various types of gateways in cognos?

0 Answers  

---

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

0 Answers  

---

wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container

0 Answers  

---

how u publish the packages in framework manager

3 Answers   TCS,

---

Wht is difference between content store and content manager?

2 Answers   Satyam, Tech Mahindra,

---

..Architectural difference between cognos reportnet and cognos8?

3 Answers  

---

What is the difference between the standard and metrics folder?

0 Answers  

---

i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?

1 Answers   JPMorgan Chase,

---

what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us

0 Answers   HCL,

---

What snowflake and Starschema?

2 Answers   HCL,

---

what is stitch query?

2 Answers   Syntel,

---