Adding or modifying command blocks for a connection

You can add, change, or remove command blocks for specific data source connections.

Connections acquire properties from their parent data source. If you add a command block for a data source, that command block is available to all connections for that data source.

Procedure

  1. On the Configuration tab in Cognos Administration, choose one of the following options:
    • Access the data source properties if you want to modify the command blocks for all connections that this data source has.
    • Access the data source connection properties if you want to modify the command blocks for one connection.
  2. Click the Connection tab, and in the Commands section, perform one of the following tasks:
    • To add the command block, click Set for one of the available command types and paste the XML code for the command block in the XML database commands box.
    • To modify a command block, click Edit for the selected command and modify or remove the XML code for the command block from the XML database commands box.

    You can reset command blocks by selecting the Reset to parent value or Clear check boxes.

    Tip: For IBM® Db2® or Microsoft SQL Server, you can add command blocks only for opening a session.
  3. Continue adding or modifying command blocks, as needed, and then click Finish.