TCL Tips updated regularly!         Email us with specific requests!

EMAIL US

NEWSLETTER SIGNUP

REQUEST INFO

 

Home

About Us

TernoVelocity

What's New

Client News
Announcements
Updates Available
TCL Tips

Newsletter archive

Contact Us

 

 

TCL Tips




Check back often for new tips!


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


7.  TO VIEW DICTIONARIES

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 ($)

To Top

 


10.  FINDING PHRASES IN FILES

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’.

To Top

Privacy Policy ©2009 Terno & Associates, Inc.  All Rights Reserved.