Adding command blocks while creating a data source

You can add command blocks when you create data sources.

By default, connections acquire properties from the parent data source. You can modify individual connections later.

Procedure

  1. On the Configuration tab in Cognos Administration, start creating a data source for a database that supports command blocks.
  2. In the specify commands page, click Set next to the command that you want to specify.
  3. In the set command page, add the XML code for the command block, and click OK.
    Tip: For IBM® Db2® or Microsoft SQL Server, you can add a command block only for opening a session.
  4. Continue adding command blocks, as needed, and then click Finish.