ENGLISH Statements
What type of word do all ENGLISH Statements begin with?
VERB
What prompt indicates that I am in the EDITOR?
.
What is attribute 1 of a DICT Item?
A or S
What EDITOR command deletes the current attribute?
DE
What command would I enter to delete the PEOPLE file?
DELETE-FILE PEOPLE
What ENGLISH statement would I run to output the number of data items in the CAR-INV file?
COUNT CAR-INV
What EDITOR command would I run to replace the first space with the letter 'A'?
How many DICT items can look at attribute 2 on the data level?
Unlimited
What EDITOR command will always exit without saving and return to the TCL prompt?
EXK
What function and logon allow did we use to review a user's access levels on the system?
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
What would the following EDITOR command accomplish:
RU./..
or
Remove all "/" from the current attribute
What is Attribute 2 of a DICT item?
The Attribute number that the DICT item looks at on the DATA level
What EDITOR command deletes the current item but does not exit to the TCL prompt?
FD
What does a Q Pointer do?
Allows you to view files on other accounts without wandering to them.
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
What single EDITOR command inserts and attribute with a value of RED?
I RED
What command would I enter to create a new DICT item named shark in the BABY file?
ED DICT BABY SHARK
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"?
What 4 prompts did we learn this week and what does each indicate?
: - TCL
. - EDITOR
> - SELECT
$ - Linux
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
Provide three EDITOR commands to null an attribute
RU/^// or R/^//* or TR//
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.
What EDITOR command adds the letters "ING" at the end of the next 5 attributes?
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 ""