 |
|
||||||||||||||||||
Subscription Definitions - Creating and MaintainingGeneral InformationThis maintenance function is used to set up a subscription definition. A subscription definition is a database expression producing a select group of subscriber names based on several different parameters. When you run subscriptions using the Select Names by Subscription Definition option of the List Management Module, you can run more than one subscription definition simultaneously. See Also Subscription Definition Examples How to Use the FunctionAdding a New DefinitionComplete the fields as required. See the field definitions below. Modifying an Existing DefinitionModify the fields as required. See the field definitions below. Field Definitions for the Subscription Definition Information screen These fields establish the parameters for the database extract and format. Most of the fields are XBASE command sequences. Refer to the Subscription File Structure. DEFINITION CODE - the code/name of the Subscription Definition. DESCRIPTION - the description of the Subscription Definition. SELECT CRITERIA - this is the XBASE expression that determines which subscriber records to select. Press the BUILD button to display the Expression Builder to help you build the XBASE expression. The statements that you typically use when creating a subscription definition include a publication code (to identify the magazine) and exclude those subscriptions that are currently "on hold" as specified in the Subscription Information Record Screen. Here's an XBASE expression that identifies the magazine and eliminates subscriptions on hold. PUB_CODE="XX" .AND. .NOT. ON_HOLD (Where XX = the publication code) Replace Statements The replace statements that you include in your subscription definition update the subscription information for the subscribers who are included in the SELECT CRITERIA. There are several categories of replace statements.
Note: The Mailing Date and Mailing Issue fields are updated when "Update Subscriptions" is selected in the Select Names by Subscription Definition option in the List Management Module based on your replace statements for these fields. See Subscription Definition Examples for sample replace statements. For Column This column enables you to establish a special condition just for that one single replace statement. For example, if you want do not want to reduce the issue count for "complimentary" subscriptions, you would add an extra condition like the following: LAST_ITEM<>"COMPLIMENTARY" |