Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?

2 Answers   IBM,


write a query to display the third record from the employee table?

4 Answers   HCL,


--------------How to do Report Testing in Reports?

1 Answers   IBM,


In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,

2 Answers   Tech Mahindra,


what is a Galaxy Schema?

2 Answers   IBM,


Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

1 Answers   HSBC,


Explain the Difference Between Bursting and Scheduling?

1 Answers  


What is meant by Tabular SQL in Cognos Report net

3 Answers   Infosys,


Hi, How the relations will be exists in DMR models if u have any idea please explain me

2 Answers   Polaris,


what is view? types of views?

3 Answers   HCL,


if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?

2 Answers   CTS,


What is the difference between drill through, drill across?

0 Answers  


Categories