1.  Selecting customers with a specific purchase history
2.  Finding customers with specific criteria
3.  List inventory records matching a specific criteria
4.  Selecting records from a file
5.  To suppress detail from a TCL statement
6.  To suppress record IDs in a TCL statement
7.  To view dictionaries
8.  Using your Stacker
9.  Counting records in your files
10.  Finding phrases in files

1. SELECTING CUSTOMERS WITH A SPECIFIC PURCHASE HISTORY

Mentor Pro/Universe Command:
>LIST CUST.HIST WITH 3 EQ "XXXX"

Example:  >LIST CUST.HIST WITH 3 EQ "8181" AND WITH 3 EQ "7632"

Lists customers who have purchased both items 8181 and 7632.

To Top

2.  FINDING CUSTOMERS WITH SPECIFIC CRITERIA

Mentor Pro/Universe Command:
>>LIST CUST WITH 

Example:  >>LIST CUST WITH LIFETIME >= "1000" TRANSCOUNT

Lists customers who have a lifetime transaction value greater than or equal to $1000 with the number of transactions.

Note:  Dictionaries vary from system to system.  Your particular system may not have this corresponding dictionary.  Check with your Terno programmer.

To Top

3.  LIST INVENTORY RECORDS MATCHING A SPECIFIC CRITERIA

Mentor Pro/Universe Command:
>>LIST INV WITH

Example:  >>LIST INV WITH QAV<= "0" AND WITH PO QTY = ""

This command would list Inventory with a Quantity Available equal to or less than 0 and with no open purchase orders.

To Top

4.  SELECTING RECORDS FROM A FILE

Mentor Pro Command: >SAMPLE
    Example: >SAMPLE CUST (3

Universe Command: >SELECT
    Example: >SELECT CUST (3

Selects 3 Customers from file

To Top

Mentor Pro/ Universe Command: DET-SUPP

Example: >SORT CUST TOTAL 25 DET-SUPP

Displays merchandise total suppressing detail

To Top

Mentor Pro /Universe Command: ID-SUPP

Example: >SORT CUST BY 1 1 ID-SUPP

Sorts and displays customer by last name not showing record IDs.

To Top

Mentor Pro /Universe Command: >LIST DICT

Example: >LIST DICT CUST

Lists customer file dictionary which can be used in the TCL statement

To Top