HELP 1 QUERY LANGUAGE COMMANDS 1 CREATE STORE A PROCEDURE BY NAME IN A 'FMGR' FILE DEFINE NAMES DATA-BASE AND SELECT-FILE DESTROY DELETES A PROCEDURE FILE DISPLAY DISPLAYS A PROCEDURE FILE EXECUTE SCHEDULE A PROGRAM TO BE RUN FROM QUERY EXIT TERMINATE QUERY SYSTEM FIND SECECT RECORDS FROM DATA-BASE FORM DISPLAY DATA-BASE SETS AND ITEMS HELP INVOKE HELP PROCESSOR LIST CHANGE LIST LOGICAL UNIT REPORT GENERATE A REPORT UPDATE ALTER DATA-BASE ITEMS 1 FOR MORE INFORMATION ENTER HELP HELP OR HELP 'COMMAND NAME' 1 %% HELP HELP 1 FUNCTION - THE HELP COMMAND PROVIDES FUNCTION, SYNTAX, AND OPERAND INFORMATION ON COMMANDS 1 SYNTAX - HELP 'COMMAND NAME' FUNCTION SYNTAX OPERANDS ALL 1 REQUIRED - NONE DEFAULTS - ALL IF FUNCTION, SYNTAX, OR OPERANDS NOT SPECIFIED NOTE - IF HELP IS ENTERED WITHOUT ANY OPERANDS A LIST OF AVAILABEL COMMANDS WITH A SHORT DESCRIPTION OF EACH WILL BE DISPLAYED 1 SYNTAX INTERPRETATION - 1. USER SUPPLIED VALUES ARE IN APOSTROPHES. TWO SETS OF APOSTROPHES MEANS THE VALUE SHOULD BE SUPPLIED WITHIN A SET OF QUOTES (") 2. WORDS WITHOUT APOSTROPHES ARE TO BE ENTERED AS SHOWN 3. COMMAS ARE TO BE ENTERED AS SHOWN 4. EXCLUSIVE CHOICES ARE INDICATED BY SLASH (/) 5. KEYWORDS SEPARATED BY ONE OR MORE BLANKS 1 OPERANDS - 'COMMAND NAME' - NAME OF THE COMMAND TO BE EXPLAINED FUNCTION - FUNCTION IS TO BE DISPLAYED SYNTAX - FORMAT IS TO BE DISPLAYED OPERANDS - OPERAND DESCRIPTION IS TO BE DISPLAYED ALL - FUNCTION, SYNTAX, AND OPERAND DESCRIPTIONS ARE TO BE DISPLAYED 1 NOTE - THE ABOVE KEYWORDS MAY BE ABBREVIATED BY ITS FIRST TWO CHARACTERS 1 %% HELP EXECUTE 1 FUNCTION - THE EXECUTE COMMAND ALLOWS THE USER EXECUTE A PROGRAM FROM QUERY. THIS COULD BE USED TO SCHEDULE THE 'EDITR' TO EDIT A PROCEDURE OR TO SCHEDULE THE FILE MANAGER TO CREATE A SELECT-FILE. 1 SYNTAX - EXECUTE [ = 'PROGRAM NAME']; 1 OPERANDS - 'PROGRAM NAME' IS THE NAME OF THE PROGRAM TO BE SCHEDULED. THE PARAMETERS FROM THE :RU,QUERY,X,Y ARE PASSED TO THE PROGRAM BEING SCHEDULED. WHEN NO NAME IS SPECIFIED DEFAULT IS 'EDITR'. 1 %% HELP CREATE 1 FUNCTION - THE CREATE COMMAND IS USED TO STORE A FIND, REPORT OR UPDATE PROCEDURE BY A SPECIFIC NAME INTO A FMGR DISC FILE. 1 SYNTAX - CREATE NAME = 'PROCEDURE NAME';'PROCEDURE SPECIFICATION' 1 OPERANDS - 'PROCEDURE NAME' - 1 TO 6 CHARACTER STRING 'PROCEDURE SPECIFICATION' - FIND, UPDATE, OR REPORT PROCEDURE 1 %% HELP LIST 1 FUNCTION - THE LIST COMMAND ALLOWS THE LIST LOGICAL UNIT TO BE CHANGED TO THE DESIRED OUTPUT DEVICE. 1 SYNTAX - LIST='LOGICAL UNIT NUMBER OF OUTPUT DEVICE'; 1 OPERANDS - 'LOGICAL UNIT NUMBER OF OUTPUT DEVICE' - INTEGER NUMBER. 1 %% HELP DEFINE 1 FUNCTION - THE DEFINE COMMANDS DEFINES THE DATA-BASE AND THE WORK FILE (SELECT-FILE) 1 SYNTAX - DATA-BASE = 'DATA-BASE NAME'/ SELECT-FILE = 'DATA FILE NAME' 1 OPERANDS - 'DATA-BASE NAME' - 1 TO 5 CHARACTER STRING 'DATA FILE NAME' - 1 TO 6 CHARACTER STRING NAMING A RTE FMGR ASCII DISC FILE. 1 %% HELP DESTROY 1 FUNCTION - THE DESTROY COMMAND WILL DELETE A STORED PROCEDURE FROM THE DISC.(PURGE) 1 SYNTAX - DESTROY NAME = 'PROCEDURE NAME' 1 OPERANDS - 'PROCEDURE NAME' - 1 TO 6 CHARACTER STRING 1 %% HELP DISPLAY 1 FUNCTION - THE DISPLAY COMMAND WILL DISPLAY A STORED PROCEDURE FILE. 1 SYNTAX - DISPLAY NAME = 'PROCEDURE NAME' 1 OPERANDS - 'PROCEDURE NAME' - 1 TO 6 CHARACTER STRING 1 %% HELP EXIT 1 FUNCTION - THE EXIT COMMAND CAUSES IMMEDIATE TERMINATION OF THE QUERY SYSTEM 1 SYNTAX - EXIT 1 OPERANDS - NONE 1 %% HELP FORM 1 FUNCTION - THE FORM COMMAND WILL DISPLAY A LIST OF DATA-SET AND DATA-ITEM NAMES ALONG WITH THE ITEM LENGTH 1 SYNTAX - FORM 1 OPERANDS - NONE 1 %% HELP REPORT 1 FUNCTION - THE REPORT COMMAND WILL GENERATE A REPORT USING THE DATA RECORDS FOUND 1 SYNTAX - REPORT 'REPORT PROCEDURE' END/ NAME = 'PROCEDURE NAME'[,] ALL[,'CHAR'] 1 OPERANDS - 'REPORT PROCEDURE' - CONSIST OF ONE OR MORE OF THE REPORT STATEMENT TYPES 1. DETAIL 2. EDIT 3. GROUP 4. HEADER 5. SORT 6. TOTAL 'PROCEDURE NAME' - 1 TO 6 CHARACTER PROCEDURE NAME STORED IN A RTE FMGR DISC FILE. - ANY ASCII CHARACTER WILL LIST REPORT PROCEDURE DEFAULT: NO LIST ALL - LISTS ALL FOUND RECORDS WITHOUT ANY FORMATTING 'CHAR' - ANY ASCII CHARACTER - WILL LIST ALL FOUND RECORDS WITHOUT ANY FORMATTING OR DATA-ITEM NAME 1 %% HELP FIND 1 FUNCTION - THE FIND COMMAND WILL RETRIEVE DATA RECORDS FROM THE DATA-BASE AS SPECIFIED IN THE FIND STATEMENT 1 SYNTAX - FIND 'RETRIEVE PROCEDURE' END/ NAME = 'PROCEDURE NAME' 1 OPERANDS - 'RETRIEVE PROCEDURE' - CONSISTS OF 'DATA ITEM NAME' 'RELATIONAL OPERATOR''DATA ITEM PHRASE' 'LOGICAL CONNECTOR' 'PROCEDURE NAME' - 1 TO 6 CHARACTER PROCEDURE NAME STORED IN SPEC-FILE 'DATA ITEM NAME' - 1 TO 6 CHARACTER STRING 'RELATIONAL OPERATOR' - IS/IE/ISNOT/INE/ILT/ INLT/IGT/INGT 'DATA ITEM PHRASE' - ''DATA ITEM VALUE'' 'LOGICAL CONNECTOR' - AND/OR 1 %% HELP UPDATE 1 FUNCTION - THE UPDATE COMMAND ALLOWS THE USER TO ALTER DATA-BASE ITEMS BY DELETING, REPLACING, OR ADDING 1 SYNTAX - UPDATE 'UPDATE PROCEDURE' END/ NAME = 'PROCEDURE NAME' 1 OPERANDS - 'UPDATE PROCEDURE' - 'UPDATE STATEMENT' 'PROCEDURE NAME' - 1 TO 6 CHARACTER PROCEDURE NAME STORED AN RTE FMGR DISC FILE. 'UPDATE STATEMENT' - 'ADD STATEMENT'/ 'DELETE STATEMENT'/ 'REPLACE STATEMENT' 'ADD STATEMENT' - A,'DATA SET NAME' 'DELETE STATEMENT' - K 'REPLACE STATEMENT' - R,'DATA ITEM NAME'=''VALUE'' 'DATA SET NAME' - 1 TO 6 CHARACTER STRING 'DATA ITEM NAME' - 1 TO 6 CHARACTER STRING ''VALUE'' - CHARACTER STRING 1 %% **