This topic applies only to the IBM Business Automation Workflow Advanced
configuration.

Retrieving the XML definitions of query tables

Use the manageQueryTable.py administrative script to get the XML definition of composite and supplemental query tables in Business Process Choreographer.

Before you begin

Before you begin this procedure, the following conditions must be met:The following conditions must be met:

Run the script in connected mode, that is, do not use the wsadmin -conntype none option.
At least one cluster member must be running.
Include the wsadmin -user and -password options to specify a user ID that has operator, administrator, or deployer authority.
If you are not working with the default profile, use the wsadmin -profileName profile option to specify the profile.

About this task

Note: You cannot use the script to retrieve the XML definitions of predefined query tables. The XML format of query table definitions is not a published interface. You cannot manually change the definition of a query table definition. To do this, load the query table definition into the Query Table Builder and apply the modifications there.

Complete the following steps to retrieve the XML definition of composite and supplemental query tables.

Procedure

Change to the Business Process Choreographer subdirectory where the administrative script is located.
- install_root/ProcessChoreographer/admin
- install_root\ProcessChoreographer\admin
To list the XML definition of a query table in the command prompt window.
Enter the following command:
```
install_root/bin/wsadmin.sh -f manageQueryTable.py
       -cluster clusterName
       -query definition 
       -name queryTableName
```
Enter the following command:
```
install_root\bin\wsadmin -f manageQueryTable.py
       -cluster clusterName
       -query definition 
       -name queryTableName
```
Where:

-cluster clusterName

The name of the cluster where Business Process Choreographer is configured. In a multicluster setup, you must specify the application cluster because that is where Business Process Choreographer is configured.

-name queryTableName

The name of the query table, in uppercase, whose XML definition is to be listed.

Example

For Linux operating system For UNIX operating system Enter the following command:

wsadmin.sh -f manageQueryTable.py -cluster myCluster 
           -query definition -name COMPANY.SAMPLE

For Windows operating system Enter the following command:

wsadmin -f manageQueryTable.py -cluster myCluster 
        -query definition -name COMPANY.SAMPLE