Command-Block

[Cognos8]

Hi ,

I am trying to understand concept of command block. I had a look
in architechture and security document, but it was not in detail level to implement.

Anyone have expereinced to use this command block.

In datasource connection i see the below option.... how to use this for

SQL SERVER AND SYBASE.

Open connection commands
Open session commands
Close session commands
Close connection commands

My actual requirement is, i have to create the temp table in
sybase ,from cognos 8.4. which needs to be used in 5 procedure for a report. this temp table can exist only for one session. so second stored procedure could not find this temp table. To use the same session we are trying to understand the COMMAND BLOCK concept. Could any give how to use in sysbase and sqlserver with some example. Thanks in advance