What is an open session command in cognos connection?what
is it meant for?
Answer Posted / subhash
open session command is used to connect to the database to
the language defined. if i want to connect to the oracle
database with the language French then i will use the open
session command like this
<commandBlock>
<commands>
<sqlCommand>
<sql>ALTER SESSION SET NLS_LANGUAGE = FRENCH
</sql>
</sqlCommand>
</commands>
</commandBlock>
again if i want to reset my connection to the english
language then i have to use close connection command.
<commandBlock>
<commands>
<sqlCommand>
<sql>ALTER SESSION SET NLS_LANGUAGE = ENGLISH
</sql>
</sqlCommand>
</commands>
</commandBlock>
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between regular dimension and derminant?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
how you provide security to reports? How you provide security to packages ?
What r the names of the reports that you prepared?
What are the two types of framework manager?
Is it possible to join multiple Databases in a Catalog?
What is a Pivot?
Mention the difference between ‘macros’ and ‘prompt’?
---------------Tell me about DWH Concepts?
What is the function of cognos dispatcher?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
What do you mean by drill through report?
Write some methods to apply securities in framework manager model?