PC Treasures, Inc.

home *** CD-ROM | disk | FTP | other *** search

/ PC Treasures, Inc. / pctreasures.mdf / WINDOWS / adabas / f_0001 / env / easy1.enh < prev next >

Wrap

Text File | 1999-11-01 | 71KB | 816 lines

ENG|03 | 0 EASY1.enh 10.05.01 1998-04-24 ENG|03 | 1| | E A S Y - G L O B A L H E L P (2nd help level) ENG|03 | 3| | The following will give you an overview of the EASY functionality, ENG|03 | 4| | ordered by chapters. ENG|03 | 6| M| - the #05HELP function ENG|03 | 7| M| - selecting an #01EASY function ENG|03 | 8| M| - #02selecting a table or view ENG|03 | 9| M| - #04re/defining a table or view ENG|03 | 10| M| - showing, updating, inserting, or deleting #03database^entries ENG|03 | 11| M| - setting #06options ENG|03 | 12| M| - exporting, importing, deleting #07forms/requests ENG|03 | 13| I| - ##04ADABAS^editor description ENG|03 | 15| | For the terms highlighted within the help text further subchapters are ENG|03 | 16| | available. These will provide you with detailed information about the ENG|03 | 17|S | respective term. ENG|03 | 19| | To select a subchapter, position the cursor on the desired term and ENG|03 | 20| | restrike the HELP key. ENG|03 | 22| | PREV returns you to the previous screen, whereas END-HELP allows you to ENG|03 | 23| | leave HELP. In this way you may retrieve the available information bit by ENG|03 | 24|R | bit. ENG|0301 | 1| | C A L L I N G A F U N C T I O N ENG|0301 | 3| | Generally you have two possibilities of calling an EASY function: ENG|0301 | 5| | - You press one of the function keys displayed in the function menu. ENG|0301 | 7| | - You specify the name of the function that you wish to call in the field ENG|0301 | 8| | "Function: ......". You can find this name in the function menu. You ENG|0301 | 9| | may use either upper or lower case characters, and you may abbreviate ENG|0301 | 10| | the function name to any extent, as long as it remains unique. ENG|0301 | 12|R | When you then press the enter key, the function will be performed. ENG|0302 | 1| | S E L E C T I N G A T A B L E / V I E W ENG|0302 | 3| | When starting, EASY displays a selection menu that shows all existing ENG|0302 | 4| | tables and views that you are allowed to access. ENG|0302 | 6| | If you want to process (request, alter) a table, specify the name or ENG|0302 | 7| | number of this table in the input field Table: ................ You may ENG|0302 | 8| | also select the desired table by placing the cursor on the table name in ENG|0302 | 9| | the menu. ENG|0302 | 11| | If you want to create a new table/view not yet included in the menu, ENG|0302 | 12| | specify the name that is to be given to the new table/view in the input ENG|0302 | 13| | field (18 letters/numbers at the most; the first character must be a ENG|0302 | 14| | letter) and press the ADMIN key. ENG|0302 | 16| | To have also the tables and views displayed that other users made ENG|0302 | 17|S | available to you, specify the pattern "*.*" in the input field ENG|0302 | 19| | Table: ............... ENG|0302 | 21| | If the selection menu is not clearly arranged because of the great number ENG|0302 | 22| | of tables and views, then you may have a subset of these tables ENG|0302 | 23| | displayed. For this purpose specify a pattern which the desired table ENG|0302 | 24| | names are to begin with in the field Table: ................ ENG|0302 | 26| | Example: ENG|0302 | 28| | Table: hotel*.......... e.g. displays the tables HOTELDESCRIPTION, ENG|0302 | 29| | HOTELBOOKING, HOTELBILLING. ENG|0302 | 31| | Table: miller.*......... displays all tables and views of the user ENG|0302 | 32| | MILLER you are allowed to work with. ENG|0302 | 34|R | Important: The asterisk may only occur at the end of this pattern !! ENG|0303 | 1| | P R O C E S S I N G T A B L E S / V I E W S ENG|0303 | 3| | This mode will provide you with a blank form (request form) ENG|0303 | 4| | for the table/view specified in the table selection menu. ENG|0303 | 6| | This form enables you to ... ENG|0303 | 8| M| ...have all or some selected values #01displayed that comply with a ENG|0303 | 9| | particular pattern. ENG|0303 | 10| M| ... #03enter new values to or #04update existing values in or #05delete ENG|0303 | 11| | existing values from your database table. ENG|0303 | 12|RM| ...to have the results displayed in #02tabular^format. ENG|030301 | 1| | R E Q U E S T P A T T E R N ENG|030301 | 3| | To search entries in a table, you have the following possibilities: ENG|030301 | 5| | - You specify a single value for a form field. As the result you will ENG|030301 | 6| | receive all entries in the table which have exactly that value in the ENG|030301 | 7| | corresponding column. ENG|030301 | 9| M| - You specify a #11selection^operation, e.g.: value....: > 10 . ENG|030301 | 11| | Information is available about the following operations: ENG|030301 | 13| M| #01equal^to #02not^equal^to #03less^than ENG|030301 | 14| M| #04greater^than #05less^than^or^equal^to#06greater^than^or^equal^to ENG|030301 | 15| M| #07between #08sounds^like #09similar^to ENG|030301 | 16|SM| #10contained^in ENG|030301 | 19| | To facilitate the input of the desired operation, you may use the ENG|030301 | 20| M| #14SPLTJOIN key. ENG|030301 | 23| | You may also specify selection criteria for more columns of a table. Then ENG|030301 | 24| | those entries will be searched which meet all search criteria. ENG|030301 | 26| | Example: ENG|030301 | 28| | NAME.......: Miller........ FIRSTNAME..: Walter......... ENG|030301 | 30| | You will get all entries concerning people named Walter Miller. ENG|030301 | 32| | When EASY found a result, you may update or delete it or even have it ENG|030301 | 33|SI| displayed in ##030302tabular^format. ENG|030301 | 37| | To make a new request, press either ENG|030301 | 39| M| - the #12LAST-SEL key or ENG|030301 | 40|RM| - the #13RESET key. ENG|03030101 | 1| | O P E R A T I O N " E Q U A L T O " ENG|03030101 | 3| | You may have entries searched in which certain columns - either numeric ENG|03030101 | 4| | or text - are to correspond with fixed values. To do so, enter an equals ENG|03030101 | 5| | sign ("=") in the corresponding input field followed by the desired ENG|03030101 | 6| | value. The equals sign may be omitted. ENG|03030101 | 8| | Example: ENG|03030101 | 10| | NAME...........: Smith............... ENG|03030101 | 11| | FIRSTNAME......: =Bill............... ENG|03030101 | 12| | SALARY.........: .............. ENG|03030101 | 14| | produces all entries where the name is "Smith" and the first name ENG|03030101 | 15|R | is "Bill". ENG|03030102 | 1| | O P E R A T I O N " N O T E Q U A L T O " ENG|03030102 | 3| | You may have entries searched in which certain columns - numeric or ENG|03030102 | 4| | text - are to be different from a particular value. ENG|03030102 | 5| | To do so, enter the characters "<>" in the input field followed ENG|03030102 | 6| | by the desired value. ENG|03030102 | 8| | Example: ENG|03030102 | 10| | NAME...........: <>Smith............. ENG|03030102 | 11| | FIRSTNAME......: .................... ENG|03030102 | 12| | SALARY.........: .............. ENG|03030102 | 14|R | produces all entries where the name is not "Smith". ENG|03030103 | 1| | O P E R A T I O N " L E S S T H A N " ENG|03030103 | 3| | You may have entries searched in which a particular column - numeric or ENG|03030103 | 4| | text - is to be less than a fixed value. To do so, enter the character ENG|03030103 | 5| | "<" in the corresponding input field followed by the limit value. For ENG|03030103 | 6| | text, entries will be searched which in alphabetical order ENG|03030103 | 7| | p r e c e d e the limit value. ENG|03030103 | 9| | Example: ENG|03030103 | 11| | NAME...........: <Smith.............. ENG|03030103 | 12| | FIRSTNAME......: .................... ENG|03030103 | 13| | SALARY.........: <2500,00............ ENG|03030103 | 15| | produces all entries where the name precedes "Smith" in the alphabet and ENG|03030103 | 16|R | where the salary is less than 2500. ENG|03030104 | 1| | O P E R A T I O N " G R E A T E R T H A N " ENG|03030104 | 3| | You may have entries searched in which a particular column - numeric or ENG|03030104 | 4| | text - is to be greater than a fixed value. To do so, enter the character ENG|03030104 | 5| | ">" in the corresponding input field followed by the limit value. For ENG|03030104 | 6| | text, entries will be searched which in alphabetical order ENG|03030104 | 7| | f o l l o w the limit value. ENG|03030104 | 9| | Example: ENG|03030104 | 11| | NAME...........: >Smith.............. ENG|03030104 | 12| | FIRSTNAME......: .................... ENG|03030104 | 13| | SALARY.........: >2500,00............ ENG|03030104 | 15| | produces all entries where the name follows "Smith" in the alphabet and ENG|03030104 | 16|R | where the salary is greater than 2500. ENG|03030105 | 1| | O P E R A T I O N " L E S S T H A N O R E Q U A L T O " ENG|03030105 | 3| | You may have entries searched in which a particular column - numeric or ENG|03030105 | 4| | text - is to be less than or, at the most, equal to a fixed value. To do ENG|03030105 | 5| | so, enter the character "<=" in the corresponding input field followed by ENG|03030105 | 6| | the desired maximum value. For text, the search will be done in ENG|03030105 | 7| | alphabetical order. ENG|03030105 | 9| | Example: ENG|03030105 | 11| | NAME...........: <=Smith............. ENG|03030105 | 12| | FIRSTNAME......: .................... ENG|03030105 | 13| | SALARY.........: <=2500,00........... ENG|03030105 | 15| | produces all entries where the name precedes "Smith" in the alphabet or ENG|03030105 | 16|R | is "Smith" and where the salary is 2500 at the most. ENG|03030106 | 1| | O P E R A T I O N " G R E A T E R T H A N O R E Q U A L T O " ENG|03030106 | 3| | You may have entries searched in which a particular column - numeric or ENG|03030106 | 4| | text - is to be greater than or, at least, equal to a fixed value. To do ENG|03030106 | 5| | so, enter the character ">=" in the corresponding input field followed by ENG|03030106 | 6| | the desired maximum value. For text, the search will be done in ENG|03030106 | 7| | alphabetical order. ENG|03030106 | 9| | Example: ENG|03030106 | 11| | NAME...........: >=Smith............. ENG|03030106 | 12| | FIRSTNAME......: .................... ENG|03030106 | 13| | SALARY.........: >=2500,00............ ENG|03030106 | 15| | produces all entries where the name follows "Smith" in the alphabet or is ENG|03030106 | 16|R | "Smith" and where the salary is 2500 at least. ENG|03030107 | 1| | O P E R A T I O N " B E T W E E N " ENG|03030107 | 3| | You may have entries searched in which particular columns are to lie ENG|03030107 | 4| | between two fixed limits. To do so, specify first the lower limit, then ENG|03030107 | 5| | the upper limit, separated by " .. ", in the input field. The blanks ENG|03030107 | 6| | before and after the dots are mandatory! ENG|03030107 | 8| | Example: ENG|03030107 | 10| | NAME...........: .................... ENG|03030107 | 11| | FIRSTNAME......: .................... ENG|03030107 | 12| | SALARY.........: 2 000 .. 3 000 ENG|03030107 | 14| | produces all entries where the salary is between 2000 and 3000 ENG|03030107 | 15|S | (inclusive). ENG|03030107 | 19| | This request option is also available for text values, e.g. for names. In ENG|03030107 | 20| | this case the search is done in alphabetical order. ENG|03030107 | 22| | Example: ENG|03030107 | 24| | NAME...........: A .. Lzzz........... ENG|03030107 | 25| | FIRSTNAME......: .................... ENG|03030107 | 26| | SALARY.........: ........ ENG|03030107 | 28| | produces all entries where the name lies between A and L (including all ENG|03030107 | 29| | names beginning with A and L). ENG|03030107 | 33| | This request option can also be negated. To do so, specify the characters ENG|03030107 | 34|S | "<>" in the first two columns before the request. ENG|03030107 | 37| | Example: ENG|03030107 | 39| | NAME...........: <>L .. Nzzz......... ENG|03030107 | 40| | FIRSTNAME......: .................... ENG|03030107 | 41| | SALARY.........: ........ ENG|03030107 | 43| | produces all entries where the name does not lie between L and Nzzz, i.e. ENG|03030107 | 44|R | those lying between A and K and between O and Z (inclusive). ENG|03030108 | 1| | O P E R A T I O N " S O U N D S L I K E " ENG|03030108 | 3| | You may have entries searched in which a text column is to correspond ENG|03030108 | 4| | phonetically with a specified text. This comes in handy, when you are ENG|03030108 | 5| | e.g. uncertain of the spelling of a name. To do so, write the character ENG|03030108 | 6| | ":" in the particular input field followed by the text to be compared to. ENG|03030108 | 8| | Example: ENG|03030108 | 10| | NAME...........: :Meyer.............. ENG|03030108 | 11| | FIRSTNAME......: .................... ENG|03030108 | 12| | SALARY.........: .................... ENG|03030108 | 14| | produces all entries where the name sounds like "Meyer", e.g. "Meier", ENG|03030108 | 15|R | "Myar", and even "Mire" and "Myre". ENG|03030109 | 1| | O P E R A T I O N " S I M I L A R T O " ENG|03030109 | 3| | You may have entries searched in which a text column corresponds ENG|03030109 | 4| | partially to a given text, if one of the following two characters is ENG|03030109 | 5| | included in the specified search text: ENG|03030109 | 7| | - The character "*" has the meaning of a character string wildcard: Any ENG|03030109 | 8| | string (or nothing at all) can be stored in the table instead of it. ENG|03030109 | 10| | - The character "?" has the meaning of a single character wildcard: ENG|03030109 | 11| | Exactly one (arbitrary) character must be stored in the table in place ENG|03030109 | 12| | of it. ENG|03030109 | 14|S | Both characters may occur simultaneously in the search text. ENG|03030109 | 19| | Example: ENG|03030109 | 21| | NAME...........: Me?de................ ENG|03030109 | 22| | FIRSTNAME......: R*nald.............. ENG|03030109 | 23| | SALARY.........: .................... ENG|03030109 | 25| | produces all entries where the name is five characters long, begins with ENG|03030109 | 26| | "Me" and ends with "de"; the first name, however, beginning with "R" and ENG|03030109 | 27| | ending with "nald" may have any length. ENG|03030109 | 29| | In this case "Meade", "Meede", and "Mende", but not "Merode" will be ENG|03030109 | 30|R | found as names, "Ronald" and "Reginald" will be found as first names. ENG|03030110 | 1| | O P E R A T I O N " C O N T A I N E D I N " ENG|03030110 | 3| | You may have entries searched in which a column - numeric or text - is to ENG|03030110 | 4| | have at least one of more specified values. To do so, list the comparison ENG|03030110 | 5| | values one after the other and separate them from each other by a ENG|03030110 | 6| | vertical line ("|"). ENG|03030110 | 8| | Example: ENG|03030110 | 10| | NAME...........: Smith|Miller|Lehman ENG|03030110 | 11| | FIRSTNAME......: Fredrick|William|Fredrick-William ENG|03030110 | 12| | SALARY.........: .................... ENG|03030110 | 14| | provides all entries where the name is "Smith", "Miller" or "Lehman" and ENG|03030110 | 15|R | the first name is "Fredrick", "William" or "Fredrick-William". ENG|03030111 | 1| | S E L E C T I O N O P E R A T I O N S (General Information) ENG|03030111 | 3| | The symbols of the selection operations must begin in the first column of ENG|03030111 | 4| | the value field. This does not apply to the operations "similar to", ENG|03030111 | 5| | "between" and "contained in". These three operations can also be negated ENG|03030111 | 6| | by placing "<>" in front of them. ENG|03030111 | 8| | All these symbols may be followed by any number of blanks. "between" and ENG|03030111 | 9| | "contained in" may even be preceded by blanks. ENG|03030111 | 12| | To find out the values which you may enter after the selection ENG|03030111 | 13|RM| operations, please select the chapter #01Value Input. ENG|0303011101 | 1| | If you want to make a request, you can outline what the result is to look ENG|0303011101 | 2| | like: ENG|0303011101 | 4| | Smith this column is to contain 'Smith' ENG|0303011101 | 6| | >100.00 values in this column are to be greater than ENG|0303011101 | 7| | 100.00 (or: >=, <, <=, <>) ENG|0303011101 | 9| | red|blue here red or blue is to occur ENG|0303011101 | 11| | Str* values are to begin with Str ENG|0303011101 | 13| | ?NO 3 characters long ending with NO, e.g. CNO ENG|0303011101 | 15| | :Meyer everything that sounds like Meyer, ENG|0303011101 | 16|S | e.g. Myer or Mire ENG|0303011101 | 19| | You may have also results displayed where several columns are related to ENG|0303011101 | 20| | each other in a specific way: ENG|0303011101 | 22| | Example: ENG|0303011101 | 24| | 5 MIN_PRICE...: ...... ENG|0303011101 | 25| | 6 MAX_PRICE...: <= 2 * %5 ENG|0303011101 | 27| | All results will be displayed where the maximum price is not greater than ENG|0303011101 | 28| | the double of the mimnimum price. You designate the columns by a "%" and ENG|0303011101 | 29| | the consecutive output number (%5 corresponds to MIN_PRICE). ENG|0303011101 | 30| | To form such arithmetic expressions, use the following arithmetic ENG|0303011101 | 31| | operations ENG|0303011101 | 32|R | + - * / ENG|03030112 | 1| | D I S P L A Y I N G T H E L A S T R E Q U E S T ENG|03030112 | 3| | If you have any doubts about the correctness of the results of a request, ENG|03030112 | 4| | you may use this function to have the most recent request redisplayed. ENG|03030112 | 6| | You may correct it, if necessary, and restrike the RESULT key. ENG|03030112 | 8| | If you repeat the last request without any corrections, you will see the ENG|03030112 | 9|R | result again that was displayed before you pressed th/30302-SEL key. ENG|03030113 | 1| | R E Q U E S T I N G B L A N K F O R M S ENG|03030113 | 3| | The RESET function will provide you with an empty form for the currently ENG|03030113 | 4| | used table. ENG|03030113 | 6| | This means: ENG|03030113 | 8| | - The entries you made so far are deleted; the input fields are refilled ENG|03030113 | 9| | with dots. ENG|03030113 | 11| | - If a result of a request has already been created, it is no longer ENG|03030113 | 12| | possible to scroll through this result set. ENG|03030113 | 14| | This key should be used, when you want to start a completey new request ENG|03030113 | 15|R | to the database. ENG|03030114 | 1| | S P L T J O I N ENG|03030114 | 4| | Place the cursor on an input line and press the SPLTJOIN key! ENG|03030114 | 6| | If there is some text at or after the cursor position, this text will be ENG|03030114 | 7| | shifted to the next line. Otherwise the contents of the next line (if ENG|03030114 | 8|R | there is any) will be appended to the current cursor position. ENG|030302 | 1| | R E P O R T F U N C T I O N ENG|030302 | 3| | The REPORT key will provide you with the results of your requests in ENG|030302 | 4| | tabular format. ENG|030302 | 6| | Example: ENG|030302 | 8| | HNO | NAME | ZIP | ADDRESS | ... ENG|030302 | 9| | --------- | ------------- | ----- | ------------------- | --- ENG|030302 | 10| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|030302 | 11| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|030302 | 12| | === 30 | Regency | 20037 | 477 17th Avenue | ... ENG|030302 | 13| | === 40 | Eight Avenue | 10019 | 112 8th Avenue | ... ENG|030302 | 14| | ... .. ........ .... ......... ... ENG|030302 | 16| | You may use the REPORT function, when EASY displays a result in file card ENG|030302 | 17|S | format. You may also strike the REPORT key, as soon as you have outlined ENG|030302 | 19| | your request. Then you will get the result directly in tabular format. ENG|030302 | 21| | You may not use the REPORT function any more, when you have made some ENG|030302 | 22| | modifications to your results. ENG|030302 | 24| | Within the tabular format you are able to ENG|030302 | 26| M| - #02update entries. ENG|030302 | 27| M| - #03delete entries. ENG|030302 | 28| M| - #04insert entries. ENG|030302 | 30| M| The FORMAT key will provide you with a menu in which you may #01format the ENG|030302 | 31| | report results. ENG|030302 | 33| | DET entered in the prefix area enables you to obtain a master-detail ENG|030302 | 34| | representation, in so far as a foreign key was defined between the current ENG|030302 | 35|R | and a second table. ENG|03030201 | 1| | F O R M A T T I N G A R E P O R T ENG|03030201 | 3| | You may restructure certain aspects of your report results that have been ENG|03030201 | 4| | output in tabular format. ENG|03030201 | 6| | Fill in the corresponding columns of the formatting form or mark them with ENG|03030201 | 7| | an "x" and press the REPORT key! To build subtotals and totals, you will ENG|03030201 | 8| | be provided with additional forms. There you can define the kind and ENG|03030201 | 9| | formatting of the results. ENG|03030201 | 11| | As usual, you will get more information by placing the cursor on the ENG|03030201 | 12| | corresponding field of the formatting form and pressing the HELP key. ENG|03030201 | 14| | After entering the desired format statements in the form and changing to ENG|03030201 | 15| | report mode by means of the REPORT key, you will not be able any more to ENG|03030201 | 16| | maintain your data in report mode, because you will only be allowed to ENG|03030201 | 17|R | have your data displayed and printed and output to a file. ENG|03030202 | 1| | U P D A T I N G W I T H I N T H E R E P O R T F O R M A T ENG|03030202 | 3| | In report mode you may update your data. The fields are not write- ENG|03030202 | 4| | protected, so you can overwrite the values you want to modify. ENG|03030202 | 6| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030202 | 7| | --------- | ------------- | ----- | ------------------ | --- ENG|03030202 | 8| | === 10 | Congress | 20010 | 10 Congress Way <------------- ENG|03030202 | 9| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030202 | 10| | === 30 | Regency | 10044 | Regent Street <-------------- ENG|03030202 | 11| | === 40 | Eight Avenue | 10019 | 112 8th Avenue | ... ENG|03030202 | 12| | ... ... ENG|03030202 | 14| | After striking the enter key the updated values will no longer be ENG|03030202 | 15| | "highlighted" in order to distinguish them from the non-updated values. ENG|03030202 | 16| | If you want to reset the updated result rows, i.e. to restore the original ENG|03030202 | 17|S | state, place an "R" or "r" (for "recover") in the so-called prefix area of ENG|03030202 | 19| | the corresponding row. ENG|03030202 | 21| | Example: ENG|03030202 | 23| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030202 | 24| | --------- | ------------- | ----- | ------------------ | --- ENG|03030202 | 25| | =r= 10 | Congress | 20010 | 10 Congress Way <------------- ENG|03030202 | 26| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030202 | 27| | === 30 | Regency | 10044 | Regent Street | ... ENG|03030202 | 28| | === 40 | Eight Avenue | 10019 | 112 8th Avenue | ... ENG|03030202 | 29| | ... ... ENG|03030202 | 31| | After striking the enter key you will see the original results, without ENG|03030202 | 32| | any modifications, in the reset rows. ENG|03030202 | 34| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030202 | 35|S | --------- | ------------- | ----- | ------------------ | --- ENG|03030202 | 37| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030202 | 38| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030202 | 39| | === 30 | Regency | 10044 | Regent Street | ... ENG|03030202 | 40| | === 40 | Eight Avenue | 10019 | 112 8th Avenue | ... ENG|03030202 | 41| | ... ... ENG|03030202 | 43| | Striking the CONFIRM key will perform the remaining updates in the ENG|03030202 | 44| | database table. ENG|03030202 | 46| | By the way, you are not allowed to update key fields. Therefore they are ENG|03030202 | 47|R | write-protected. ENG|03030203 | 1| | D E L E T I N G E N T R I E S W I T H I N ENG|03030203 | 2| | T H E R E P O R T F O R M A T ENG|03030203 | 4| | To delete complete entries in report mode, place the letter "D" (or "d") ENG|03030203 | 5| | in the so-called prefix area of the entry to be deleted. ENG|03030203 | 7| | Example: ENG|03030203 | 9| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030203 | 10| | --------- | ------------- | ----- | ------------------- | --- ENG|03030203 | 11| | =d= 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030203 | 12| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030203 | 13| | === 30 | Regency | 20037 | 477 17th Avenue | ... ENG|03030203 | 14| | ==D 40 | Eight Avenue | 10019 | 112 8th Avenue | ... ENG|03030203 | 15| | ... .. ........ .... ......... ... ENG|03030203 | 17|S | After striking the enter key the corresponding entries will be provided ENG|03030203 | 19| | with a delete note. ENG|03030203 | 21| | Example: ENG|03030203 | 23| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030203 | 24| | --------- | ------------- | ----- | ------------------- | --- ENG|03030203 | 25| | === 10 | Congress *** (row will be deleted) *** | ... ENG|03030203 | 26| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030203 | 27| | === 30 | Regency | 20037 | 477 17th Avenue | ... ENG|03030203 | 28| | === 40 | Eight Av *** (row will be deleted) *** | ... ENG|03030203 | 29| | ... .. ........ .... ......... ... ENG|03030203 | 31| | If you want to delete some entries which on your screen are displayed one ENG|03030203 | 32| | below the other, place "DD" or "dd" in the prefix area of both the first ENG|03030203 | 33| | and the last entry to be deleted. ENG|03030203 | 35|S | Example: ENG|03030203 | 37| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030203 | 38| | --------- | ------------- | ----- | ------------------- | --- ENG|03030203 | 39| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030203 | 40| | =dd 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030203 | 41| | === 30 | Regency | 20037 | 477 17th Avenue | ... ENG|03030203 | 42| | DD= 40 | Eight Avenue | 10019 | 112 8th Avenue | ... ENG|03030203 | 43| | ... .. ........ .... ......... ... ENG|03030203 | 45| | After striking the enter key the whole block will be provided with a ENG|03030203 | 46| | delete note. ENG|03030203 | 47| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030203 | 48| | --------- | ------------- | ----- | ------------------- | --- ENG|03030203 | 49| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030203 | 50| | === 20 | Long Is *** (row will be deleted) *** | ... ENG|03030203 | 51| | === 30 | Regency *** (row will be deleted) *** | ... ENG|03030203 | 52| | === 40 | Eight Av *** (row will be deleted) *** | ... ENG|03030203 | 53|S | ... .. ........ .... ......... ... ENG|03030203 | 55| | The entries, however, are not yet removed from the database. If you want ENG|03030203 | 56| | to reset the individual result rows, i.e. to restore the original state, ENG|03030203 | 57| | place an "R" or "r" (for "recover") in the prefix area of the ENG|03030203 | 58| | corresponding line. If you want to recover several rows that follow each ENG|03030203 | 59| | other, use the block commands "RR" or "rr". ENG|03030203 | 61| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030203 | 62| | --------- | ------------- | ----- | ------------------- | --- ENG|03030203 | 63| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030203 | 64| | rr= 20 | Long Is *** (row will be deleted) *** | ... ENG|03030203 | 65| | RR= 30 | Regency *** (row will be deleted) *** | ... ENG|03030203 | 66| | === 40 | Eight Av *** (row will be deleted) *** | ... ENG|03030203 | 67| | ... .. ........ .... ......... ... ENG|03030203 | 69| | After striking the enter key the delete note will be removed from the ENG|03030203 | 70|S | corresponding lines. ENG|03030203 | 73| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030203 | 74| | --------- | ------------- | ----- | ------------------- | --- ENG|03030203 | 75| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030203 | 76| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030203 | 77| | === 30 | Regency | 20037 | 477 17th Avenue | ... ENG|03030203 | 78| | === 40 | Eight Av *** (row will be deleted) *** | ... ENG|03030203 | 79| | ... .. ........ .... ......... ... ENG|03030203 | 81| | Striking the CONFIRM key will perform the remaining deletions in the ENG|03030203 | 82|R | database. ENG|03030204 | 1| | I N S E R T I N G E N T R I E S I N R E P O R T F O R M A T ENG|03030204 | 3| | To insert new entries into a table in report mode, use the ENG|03030204 | 4| | INSERTS key. This key will open a second window. There you can then insert ENG|03030204 | 5| | new values. ENG|03030204 | 7| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030204 | 8| | --------- | ------------- | ----- | ------------------- | --- ENG|03030204 | 9| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030204 | 10| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030204 | 11| | === 30 | Regency | 20037 | 477 17th Avenue | ... ENG|03030204 | 13| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030204 | 14| | --------- | ------------- | ----- | ------------------- | --- ENG|03030204 | 15| | === | | | | ... ENG|03030204 | 16| | === | | | | ENG|03030204 | 17|S | === | | | | ... ENG|03030204 | 19| | Enter the new values you want to insert into the table in the empty ENG|03030204 | 20| | fields. ENG|03030204 | 22| | Example: ENG|03030204 | 24| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030204 | 25| | --------- | ------------- | ----- | ------------------- | --- ENG|03030204 | 26| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030204 | 27| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030204 | 28| | === 30 | Regency | 20037 | 477 17th Avenue | ... ENG|03030204 | 30| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030204 | 31| | --------- | ------------- | ----- | ------------------- | --- ENG|03030204 | 32| | === 210 | Assembly | 20005 | 500 River Lane | ... ENG|03030204 | 33| | === 220 | Deputy | 20005 | 50 Lake Street | ... ENG|03030204 | 34|S | === 230 | Representative| 20005 | 5 Creek Avenue | ... ENG|03030204 | 37| | In both windows you can scroll, as usual, from left to right, up and down. ENG|03030204 | 38| | To do so, place the cursor in the corresponding window and press the ENG|03030204 | 39| | scroll keys. Using the key WHOLE will close the insert window again. The ENG|03030204 | 40| | new entries will not be lost by doing so, but a message will be output ENG|03030204 | 41| | telling you how many new entries are available which are not displayed. ENG|03030204 | 43| | Example: ENG|03030204 | 45| | 36 results ( + 3 new rows ) ENG|03030204 | 47| | The inserts will only be performed in the database when you strike the ENG|03030204 | 48| | CONFIRM key. ENG|03030204 | 50| | If you want to use an already existing result row with some modifications ENG|03030204 | 51| | as new entry, then copy it into the input area by means of the prefix ENG|03030204 | 52| | command "C". (Of course, you can also copy a block of rows by means of the ENG|03030204 | 53|S | "CC" commands.) ENG|03030204 | 55| | Example: ENG|03030204 | 57| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030204 | 58| | --------- | ------------- | ----- | ------------------- | --- ENG|03030204 | 59| | =C= 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030204 | 60| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030204 | 61| | c== 30 | Regency | 20037 | 477 17th Avenue | ... ENG|03030204 | 63| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030204 | 64| | --------- | ------------- | ----- | ------------------- | --- ENG|03030204 | 65| | === | | | | ... ENG|03030204 | 66| | === | | | | ENG|03030204 | 67| | === | | | | ... ENG|03030204 | 69| | Striking the enter key will copy these rows into the input area. There you ENG|03030204 | 70|S | can make the desired modifications to the entries. ENG|03030204 | 73| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030204 | 74| | --------- | ------------- | ----- | ------------------- | --- ENG|03030204 | 75| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030204 | 76| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|03030204 | 77| | === 30 | Regency | 20037 | 477 17th Avenue | ... ENG|03030204 | 79| | HNO | NAME | ZIP | ADDRESS | ... ENG|03030204 | 80| | --------- | ------------- | ----- | ------------------- | --- ENG|03030204 | 81| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|03030204 | 82| | === 30 | Regency | 20037 | 477 17th Avenue | ... ENG|03030204 | 83| | === | | | | ... ENG|03030204 | 85| | In the same way you may use the prefix commands '"' or '""' to duplicate ENG|03030204 | 86|R | the rows within the input area. ENG|030303 | 1| | I N S E R T I N G A N E W E N T R Y ENG|030303 | 3| | The values you have entered in the request form will be inserted into the ENG|030303 | 4| | table when you strike the INSERT key. Should the request form be empty ENG|030303 | 5| | when the INSERT key is struck, EASY changes to the report format. Here you ENG|030303 | 6| | may simultaneously insert several data rows into the table. ENG|030303 | 8| | Example: ENG|030303 | 10| | HNO | NAME | ZIP | ADDRESS | ... ENG|030303 | 11| | --------- | ------------- | ----- | ------------------- | --- ENG|030303 | 12| | === | | | | ... ENG|030303 | 13| | === | | | | ... ENG|030303 | 14| | === | | | | ... ENG|030303 | 15| | ... . . . . ... ENG|030303 | 17|S | Enter your new values into the empty fields. ENG|030303 | 19| | Example: ENG|030303 | 21| | HNO | NAME | ZIP | ADDRESS | ... ENG|030303 | 22| | --------- | ------------- | ----- | ------------------- | --- ENG|030303 | 23| | === 10 | Congress | 20005 | 155 Beechwood Str. | ... ENG|030303 | 24| | === 20 | Long Island | 11788 | 1499 Grove Street | ... ENG|030303 | 25| | === 30 | Regency | 20037 | 477 17th Avenue | ... ENG|030303 | 26| | ... . . . . ... ENG|030303 | 28| | Striking the CONFIRM key will store your values in the table. ENG|030303 | 30| | EASY thereby checks wether ... ENG|030303 | 32| | ...all key columns (if any) are set to values, ENG|030303 | 33| | ...the key (if any) is unique, ENG|030303 | 34| | ...all mandatory fields (if any) are set to values, ENG|030303 | 35|S | ...all values are in the valid range of values, ENG|030303 | 37| | ...you created the table or you are authorized to make ENG|030303 | 38| | insertions in this table. ENG|030303 | 40| | If any of these conditions is violated, EASY rejects the insertion and ENG|030303 | 41|R | produces a corrective comment instead. ENG|030304 | 1| | U P D A T I N G A T A B L E E N T R Y ENG|030304 | 3| | You may update the currently displayed result of your request in the ENG|030304 | 4| | database. Overwrite the corresponding values in the form with new ones and ENG|030304 | 5| | strike the key UPDATE. ENG|030304 | 7| | EASY thereby checks whether ... ENG|030304 | 9| | ...the key columns (if any) are unchanged, ENG|030304 | 10| | ...all mandatory fields (if any) are set to values, ENG|030304 | 11| | ...all values are in the valid range of values, ENG|030304 | 12| | ...you created the table or you are authorized to make ENG|030304 | 13| | insertions in this table. ENG|030304 | 15| | If any of these conditions is violated, EASY rejects the update and ENG|030304 | 16|R | produces a corrective comment instead. ENG|030305 | 1| | D E L E T I N G A N E N T R Y ENG|030305 | 3| | You may delete the currently displayed entry from your table by striking ENG|030305 | 4| | the key DELETE. ENG|030305 | 6| | You can only delete values from a table, when you created the table or ENG|030305 | 7| | when you are authorized to delete entries from it. ENG|030305 | 9| | The entry will remain on the screen. If you made a mistake, you can ENG|030305 | 10|R | reinsert it immediately by striking the key INSERT. ENG|0304 | 1| | T A B L E A D M I N I S T R A T I O N ENG|0304 | 3| | If a request form has not yet been created for the current table, or if ENG|0304 | 4| | the table does not exist yet, or if a new view is to be created, then ENG|0304 | 5| M| striking the ADMIN key will put you into the #01standard table administration ENG|0304 | 6| | mode. Here you can either define or redefine your table or you can change ENG|0304 | 7| | to the form editor by means of the OWN-FORM key in order to create a view. ENG|0304 | 9| | But if a table is provided with a request form or if you edit an existing ENG|0304 | 10| | view instead of a table, then you will get first to the form editor that ENG|0304 | 11| | displays the description of the request form or view. ENG|0304 | 13| | Then you can ... ENG|0304 | 14| M| ...#04redefine this request form/view ENG|0304 | 15| M| ...change from your own request form to the #02standard form ENG|0304 | 16| M| ...drop a #05view ENG|0304 | 17|RM| ...or drop the whole #03table. ENG|030401 | 1| | S T A N D A R D A D M I N I S T R A T I O N M O D E ENG|030401 | 3| M| In this mode you may #01define^or^redefine the description of the current ENG|030401 | 4| | table or/and change to the form editor by means of OWN-FORM in order to ENG|030401 | 6| M| ...define a table with a #02user-defined^request^form, ENG|030401 | 7| M| ...to create a #03view on one or two existing tables, ENG|030401 | 8| | ...to transform the standard form of an existing table ENG|030401 | 9|RI| into a ##030404user-defined^request^form. ENG|03040101 | 1| | C R E A T I N G / R E C R E A T I N G ENG|03040101 | 2| | A T A B L E ENG|03040101 | 4| | EASY displays a three-column form where the database columns can be ENG|03040101 | 5| | defined or redefined in a simple manner. ENG|03040101 | 7| | For a new table you can define... ENG|03040101 | 8| | ...new columns and ENG|03040101 | 9| | ...columns as key columns. ENG|03040101 | 11| | For an existing table you can... ENG|03040101 | 12| | ...drop existing columns and ENG|03040101 | 13| | ...define new columns. ENG|03040101 | 15| | To enable later database requests, EASY generates a standard request form ENG|03040101 | 16|S | for a table created in this mode. ENG|03040101 | 19| | In EASY, however, it is not possible to define RANGES and NOT NULL fields. ENG|03040101 | 20| | For this purpose you must use QUERY. To be able to define new tables you ENG|03040101 | 21| | must have got the corresponding authorization by the database ENG|03040101 | 22| | administrator. ENG|03040101 | 24| | You will get more information about the standard table definition, when ENG|03040101 | 25| | you specify the name of the table you want to create in the table ENG|03040101 | 26| | selection menu and strike ADMIN. EASY will change to the table ENG|03040101 | 27| | administration mode, displaying a standard form. You can place the cursor ENG|03040101 | 28| | on one of the input columns. Pressing the HELP key will make known to you ENG|03040101 | 29|R | which entries are allowed there. ENG|03040102 | 1| | D E F I N I N G A N E A S Y F O R M ENG|03040102 | 3| | To define a table with a user-defined request form proceed as follows: ENG|03040102 | 5| | Each character that you enter here (exceptions see below) will occur in ENG|03040102 | 6| | the request form. You can, for example, border your form with lines or ENG|03040102 | 7| | define field identifiers. ENG|03040102 | 9| | Example: ENG|03040102 | 11| | *----------------------------------------------------* ENG|03040102 | 12| | ! Name: ! ENG|03040102 | 13| | ! Firstname: ! ENG|03040102 | 15| | If such a field identifier (such as "Name:") ends with a colon, EASY ENG|03040102 | 16| | establishes an input field after it. Later you can enter search words or ENG|03040102 | 17|S | new values into this field. EASY inserts a blank between the colon of the ENG|03040102 | 19| | field identifier and the input field. ENG|03040102 | 21| | You can also define the beginning of an input field by means of the ENG|03040102 | 22| | underscore ("_"). Thus it is possible to define an input field without a ENG|03040102 | 23| | field identifier specification and to align the input fields within the ENG|03040102 | 24| | form. ENG|03040102 | 26| | An input field ends either at the screen margin, or a position before the ENG|03040102 | 27| | next specified character, or at the place defined by the delimiter "&1". ENG|03040102 | 28| | The delimiter will not be output in the request form. It can be modified ENG|03040102 | 29| I| via the ##0306SET menu. ENG|03040102 | 31| | Example: ENG|03040102 | 33| | *----------------------------------------------------* ENG|03040102 | 34| | ! Name: _ &1 ! ENG|03040102 | 35|S | ! Firstname: _ &1 ! ENG|03040102 | 37| | ! Domicile : _ _ ! ENG|03040102 | 39| | In the example above the first input field after "Domicile" could, e.g., ENG|03040102 | 40| | take up the name of the domicile, whereas the second input field could be ENG|03040102 | 41| | meant for the zip code. ENG|03040102 | 43| | EASY gives a name to every input field in order to define a database table ENG|03040102 | 44| | by it. But if you like, you can define your own names for one or more ENG|03040102 | 45| | input fields. Such a name has to be placed d i r e c t l y a f t e r ENG|03040102 | 46| | the underscore that identifies the beginning of the input field. ENG|03040102 | 48| | Example: ENG|03040102 | 50| | ! ... ... ! ENG|03040102 | 51| | ! Domicile: _domicile _zip ! ENG|03040102 | 53|S | This name does not occur in the request form, but it will be displayed in ENG|03040102 | 55| | output generated via QUERY, for example. ENG|03040102 | 58| | It is convenient to provide the input fields in a form with so-called ENG|03040102 | 59| | field numbers, these are numbers in a range between 1 and 254. ENG|03040102 | 61| | You can use these field numbers ENG|03040102 | 63| | - to define key fields, ENG|03040102 | 64| | - to enable a sort of the fields in later database requests, ENG|03040102 | 65| | - to specify cross references between two or more input fields in later ENG|03040102 | 66| | requests. ENG|03040102 | 68| | Example: ENG|03040102 | 70| | *----------------------------------------------------* ENG|03040102 | 71|S | ! 1 Name: _ ! ENG|03040102 | 73| | ! 2 Firstname: _ ! ENG|03040102 | 76| | In both cases the field number refers to the next following input field of ENG|03040102 | 77| | the request form (in our example "1" refers to "Name", "2" to ENG|03040102 | 78| | "Firstname"). ENG|03040102 | 80| | For the definition of your form you will dispose of the full functionality ENG|03040102 | 81|R | of the ADABAS editor. ENG|03040103 | 1| | C R E A T I N G / A L T E R I N G A V I E W ENG|03040103 | 3| | With EASY you may create a VIEW for one or two existing tables: ENG|03040103 | 5| | - EASY then only displays those table columns you want to see. ENG|03040103 | 7| | - EASY displays information from two different tables. It is possible to ENG|03040103 | 8| | define a relationship between these two tables. ENG|03040103 | 10|R | For details please refer to the chapter "Creating a View" in the manual. ENG|030402 | 1| | S T A N D A R D A D M I N I S T R A T I O N M O D E ENG|030402 | 3| | With the STANDARD key you decide for the standard EASY request form. ENG|030402 | 5| | If you are not interested in your self-defined request form, you can ENG|030402 | 6| | change to the standard mode and make there your alterations to the table. ENG|030402 | 7| | Your self-defined request form will be lost as soon as you confirm your ENG|030402 | 8| | table modifications with ALTER. ENG|030402 | 10| | To enable later database requests, EASY generates a standard request form ENG|030402 | 11|R | for this table. ENG|030403 | 1| | D R O P P I N G A T A B L E ENG|030403 | 3| | EASY enables you to drop an entire table, i.e.: ENG|030403 | 5| | - all table entries will be deleted, ENG|030403 | 6| | - the description of the table will be deleted, ENG|030403 | 7| | - all access rights expire, ENG|030403 | 8| | - the request form of the table will be deleted and ENG|030403 | 9| | - all named requests of the table will be deleted. ENG|030403 | 11| | To do so, strike the DROP key within the table administration mode. To ENG|030403 | 12| | prevent you from unintentionally dropping a table, you have to press this ENG|030403 | 13| | key a second time. Tables can only be dropped by the user who created ENG|030403 | 14|R | them. ENG|030404 | 1| | A L T E R I N G T H E E A S Y R E Q U E S T F O R M ENG|030404 | 3| | Here you can modify your EASY request form or change from the standard ENG|030404 | 4| | form to a user-defined form. You either see the description of the request ENG|030404 | 5| | form as you defined it or the description of the standard form as EASY ENG|030404 | 6| | would create it because of the table definition. To limit the input fields ENG|030404 | 7| I| the delimiter that you defined in the ##0306SET menu will be used. ENG|030404 | 9| | But in contrast to the new definition of the form, the internal field ENG|030404 | 10| | names EASY generated for the table definition will be displayed as well: ENG|030404 | 12| | *----------------------------------------------------* ENG|030404 | 13| | ! Name: _NAME ! ENG|030404 | 14| | ! Firstname: _FIRSTNAME ! ENG|030404 | 15| | ! Domicile: _DOMICILE _ZIP ! ENG|030404 | 17|S | This form can be redesigned according to your new requirements. The ENG|030404 | 19| | following rules apply: ENG|030404 | 22| | - A table column will be dropped from the database, when its field name ENG|030404 | 23| | (not the field identifier) is removed from the form definition. ENG|030404 | 25| | - The definition of a new field creates a new column in the database as ENG|030404 | 26| | well. (Especially modifyint a field name will remove the old database ENG|030404 | 27| | column and create a new one.) ENG|030404 | 29| | - All the other modifications only result in a different layout of the ENG|030404 | 30| | request form, but they do not change the definition of the pertinent ENG|030404 | 31| | database table. ENG|030404 | 34|S | Example: ENG|030404 | 37| | *----------------------------------------------------* ENG|030404 | 38| | ! Name: _NAME ! ENG|030404 | 39| | ! City: _DOMICILE Zip: _ZIP ! ENG|030404 | 40| | ! Street: _ House No: ! ENG|030404 | 43| | Here the input field "FIRSTNAME" will be dropped from the database, ENG|030404 | 44| | whereas two new fields with the field identifiers "Street" and "House No:" ENG|030404 | 45|R | will be created in the database table. ENG|030405 | 1| | D R O P P I N G A V I E W ENG|030405 | 3| | With EASY you may drop a view, i.e.: ENG|030405 | 5| | - the description of the view will be deleted, ENG|030405 | 6| | - all access rights expire, ENG|030405 | 7| | - all named requests belonging to the view will be deleted. ENG|030405 | 9| | To do so, strike the DROP key within the table administration mode. To ENG|030405 | 10| | prevent you from unintentionally dropping a view, you have to press this ENG|030405 | 11|R | key a second time. Views can only be dropped by the user who created them. ENG|0305 | 1| | H E L P F U N C T I O N ENG|0305 | 3| | In EASY you may retrieve information at any time and in many ways: ENG|0305 | 5| | - If an error is displayed during your work with EASY and you press the ENG|0305 | 6| | HELP key, then, in most of the cases, you will get detailed explanations ENG|0305 | 7| | about this error and advice as to correct it. ENG|0305 | 9| | - You have the possibility in EASY to position the cursor on that place of ENG|0305 | 10| | the screen (input field, displayed function) about which you want to get ENG|0305 | 11| | more information. This information can be retrieved via the HELP key. ENG|0305 | 13| | - More general information, ordered by chapters, may be found in the ENG|0305 | 14| | global help (2nd help level). Usually you get there after having called ENG|0305 | 15| | HELP by pressing the HELP key a second time. In this level the texts ENG|0305 | 16| | contain highlighted terms or chapter names. To select one of these ENG|0305 | 17|S | chapters, position the cursor on the desired term and restrike the HELP ENG|0305 | 19| | key. PREV returns you to the previous screen, whereas END-HELP allows ENG|0305 | 20| | you to leave HELP immediately. To easily find a page again during an ENG|0305 | 21| | EASY session you can use the MARK key to put a mark on any HELP page. If ENG|0305 | 22| | a page was marked you can jump directly to the marked page by means of ENG|0305 | 23| | the key TO-MARK. To have the first HELP page displayed strike the key ENG|0305 | 24| | HLP-MENU. In this way you may retrieve the available information bit by ENG|0305 | 25| | bit. ENG|0305 | 27| | - At some terminals you cannot position the cursor on the display of the ENG|0305 | 28| | EASY functions (e.g. in case of softkeys). For this case there is ENG|0305 | 29| | another way to get information about the EASY functions. Write ENG|0305 | 30| | the n a m e of the corresponding function in the ENG|0305 | 31| | field Function: ........... and press the HELP key. Then you will ENG|0305 | 32|R | also get detailed explanations about this function. ENG|0306 | 1| | S E T (SETTING INDIVIDUAL PARAMETERS) ENG|0306 | 3| | When you strike the SET key within the table menu, you come into the SET ENG|0306 | 4| | menu. Here you can change some of the parameters that are used by EASY, ENG|0306 | 5| | for example: ENG|0306 | 7| | Language: three-digit abbreviation of the desired language ENG|0306 | 8| | ( ENG (English), DEU (German) ). ENG|0306 | 10| | Comparison operations: default settings, such as "<=", ">=" ENG|0306 | 11| | or "<>", can be modified according to your needs. ENG|0306 | 13| | Delimiter: is used to mark the field end when defining the ENG|0306 | 14| | request form (default: '/'). ENG|0306 | 16|S | The current values will be displayed. These may be overwritten. ENG|0306 | 19|R | For details see the EASY manual. ENG|0307 | 1| | E X P O R T I N G, I M P O R T I N G F O R M S / R E Q U E S T S ENG|0307 | 2| | D R O P P I N G F O R M S O R D E L E T I N G R E Q U E S T S ENG|0307 | 4| | Certainly you want to store your self-defined request forms and the named ENG|0307 | 5| | requests of EASY in a file in order to be able to use them in later ENG|0307 | 6| | database versions. ENG|0307 | 8| | If you want to export or import named requests or forms and/or delete ENG|0307 | 9| | named requests or drop forms, then strike one of the following keys within ENG|0307 | 10| | the EASY table menu: ENG|0307 | 12| | NAMED-RQ (named request) ENG|0307 | 13| | FORMS key (forms) ENG|0307 | 15| | You get into the export/import menu where either the names of your named ENG|0307 | 16| | requests or the names of the tables will be listed for which you defined ENG|0307 | 17|S | request forms of your own. The number of the names may be limited by a ENG|0307 | 19| | pattern. ENG|0307 | 22| | Now you can ENG|0307 | 23| M| ...#02export, ENG|0307 | 24| M| ...#03import, and/or ENG|0307 | 25| M| ...#04drop/delete ENG|0307 | 26|R | ...forms or named requests. ENG|030701 | 1| | L I M I T I N G A M E N U ENG|030701 | 3| | You may limit the number of displayed names as you may do in the table ENG|030701 | 4| | menu. To do so, write a pattern into the field ENG|030701 | 6| | Pattern: ................... ENG|030701 | 8| | for example, ENG|030701 | 10| | Pattern: RE*................ ENG|030701 | 12|R | Afterwards you will only see the names which begin with the letters "RE". ENG|030702 | 1| | E X P O R T I N G F O R M S / N A M E D R E Q U E S T S ENG|030702 | 3| | To be able to export forms or named requests, you have to mark them ENG|030702 | 4| | previously. You can do this in two ways: ENG|030702 | 6| | - mark each form/named request ENG|030702 | 7| | - mark all forms/named requests ENG|030702 | 9| | By means of the cursor position you can determine which of these options ENG|030702 | 10| | will be used. ENG|030702 | 12| | To mark each single form or named request, place the cursor on the name of ENG|030702 | 13| | that form or named request you want to export. Then strike the MARK key. ENG|030702 | 14| | The marked name will be provided with a hash sign and be highlighted on ENG|030702 | 15| | display. ENG|030702 | 17|S | To mark all names, place the cursor on a field outside the list of names, ENG|030702 | 19| | e.g. on the field ENG|030702 | 21| | Pattern: ................... ENG|030702 | 23| | With the MARK key you then mark all names that are displayed within the ENG|030702 | 24| | menu. ENG|030702 | 27| | To remove a single mark, place the cursor on the corresponding name and ENG|030702 | 28| | strike the UNMARK key. In the same way you can remove all the marks by ENG|030702 | 29| | placing the cursor outside the names. ENG|030702 | 31| | After marking the forms or named requests you want to export start the ENG|030702 | 32| | export operation by means of the EXPORT key. EASY will prompt for the name ENG|030702 | 33| | of the file where the forms or named requests to be exported shall be ENG|030702 | 34|S | stored: ENG|030702 | 37| | Filename: .................... ENG|030702 | 39| | After specifying the filename and restriking the EXPORT key, the export ENG|030702 | 40| | operation will begin. During the export operation EASY will display the ENG|030702 | 41| | name of the form or named request currently exported. As soon as the ENG|030702 | 42|R | export operation is terminated, EASY returns to the export/import menu. ENG|030703 | 1| | I M P O R T I N G F O R M S / N A M E D R E Q U E S T S ENG|030703 | 3| | The reversal of the export operation is the import of forms or named ENG|030703 | 4| | requests. The exported forms or named requests are stored in a file. You ENG|030703 | 5| | want to use these definitions for your work with EASY. ENG|030703 | 7| | To do so, strike the IMPORT key in the export/import menu. Then you will ENG|030703 | 8| | be prompted for the name of the file containing the definitions: ENG|030703 | 10| | Filename: .................... ENG|030703 | 12| | After specifying the filename and restriking the IMPORT key, the import ENG|030703 | 13| | operation will begin. During the import operation EASY will display the ENG|030703 | 14| | name (and in case of forms the definition as well) of the form or named ENG|030703 | 15| | request currently imported. ENG|030703 | 17|S | However, there are some few rules to comply with: ENG|030703 | 19| | 1) Forms/named requests can only be imported if the corresponding tables ENG|030703 | 20| | are available. The pertinent tables will not be created automatically ENG|030703 | 21| | during the import. ENG|030703 | 23| | 2) The table definition should not have been modified between export and ENG|030703 | 24| | import. Otherwise it might happen that a form/named request does not ENG|030703 | 25| | fit the table any more, because a column was dropped or enlarged, for ENG|030703 | 26| | example. ENG|030703 | 28| | 3) The form/named request to be imported must not yet exist. ENG|030703 | 31| | Each violation of these rules will have the effect that the import run ENG|030703 | 32| | will be stopped and an error message be displayed. When importing forms, ENG|030703 | 33| | the definition of the form will be displayed in addition and the cursor ENG|030703 | 34|S | will be placed on the incorrect position. ENG|030703 | 37| | In each of these error cases you can skip the incorrect form or named ENG|030703 | 38| | request by means of the SKIP key. EASY will continue the import operation ENG|030703 | 39| | with the next form/named request. But you can also cancel the import run ENG|030703 | 40| | by means of the BACK key which will return you to the export/import menu. ENG|030703 | 42| | If forms are concerned in error case 2), you can try to correct the error ENG|030703 | 43| I| by adapting the displayed ##030404form^definition to the new table definition. ENG|030703 | 44| | With IMPORT you will then start a new import operation with the modified ENG|030703 | 45| | form definition. If the correction was successful, the import run is ENG|030703 | 46|R | continued with the next form. ENG|030704 | 1| | D E L E T I N G F O R M S / N A M E D R E Q U E S T S ENG|030704 | 3| | Forms/named requests which you do not need any longer can be deleted out ENG|030704 | 4| | of the export/import menu. But you have to mark their names beforehand, as ENG|030704 | 5| I| described under ##030702Exporting^Forms/Named^Requests. ENG|030704 | 7|RI| Striking the DELETE key will delete all the marked forms/named requests.