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

Where do you edit cognos sql in report studio?

3 Answers   HCL,


What are the two types of framework manager?

0 Answers  


hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........

1 Answers  


How do add dynamic titles in PP?

3 Answers  


Can you define metrics designer?

0 Answers  






1)what is the use of Deployement and Scheduling? 2)If you have a prompt in your report , after scheduling the report will it run? 3)How can we move our reports from one Environment to Another Environment? 4)What is the complex report in your project and whar are the critical issues have u faced in u r reports and tell me name of some recent reports have u created? 5)What are the limitations of value prompts?

2 Answers   IBM,


pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com

1 Answers  


-----------With out using DrillThrough how to do Reports?

0 Answers   IBM,


How applying "Level Span" in Cognos 8.3?

1 Answers  


What is Correlated sub-query? Please explain

1 Answers   Target,


------------- How to identify the Revenue Column in Report?

0 Answers  


is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)

2 Answers  


Categories