ENGLISH Statements
EDITOR
DICT Items
MORE EDITOR
Potpourri
100

What type of word do all ENGLISH Statements begin with?

VERB

100

What prompt indicates that I am in the EDITOR?

.

100

What is attribute 1 of a DICT Item?

A or S

100

What EDITOR command deletes the current attribute?

DE

100

What command would I enter to delete the PEOPLE file?

DELETE-FILE PEOPLE

200

What ENGLISH statement would I run to output the number of data items in the CAR-INV file?

COUNT CAR-INV

200

What EDITOR command would I run to replace the first space with the letter 'A'?

R/ /A
200

How many DICT items can look at attribute 2 on the data level?

Unlimited

200

What EDITOR command will always exit without saving and return to the TCL prompt?

EXK

200

What function and logon allow did we use to review a user's access levels on the system?

ADP UUP
300

What ENGLISH statement would I run to output a report from the MUSIC file displaying the name and style of the musicians?  I do not want the ITEM-ID in my report. 

LIST MUSIC NAME STYLE ID-SUPP

or

SORT MUSIC NAME STYLE ID-SUPP

300

What would the following EDITOR command accomplish:

RU./..

Replace all "/" within the current attribute with null

or

Remove all "/" from the current attribute

300

What is Attribute 2 of a DICT item?

The Attribute number that the DICT item looks at on the DATA level

300

What EDITOR command deletes the current item but does not exit to the TCL prompt?

FD

300

What does a Q Pointer do?

Allows you to view files on other accounts without wandering to them.

400

What ENGLISH statement would I run to output a report from the CAR-DESC file displaying the first three attributes of CAR-DESC in order?  The list must be sorted by the second attribute.

SORT CAR-DESC BY *A2 *A1 *A2 *A3

or 

LIST CAR-DESC BY *A2 *A1 *A2 *A3

400

What single EDITOR command inserts and attribute with a value of RED?

I RED

400

What command would I enter to create a new DICT item named shark in the BABY file?

ED DICT BABY SHARK

400

What command would I enter at the first attritbute of an item to replace the first period of all attributes in the item with a "0"?

R999/./0/
400

What 4 prompts did we learn this week and what does each indicate?

: - TCL 

. - EDITOR

> - SELECT

$ - Linux

500

What ENGLISH statement would I run to total the CREDIT limit of all NAME-FILE records with N-CD equal to 4, sorted by NAME, and outputting name, city, state, zip, and credit limit?  Ensure that this report only shows records from Ohio, but split the report up by City.

SORT NAME-FILE WITH N-CD = "4" AND WITH STATE = "OH" BY NAME NAME BREAK-ON CITY STATE ZIP TOTAL CREDIT

500

Provide three EDITOR commands to null an attribute

RU/^// or R/^//* or TR// 

500

If attribute 3 of a DICT item is "ADDRESS' and attribute 10 is "30", what do I know will occur if I use this DICT item as an output field in an ENGLISH statement?

The report heading will be "ADDRESS" and the length of the field will be 30 characters.

500

What EDITOR command adds the letters "ING" at the end of the next 5 attributes?

AP5/ING
500

What select statements would I run to select a list of NAME-FILE records that have a tax exempt number, then select that list for customers that are parts or service customers?

SELECT NAME-FILE WITH TAX-EXEMPT-NO NE ""

SELECT NAME-FILE WITH PARTS-CUST NE "" OR WITH SMS-CD NE ""