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


Please Help Members By Posting Answers For Below Questions

how to test reports in cognos?

588


What are the components used in web tier?

539


Why cognos scenario is used?

582


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

1780


What is the advantage of using shortcuts?

642






What are the advantages of cognos?

574


What is cognos connection?

590


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

591


Cleared COG-112 with 100% score today. What next certification should i go for?

1416


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..

1754


What do you mean by query studio?

514


what is requery in cognos?

2068


What are all the advantages of Cognos?

636


Explain the characteristics of cognos?

609


What are the steps to import the two data sources in framework manager?

614