Chapter 14. Report distribution 327
Figure 14-10   Building the SQL query
Additionally, users can specify a wildcard with a substring in the SQL statement. On 
execution, ODF will substitute the correct portion of the recipient or recipient list name.
The format of the wildcard is shown:
/SM590000$ODF_RECIPIENT(start pos:length) where start pos is the number of the characters to 
start and length is the number of characters to use. (start pos:length) is optional.
/SM590000$ODF_RECIPLIST(start pos:length) where start pos is the number of the characters to 
start and length is the number of characters to use. (start pos:length) is optional.
Job Name, Location, Dataset Name, and Print Options
These fields can be used to override the values that are specified in the distribution definition. 
Use this capability to specify the values at the distribution level that apply to most of your 
report bundles and still customize for individual report bundles.
14.3  Defining the objects by using batch administration 
ARSXML provides a batch interface to add, update, delete, or export a list of ODF objects. 
We show the arsxml command and a sample XML file that is used to create each of the 
objects that we added earlier.
14.3.1  Recipient
Run the following command to add a recipient:
Arsxml add -h myod -u myuser -p mypwd -v -i /recipientAdd.xml
Example 14-1 on page 328 shows the content of our example recipientAdd.xml file.