What is an open session command in cognos connection?what
is it meant for?



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

Post New Answer

More Cognos Interview Questions

what is the different between primarykey and surrogated key.. why we are going for surrogatekey...

1 Answers  


What is the abrevation of .PPR? (Power play report) or anything new?

1 Answers  


What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....

4 Answers  


What is a dashboard in Cognos Report Studio and how do we creae it

2 Answers  


What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?

0 Answers   IBM,






Mail me at: Amit_Cog@yahoo.com for a Very latest COGNOS 8 Certi Dumps like COG-112, COG-122, COG-125, COG-132, COG-142, COG-145 I scored Full Score, if anyone need it, just drop me a mail with Code

8 Answers  


Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!

2 Answers  


first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.

1 Answers  


HI,can one suggest best institute for cognos Training in Hyderabad

14 Answers  


i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..

1 Answers  


Can you define materialized view?

0 Answers  


what is an outer join? difference between left outer join right outer join with an example?

1 Answers   HCL,


Categories