Report studio has two SQL tabs one native SQL and another
one cognos SQL which one is get more preference? which one
we need to consider?
Answer Posted / satyabadi
(1)The FWM uses cognos SQL as a default SQL to create and
edit query subjects.
(2)cognos sql supports SQL 99 standards, which are used in
modifying the query subjects.
Where as
(1) The native SQL is the SQL the database uses such as
oracle,sql secver etc.
(2) A cognos query definition engine (QDE) convert the
cognos SQL into a native SOL which will be submitted to the
data source to query the data.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is called cognos reporting tool?
Can you define materialized view?
What are all the different types of prompt in cognos?
how to merge 2 crosstabs thans
How to create model and how to test model?
Please explain the different stages in creating a report in cognos report net?
What are the components of the report studio?
Explain about scorecarding?
What do you understand by the cognos?
what is stitch query in reportnet?
Define catalog in cognos and write its various types?
What are the different types of reports present in cognos?
hi my name is siraj i want to know cognos queriy language
Write types of folders present in cognos?
Can you define query studio?