What is an open session command in cognos connection?what
is it meant for?
Answer / 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 |
What are Governer Settings?
what is symmetric key?where do u use this?
When we use consume in cognos?
How to Reset Pagenumbers in one report.
we have package it contain Query subject (123456). If u generate report with 6 query subject error will occure how to resolve this problem
What is Local Cache and how does it help in performance tuning
What is the difference btw reportnet - Report studio and cognos 8 - Report studio
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt
what is Governor settings in cagnos?
What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.
Can you define framework manager?
Can i apply drill through on master detail relationship report?