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
5. TO SUPPRESS DETAIL FROM A TCL STATEMENT
Mentor Pro/ Universe Command: DET-SUPP
Example: >SORT CUST TOTAL 25 DET-SUPP
Displays merchandise total suppressing detail
To
Top
6. TO SUPPRESS RECORD IDs IN A TCL STATEMENT
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
8.
USING A STACKER
A stacker is a storage place for the most
recent 20 commands executed by your port at TCL.
TO LIST YOUR STACKER
Mentor Pro/Universe Command: >.L
Example
of a stacker:
01 LIST INV 1
02 LIST CUST 1 2
03 GET-LIST TEST.INV
04 SELECT CUST WITH 3 = 44512
....
TO EXECUTE AN ITEM ON YOUR STACKER
Mentor Pro/Universe Command: >.X<number>
Example:
>.X2
This example would repeat the command specified on line number
2 of your stacker. Using the above example, this would
do this LIST CUST 1 2.
To
Top
9. COUNTING RECORDS IN YOUR FILES
Mentor Pro/Universe Command: COUNT
Example: >COUNT INV 5 >= 500
Counts inventory records with attribute 5 (cost) greater than or equal to 500 ($)
Mentor Pro Command: >FIND Name.of.file "YOUR PHRASE"
Universe Command: >FIND Name.of.file <enter> string: "YOUR PHRASE"
Example:
>FIND CUST.MESSAGE "PROBLEM" (MP)
>FIND CUST.MESSAGE string "PROBLEM" (UV)
This would find all customer messages which find any occurance of ‘problem’.