Alternative Index Component Definition (CTDUFANX)

To define an alternative index component, create the special DEFALTI member with alternative index identification and key structure. The list and order of the keys should be fit to the most frequently used fields in the filter for report list request in IOA online and Control-D Web Access sessions.

The DEFALTI member should contain one ALT and one KEY statement for each alternative index.

In the component definition:

• The ALT statement defines the index letter.

  ALT=index_letter

  The specified index_letter is the alternative index identification. The letter used for the alternative index can be any letter A-Z, excluding I. The index letter is used in DDNAME field for Alternative Index Component.

• The KEY statement defines key list of alternative index.

  KEY= key_letter,start_pos,length,seq,…

  or

  KEY= (key_letter,start_pos,length[,seq]),…

  The specified key_letter is defined the key field. The possible values of key_letter are shown in Table 244.

  • start_pos is defined as the start position of the key in the field.
  • length is defined as the length of the key.
  • seq is defined as the native sequence of values in report list (A for ascending, D for descending)

    Note: Use descending sequence (D) for fields containing dates such as Order, Run, or Decollation date only.

  The keys should be defined according to the following rules:

  • The recipient name (U-key: U,1,8,A) is mandatory.
  • The maximum number of keys is 20.
  • The maximum total of key lengths is 56.

  Table 244 Alternative Index Key Fields

  Key letter	Field	Field length
  U	Recipient name	8
  N	Extended report name	50
  M	Job name	8
  J	Job id	5
  D	Order date	6
  C	Category	20
  T	Destination	8
  W	External writer	8
  F	Form	8
  S	Run date	4
  H	Decollation date	8
  Y	Remark2	20
  Z	Remark3	20
  X	User data	40

  Example 1

Implement one of the following:

Example 2a

Example 2b

Example 3