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

How do we create Links & Segments in Cognos Framework Manager?

1 Answers  


Can you define confirmed dimension?

0 Answers  


What's the differance between each studio in cognos 8?

1 Answers   TCS,


What is content store?

1 Answers   HCL,


If anyone has COG-185 IBM Cognos 8 Migration Professional Certification Dump, please mail me at: sushma_biswas@yahoo.com

1 Answers   EDS,






how can you create a project creation

0 Answers   HSBC,


It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

0 Answers  


What is defined as Cognos Impromptu?

0 Answers  


what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.

2 Answers  


Can any one give the example for slicing and dicing of data ?(with simple query)

3 Answers   Cognos,


Any Cognos planning Queries Rise

5 Answers  


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

2 Answers   Infosys, Wipro,


Categories