IBM BPM, V8.0.1, All platforms > Administer the IT infrastructure > Administer Business Process Choreographer > Use scripts to administer Business Process Choreographer > Administer query tables
Retrieving the XML definitions of query tables
Use an administrative script to get the XML definition of composite and supplemental query tables in Business Process Choreographer.
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, the application server must be running. Do not use the wsadmin -conntype none option.
- If Business Process Choreographer is configured on a cluster, then at least one cluster member must be running.
- If WebSphere administrative security is enabled, and your user ID does not have operator, administrator, or deployer authority, 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.
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.
smpe_root/ProcessChoreographer/admin
In the directory:
INSTALL_ROOT/ProcessChoreographer/admin
- In the directory:
INSTALL_ROOT\ProcessChoreographer\admin
- To list the XML definition of a query table in the command prompt window.
INSTALL_ROOT/bin/wsadmin.sh –f manageQueryTable.py [ ([-node nodeName] -server serverName) | (-cluster clusterName) ] -query definition -name queryTableName
INSTALL_ROOT/bin/wsadmin.sh –f manageQueryTable.py [ ([-node nodeName] -server serverName) | (-cluster clusterName) ] -query definition -name queryTableName
INSTALL_ROOT\bin\wsadmin –f manageQueryTable.py [ ([-node nodeName] -server serverName) | (-cluster clusterName) ] -query definition -name queryTableNameWhere:
- -node nodeName
- The name of the node where Business Process Choreographer is configured. This is optional when specifying the server name. The default is the local node.
- -server serverName
- The name of the server where Business Process Choreographer is configured. This is required if a cluster is not specified.
- -cluster clusterName
- The name of the cluster where Business Process Choreographer is configured. This is required if Business Process Choreographer is configured on a cluster.
- -name queryTableName
- The name of the query table, in upper case, whose XML definition is to be listed.
Example
For example.
wsadmin.sh –f manageQueryTable.py –server server1 –query definition –name COMPANY.SAMPLE
wsadmin.sh –f manageQueryTable.py –server server1 –query definition –name COMPANY.SAMPLE
wsadmin –f manageQueryTable.py –server server1 –query definition –name COMPANY.SAMPLE
Related tasks:
Update composite and supplemental query tables
Retrieving a list of query tables
Deploying composite and supplemental query tables
Undeploying composite and supplemental query tables