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
how to test reports in cognos?
What are the components used in web tier?
Why cognos scenario is used?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
What is the advantage of using shortcuts?
What are the advantages of cognos?
What is cognos connection?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Cleared COG-112 with 100% score today. What next certification should i go for?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
What do you mean by query studio?
what is requery in cognos?
What are all the advantages of Cognos?
Explain the characteristics of cognos?
What are the steps to import the two data sources in framework manager?