|
|
If the BMC Catalog Manager interface is installed at your site, you can use ACCESS to browse and edit tables, views, synonyms, and local aliases from the lists displayed by the Catalog Manager. As distributed, the interface consists of the following commands. In the following text, the term 'table' refers to tables, views, synonyms, and local aliases. BR Browse a table. When you browse a table using the ACCESS Choose a DB2 Table/View to Browse, your response to the BEGIN EDIT SESSION WITH prompt on that panel is profiled. If your last response was:
ED Edit a table. Your session begins with table data or a prompt for selection criteria or column attributes, depending on your last edit session, as described above for the BR command. BRS Specify selection criteria prior to browsing a table. EDS Specify selection criteria prior to editing a table. Since the command names can be changed during installation, verify the command names assigned at your site. Primary commands and line commands are available. Primary Commands The primary commands available to invoke ACCESS can be entered from any list. Assume the commands BR and ED are in effect. To invoke an edit session for the CUSTOMERS table from a displayed list of tables, enter the command as: ED CUSTOMERS To invoke ACCESS for an object type other than that of the current list, enter the object type with the command. For example, to invoke an ACCESS edit session for the CUSTOMERS table while displaying a list of databases, enter: ED TABLE CUSTOMERS Line Commands Assume the line commands BR and ED are in effect. To browse the data in the table named SOFTECH.DEPT enter the line command as shown in the following figure. Figure Interfacing Catalog Manager with ACCESS ¦TDB2------------------------ Table List -------------------ROW 1 TO 8 OF 8 ¦ COMMAND ===> SCROLL ===> PAGE ¦ ¦ LISTS AL CL CO DB DS FK IC IX KC MX PA PK PL RI SG SY TM TS TT UA US VW ¦ ¦ LIKE: SOFTECH.% ¦ Cmd Table Name Database Tblspace Cols Prim Rows Pages ¦----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v ¦ SOFTECH.CUSTOMERS DSOFTECH SSOFTECH1 6 -1 -1 ¦ BR SOFTECH.DEPT DSOFTECH SSOFTECH1 4 1 9 1 ¦ SOFTECH.DETAILS DSOFTECH SSOFTECH1 4 2 -1 -1 ¦ SOFTECH.ITEMS DSOFTECH SSOFTECH1 6 1 -1 -1 ¦ SOFTECH.ORDERS DSOFTECH SSOFTECH1 7 -1 -1 ¦ SOFTECH.PROJ DSOFTECH SSOFTECH1 8 1 20 1 ¦ SOFTECH.SALES DSOFTECH SSOFTECH1 7 33 1 ¦ SOFTECH.TCUST DSOFTECH SSOFTECH1 6 -1 -1 +---------------------------------------------------------------------------- Once the command is entered, an ACCESS browse or edit session, as requested, is invoked. All of the ACCESS facilities are available. You can join tables, modify the selection and sort criteria, and save your specifications as an Access Definition. A message, ">> ACCESS ENDED << is displayed on the BMC Catalog Manager table list when you terminate the ACCESS session and return to the Catalog Manager. zurück |
