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
-
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.
-
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.
-
Continue adding or modifying command blocks, as needed, and then click
Finish.