com!online 2002 April

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

/ com!online 2002 April / comcd0402.iso / vollver / adabas / f_0001 / env / workb.enh < prev next >

Wrap

Text File | 1999-11-01 | 25.7 KB | 354 lines

ENG|11 | 0 WORKB.enh 10.05.01 1998-04-24 ENG|11 | 1| | Workbench ENG|11 | 2| | --------- ENG|11 | 4| M| #01Action^Bar ENG|11 | 5| M| #02Function^Keys ENG|11 | 6|RM| #03Commands ENG|1101 | 1| | Action Bar ENG|1101 | 3| | The action bar can be activated in various ways. ENG|1101 | 5| | - Each menu item can be selected directly by simultaneously ENG|1101 | 6| | pressing the highlighted letter and the control key. ENG|1101 | 8| | - Pressing the F12-key activates the first menu item. The cursor ENG|1101 | 9| | keys left/right activates the adjacent pulldown menu. ENG|1101 | 11| | The function of a menu item can be called by positioning the cursor and ENG|1101 | 12|R | pressing the ENTER key or by pressing the highlighted letter. ENG|1102 | 1| | Function Keys ENG|1102 | 3| | Keys are assigned to the following functions: ENG|1102 | 5| | Key Function ENG|1102 | 7| | F1 Help ENG|1102 | 8| | F3 END or Back ENG|1102 | 9| | F4 Printing the currently shown workbench display ENG|1102 | 10| | F5 Starting the module or programm ENG|1102 | 11| | F8 Marking ENG|1102 | 12| | F9 Refreshing ENG|1102 | 13| | F12 Switching between action bar and form ENG|1102 | 14| | PgUp Scrolling one page up ENG|1102 | 15| | PgDn Scrolling one page down ENG|1102 | 16|R | CMD Activating the command line ENG|1103 | 1| | Workbench Commands ENG|1103 | 2| | ------------------ ENG|1103 | 4| I| ##11030102COMMENT ##11030210GETHIST ##11030104PRINT ##11030802TDROP ENG|1103 | 5| I| ##11030304COPY ##11030301GRANT ##11030302PRIVILEGES ##11030503TEST ENG|1103 | 6| I| ##11030401DEBUG ##11030601HELP ##11030703PSHOW ##11030602TIME ENG|1103 | 7| I| ##11030201DELETE ##11030306IMPORT ##11030206QUIT ##11030504TRACE ENG|1103 | 8| I| ##11030202DROP ##11030408LANGUAGE ##11030303REVOKE ##11030803TSHOW ENG|1103 | 9| I| ##11031001DOMAIN ##11030406LITERAL ##11030207RUN ##11030403USAGE ENG|1103 | 10| I| ##11030203EDIT ##11030209MKPRODUCT ##11030208SAVE ##11030505VALUES ENG|1103 | 11| I| ##11030405EWARN ##11030103MLIST ##11030407SET ##11030603VERSION ENG|1103 | 12| I| ##11030901EXEC ##11030404MONITOR ##11030402SOPT ##11030604XREF ENG|1103 | 13| I| ##11030204EXIT ##11030701PCREATE ##11030902SQL ENG|1103 | 14| I| ##11031002EXPRESS ##11030702PDROP ##11030205STORE ENG|1103 | 15|RI| ##11030305EXPORT ##11030101PLIST ##11030801TCREATE ENG|11030101 | 2| | PLIST ENG|11030101 | 4| | Produces a menu of all programs which the user may call. ENG|11030101 | 5| | These are either his own programs or that for which he ENG|11030101 | 6| | has got the implicit (PUBLIC) or explicit call privilege. ENG|11030101 | 8| | The specified arguments may contain wildcards ENG|11030101 | 9| | ( '*' for any character string, '?' for any character ). ENG|11030101 | 11| | Examples : PLIST *.* displays all programs which may be called. ENG|11030101 | 12| | PL C* displays only those programs of the user ENG|11030101 | 13| | which begin with 'C'. ENG|11030101 | 15| | Syntax : PList [<user>.] <program> [<version>] ENG|11030101 | 17|R | version : TEST|PROD|HIST|WORK|ALL ENG|11030102 | 1| | COMMENT ENG|11030102 | 3| | Entry or update of a comment of 38 characters at the most in the ENG|11030102 | 4| | program list. ENG|11030102 | 6| | Example : COMMENT customer ENG|11030102 | 7|R | Syntax : Comment <program> ENG|11030103 | 1| | MLIST ENG|11030103 | 3| | Displays a list of modules. ENG|11030103 | 5| | The specified program- and modulename may contain wildcards ENG|11030103 | 6| | ( '*' for any character string, '?' for any character ). The ENG|11030103 | 7| | searchstring specified by -p followed by type, status, or date will ENG|11030103 | 8| | limit the result list. The search string must be specified in the ENG|11030103 | 9| | format as it is indicated in the module list. The date must be preceded ENG|11030103 | 10|S | by '<','>' or '='. ENG|11030103 | 19| | Examples : MLIST customer.* ENG|11030103 | 20| | MLIST c?er.start ENG|11030103 | 21| | MLIST c* -p FORM ENG|11030103 | 22| | MLIST -p SAVE ENG|11030103 | 23| | MLIST *.start -p >90/12/24 ENG|11030103 | 24| | Syntax : MList <program> [.<module>] [<version>] ENG|11030103 | 25| | [-p <search string>] ENG|11030103 | 27| | version : TEST|PROD|HIST|WORK|ALL ENG|11030103 | 28| | search string: FORM|PROC|HELP|FUNC|DBPROC|TRIGGER ENG|11030103 | 29|S | EDIT|DEBUG|RUN|=date|<date|>date ENG|11030103 | 37| | Meaning of the columns in the MLIST index : ENG|11030103 | 38| | Program program name ENG|11030103 | 39| | Module module name ENG|11030103 | 40| | Type type of procedure ( FORM, PROC etc.) ENG|11030103 | 41| | Status RUN (executable) ENG|11030103 | 42| | DEBUG (executable, may be DEBUGGED) ENG|11030103 | 43| | EDIT (not executable) ENG|11030103 | 44| | ->DB (executable in the database kernel) ENG|11030103 | 45| | Version version id (TEST, PROD, HIST) ENG|11030103 | 46|R | Last Chan ge date/time of the last save. ENG|11030104 | 1| | PRINT ENG|11030104 | 3| | Prints one or more modules via the system printer. ENG|11030104 | 5| | Examples : PRINT customer.* ENG|11030104 | 6| | PRINT c?er.start ENG|11030104 | 7| | PRINT c* -p PROC ENG|11030104 | 8| | PRINT -p FUNC ENG|11030104 | 9| | PRINT *.start -p =90/12/24 ENG|11030104 | 10|R | Syntax : PRINt <program> [.<module>] [<version>] [-p <search string>] ENG|11030201 | 1| | DELETE ENG|11030201 | 3| | Deletes a module from the program. ENG|11030201 | 5| | Example : DEL customer.reservation ENG|11030201 | 6|R | Syntax : DELete <program>.<module> [<version>] [-p <search string>] ENG|11030202 | 1| | DROP ENG|11030202 | 3| | Drops a program. ENG|11030202 | 5| | Example : DROP customer ENG|11030202 | 6|R | Syntax : DRop <program> [<version>] ENG|11030203 | 1| | EDIT ENG|11030203 | 3| | Generates or modifies a module. In the commandline can call EDIT again ENG|11030203 | 4| | for editing a second module. Change between twice modules with '<' or ENG|11030203 | 5| | '>'. The command 'DOUBLE' split the screen horizontaly in two areas for ENG|11030203 | 6| | editing two modules at a time. ENG|11030203 | 8| I| More ##04Editor^information ENG|11030203 | 10| | Example : E customer.reservation ENG|11030203 | 11| | Syntax : Edit to generate a module. ENG|11030203 | 12| | Edit <program>.<module> [<version>] ENG|11030203 | 13|R | to modify a module. ENG|11030204 | 1| | EXIT ENG|11030204 | 3| | Leaves the SQL-PL development environment. If the EXIT command is used ENG|11030204 | 4| | in the editor, this will be left without saving the current source. ENG|11030204 | 6|R | Syntax : EXIT ENG|11030205 | 1| | STORE ENG|11030205 | 3| | Checks, translates and stores SQL-PL objects. ENG|11030205 | 5| | STORE enables the user to translate several procedures at the same ENG|11030205 | 6| | time. This function should be used when extensive modifications to ENG|11030205 | 7| | programs are to be made. ENG|11030205 | 9| | Inside the editor the function STORE can be used by a function key. It ENG|11030205 | 10| | will be saved only the actual editform. ENG|11030205 | 12| | If an error is detected during the check, this error will be marked in ENG|11030205 | 13| | the edit form and an error message will be output. Otherwise the new ENG|11030205 | 14| | version is stored and the EDIT mode is terminated. The stored module ENG|11030205 | 15|S | can be called with RUN. ENG|11030205 | 19| | Examples : ST customer.* ENG|11030205 | 20| | STO c?er.start ENG|11030205 | 21| | ST c* -p DEBUG ENG|11030205 | 22| | STORE -p SAVE ENG|11030205 | 23| | ST *.start -p <90/12/24 ENG|11030205 | 24|R | Syntax : STore <program> [.<module>] [<version>] [-p <search string>] ENG|11030206 | 1| | QUIT ENG|11030206 | 3| | Leaves the editor without saving the source text. The effects of ENG|11030206 | 4| | previous SAVE commands are preserved. ENG|11030206 | 6|R | Syntax : QUIT ENG|11030207 | 1| | RUN ENG|11030207 | 3| | Executes a module stored with STORE. ENG|11030207 | 5| | Default for <module> is START and for <owner> the own user name. The ENG|11030207 | 6| | specification of a program name is mandatory. Parameters can be ENG|11030207 | 7| | specified for RUN which will be assigned to the formal parameters of ENG|11030207 | 8| | the procedure. The parameter specification begins with a parenthesis; ENG|11030207 | 9| | the individual parameters are separated from each other by blanks. ENG|11030207 | 11| | Examples : RUN charles.customer.reservation ENG|11030207 | 12| | RUN customer.reservation ENG|11030207 | 13| | R customer ENG|11030207 | 14| | R customer -p charles miller ENG|11030207 | 15|R | Syntax : Run <owner>.<program>.<module> [<version>] [-p <parameters>] ENG|11030208 | 1| | SAVE ENG|11030208 | 3| | Serves to save a module without a syntax check. This function can only ENG|11030208 | 4| | be used in the editor. ENG|11030208 | 6|R | Syntax : SAVE ENG|11030209 | 1| | MKPRODUCT ENG|11030209 | 3| | Generates a PROD version from actual TEST version. An existing PROD ENG|11030209 | 4| | version is saved as HIST version. ENG|11030209 | 6|R | Syntax : MKproduct <program> ENG|11030210 | 1| | GETHIST ENG|11030210 | 3| | Cancels the release of a version, i.e. the historical version becomes a ENG|11030210 | 4| | production version again and the previous production version becomes ENG|11030210 | 5| | the test version. The command is rejected, if there are already modules ENG|11030210 | 6| | in the test version. ENG|11030210 | 8|R | Syntax : MKproduct <program> ENG|11030301 | 2| | GRANT ENG|11030301 | 4| | Grants privileges to other users. ENG|11030301 | 6| | Example : GRANT EXECUTE ON customer TO miller ENG|11030301 | 7| | GRA COP ON customer ENG|11030301 | 8| | Syntax : Grant Copy|Execute ON <program> TO <user> ENG|11030301 | 9| | Grant Copy ON <program> A menu of all users having a ENG|11030301 | 10| | copy privilege is displayed. ENG|11030301 | 11| | Grant Execute ON <program> A menu of all users having a ENG|11030301 | 12| | execute privilege is displayed. ENG|11030301 | 13| | Grant Copy|Execute ON <program> TO PUBLIC ENG|11030301 | 14| | Grants the implicit call privilege ENG|11030301 | 15|R | to all database users. ENG|11030302 | 1| | PRIVILEGES ENG|11030302 | 3| | Produces a list of all privileges which have been granted altogether or ENG|11030302 | 4| | for a particular program. ENG|11030302 | 6| | Example : PRIV customer ENG|11030302 | 7|R | Syntax : PRIVileges [<program>] ENG|11030303 | 1| | REVOKE ENG|11030303 | 3| | Withdraws call or import privileges. ENG|11030303 | 5| | Examples : REVOKE COPY ON customer FROM miller ENG|11030303 | 6| | REVOKE EXECUTE ON customer FROM PUBLIC ENG|11030303 | 7| | Syntax : ENG|11030303 | 8| | REVoke Copy|Execute ON <program> FROM <user> ENG|11030303 | 9| | Withdraws explicit privileges. ENG|11030303 | 10| | REVoke Copy|Execute ON <program> ENG|11030303 | 11| | A menu of all users who have a ENG|11030303 | 12| | privilege for this program is ENG|11030303 | 13| | displayed. ENG|11030303 | 14| | REVoke Copy|Execute ON <program> FROM PUBLIC ENG|11030303 | 15| | Privileges granted explicitly ENG|11030303 | 16|R | are preserved. ENG|11030304 | 1| | COPY ENG|11030304 | 3| | Copies a program of another user. ENG|11030304 | 5| | Example : COP customer FROM charles ENG|11030304 | 6| | Syntax : COPy <program> FROM <user> ENG|11030304 | 7| | COPy A menu of all programs which may ENG|11030304 | 8|R | be copied is displayed. ENG|11030305 | 1| | EXPORT ENG|11030305 | 3| | Saves a program in an operating system file. ENG|11030305 | 5| | The modules are separated by ENDMODULE. Granted privileges are exported ENG|11030305 | 6| | as workbench commands. ENG|11030305 | 8| | Example : EXPORT *.start menus.dat TEST -p EDIT ENG|11030305 | 9| | EXP customer cust.pl APP ENG|11030305 | 10| | Syntax : EXPort <program> [.<module>] <filename> ENG|11030305 | 11|R | [<version>] [APPEND] [-p <searchstring>] ENG|11030306 | 1| | IMPORT ENG|11030306 | 3| | Imports a program from an operating system file. ENG|11030306 | 5| | The individual modules are expected to be separated by ENDMODULE. The ENG|11030306 | 6| | specified privileges commands are executed. ENG|11030306 | 8| | Example : IMP customer.dat ENG|11030306 | 9|R | Syntax : Import <filename> [<version>] ENG|11030401 | 1| | DEBUG ENG|11030401 | 3| | The debug option (de)activates a flag for the SQL-PL interpreter. This ENG|11030401 | 4| | flag enables the interpreter to translate modules in such a way that ENG|11030401 | 5| | they can be processed with the debugger. DEBUG ON has the effect that ENG|11030401 | 6| | all modules translated subsequently will be capable of being debugged ENG|11030401 | 7| | (which will be indicated in the module list) and that the debugger will ENG|11030401 | 8| | be called when they are started with RUN. Default is DEBUG OFF. ENG|11030401 | 10| I| More ##0209Debug^information ENG|11030401 | 12| | Example : DEB ON ENG|11030401 | 13|R | Syntax : DEBug [ON|OFF] ENG|11030402 | 1| | SOPT ENG|11030402 | 3| | The SOPT command can be used to enable or disable the automatic SQL ENG|11030402 | 4| | syntax check. ENG|11030402 | 6|R | Syntax : SOpt [ON|OFF] ENG|11030403 | 1| | USAGE ENG|11030403 | 3| | With the USAGE command the maintenance of the used-relations in the ENG|11030403 | 4| | Data Dictionary can be enabled or disabled. ENG|11030403 | 6|R | Syntax : USage [ON|OFF] ENG|11030404 | 1| | MONITOR ENG|11030404 | 3| I| The MONITOR command enables the user to have ##1103040401information about the ENG|11030404 | 4| | runtime of a program displayed. ENG|11030404 | 6|R | Syntax : MONitor [ON|OFF] ENG|1103040401 | 1| | The following information is provided : ENG|1103040401 | 3| | - The total runtime of the program. ENG|1103040401 | 4| | - The number of database orders of the program. ENG|1103040401 | 5| | - The time required therefore. ENG|1103040401 | 6| | - The number of database orders of the SQL-PL interpreter. ENG|1103040401 | 7| | - The time required therefore. ENG|1103040401 | 8| | - The waiting time for user input. ENG|1103040401 | 9| | - The number of CALL and SWITCH calls. ENG|1103040401 | 10| | - Percentage of hits in main memory. ENG|1103040401 | 11| | - The number of hits in main memory. ENG|1103040401 | 12| | - The number of displaced procedures and forms. ENG|1103040401 | 13| | - The number of accesses to the overflow area of ENG|1103040401 | 14|R | variables. ENG|11030405 | 1| | EWARN ENG|11030405 | 3| | The EWARN command can be used to enable the option for ENG|11030405 | 4| | EDIT-WARNING. Then a message is output, when a program is ENG|11030405 | 5| | called and one or more modules of the same program have ENG|11030405 | 6| | the EDIT state. ENG|11030405 | 8|R | Syntax : EWarn [ON|OFF] ENG|11030406 | 1| | LITERAL ENG|11030406 | 3| | The LITERAL command can be used to enable or disable the LIT-CHECK ENG|11030406 | 4| | option for the SQLPL compiler. ENG|11030406 | 6| | When LIT-CHECK is on then searching a module for literal entries and ENG|11030406 | 7| | checking whether these are already entered in the literal table. If the ENG|11030406 | 8| | entry is missing, a form for defining the literal is displayed. ENG|11030406 | 10|R | Syntax : LITeral [ON|OFF] ENG|11030407 | 1| | SET ENG|11030407 | 3| | Has the effect that a form is displayed containing user-specific ENG|11030407 | 4| | default values ( language, date representation, ... ) relevant to ENG|11030407 | 5| | SQL-PL. A valid version (TEST,PROD,HIST) behind the SET command ENG|11030407 | 6| | switches to the typed version. ENG|11030407 | 8|R | Syntax : SET [<version>] ENG|11030408 | 1| | LANGUAGE ENG|11030408 | 3| | Language can be used to set a default language for the translation of ENG|11030408 | 4| | modules containing literals. For this purpose literals must have been ENG|11030408 | 5| | defined already. All languages that are defined for the user will be ENG|11030408 | 6| | displayed. The languages desired for the translation must be marked ENG|11030408 | 7| | with an 'X'. They are kept up to the next modification made by means of ENG|11030408 | 8| | the LANG command. ENG|11030408 | 10|R | Syntax : LANguage ENG|11030503 | 2| | TEST ENG|11030503 | 4| | Tests the module the source text of which is ENG|11030503 | 5| | currently edited. This function can only be ENG|11030503 | 6| | used in the editor. ENG|11030503 | 8| | If an error is detected during the syntax check, this ENG|11030503 | 9| | is marked in the edit form and an error message is ENG|11030503 | 10| | output. Otherwise the procedure is executed in a test ENG|11030503 | 11| | run, but it is not saved. ENG|11030503 | 13|R | Syntax : TEST ENG|11030504 | 1| | TRACE ENG|11030504 | 3| | Enables the MODULETRACE and SQLTRACE. This setting remains effective up ENG|11030504 | 4| | to the end of the called program. ENG|11030504 | 6|R | Syntax : TRACE ENG|11030505 | 1| | VALUE ENG|11030505 | 3| | Displays the variables of a program and their current values. ENG|11030505 | 5| | This command can only be used in edit mode - after execution of the ENG|11030505 | 6| | TEST function. ENG|11030505 | 8|R | Syntax : VALUE ENG|11030601 | 1| | HELP ENG|11030601 | 3| | Informs about the functions of the workbench, the SQL-PL language ENG|11030601 | 4| | syntax, REPORT and SQL commands. ENG|11030601 | 6|R | Syntax : HELP ENG|11030602 | 2| | TIME ENG|11030602 | 4| | Displays the current date and time. ENG|11030602 | 6|R | Syntax : TIME ENG|11030603 | 1| | VERSION ENG|11030603 | 3| | Displays the workbench version. ENG|11030603 | 5|R | Syntax : VERsion ENG|11030604 | 1| | XREF ENG|11030604 | 3| | Lists the variables of a program and their usage in modules of this ENG|11030604 | 4| | program. ENG|11030604 | 6| | Example : XREF customer ENG|11030604 | 7|R | Syntax : XREF <program> ENG|11030701 | 1| | PCREATE ENG|11030701 | 3| | Stores a DB procedure in the database kernel. The status indication in ENG|11030701 | 4| | the module list changes from 'RUN' to '->DB'. ENG|11030701 | 6| | Example : PCR customer.insert ENG|11030701 | 7|R | Syntax : PCreate <program>.<module> ENG|11030702 | 1| | PDROP ENG|11030702 | 3| | Removes the specified DB procedure from the kernel and resets the ENG|11030702 | 4| | status in the module list to 'RUN'. ENG|11030702 | 6| | Example : PDR customer.insert ENG|11030702 | 7|R | Syntax : PDrop <program>.<module> ENG|11030703 | 1| | PSHOW ENG|11030703 | 3| | Lists all programs of the user which in the kernel are known as DB ENG|11030703 | 4| | procedures. ENG|11030703 | 6| | Example : PS ENG|11030703 | 7|R | Syntax : PShow ENG|11030801 | 1| | TCREATE ENG|11030801 | 3| | Activates a trigger in the database kernel. The system asks for trigger ENG|11030801 | 4| | name, table name, columnname, and whenever rules. The status indication ENG|11030801 | 5| | in the module list changes from 'RUN' to '->DB'. ENG|11030801 | 7| | Example : TCR customer.insert ENG|11030801 | 8|R | Syntax : TCreate <program>.<module> ENG|11030802 | 1| | TDROP ENG|11030802 | 3| | Deactivates the specified trigger and resets the status in the module ENG|11030802 | 4| | list to 'RUN'. ENG|11030802 | 6| | Example : TDR customer.insert ENG|11030802 | 7|R | Syntax : TDrop <program>.<module> ENG|11030803 | 1| | TSHOW ENG|11030803 | 3| | Lists all triggers of the user which are active in the kernel. ENG|11030803 | 5| | Example : TS ENG|11030803 | 6|R | Syntax : TShow ENG|11030901 | 1| | EXEC ENG|11030901 | 3| | Serves to issue operating system commands. ENG|11030901 | 5|R | Syntax : EXEC <command> ENG|11030902 | 1| | SQL ENG|11030902 | 3| | Serves to issue database commands out of SQL-PL. After calling SQL a ENG|11030902 | 4| | window for the entry of DB queries is opened in the lower part of the ENG|11030902 | 5| | screen. The results of a query is displayed in a REPORT table. ENG|11030902 | 7|R | Syntax : SQL ENG|11031001 | 1| | DOMAIN ENG|11031001 | 3| | Domain is an independent tool for the management of database objects ENG|11031001 | 4| | and their relations (see the DOMAIN manual). ENG|11031001 | 6|R | Syntax : DOmain ENG|11031002 | 1| | EXPRESS ENG|11031002 | 3| | Express is a tool for generating of SQL-PL programs. ENG|11031002 | 5|R | Syntax : SQL