Add Command Blocks While Creating a Data Source

You add command blocks using the connection wizard.

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

Procedure

  1. Create a data source, choosing Oracle, IBM DB2, or one of the Microsoft SQL Server data sources as the data source type. For more information, see Oracle Data Sources, DB2 Data Sources and Microsoft SQL Server Data Sources.
  2. Click Next.
  3. In the specify commands page, click Set next to the command string that you want to specify.
  4. In the set command page, add an XML command block, and click OK.

    Note: If you are using DB2 or Microsoft SQL Server, you can only add commands block for opening a session.

  5. Continue adding command blocks, as required.
  6. Click Finish.
Parent topic: Passing IBM Cognos Context to a Database