ddlInvertIndex() Examples

ddlInvertIndex() Examples
ddlInvertIndex() Examples

Example 1: Invert Index for Customers.CustomerID
First you need to determine the data type of the index column; and you need to determine the size of the target table. These things can be done programatically; but to maintain the focus, we will bypass those intermediate steps.

   SET %DataType = 'X(6)'
   SET %TableSize = '100'
   SET %TableName = 'CustTemp'
   SET %ColumnName = 'CustID'
   CREATETEMPTABLE/D {%TableName} "Data Base Name Is {%TableName} // -
      TD {%TableName} {%TableSize} records temp // -
         {%ColumnName} {%DataType} //
   WRITE/C{%TableSize} A {%TableName} {%ColumnName} = ' '
   INVERT Customers.CustomerID {%TableName} {%ColumnName}