The following example displays the default settings and change the default settings with one SET statement: DTR> SHOW SET_UP Set-up: Columns_page: 80 No abort Prompt No search Form No verify No semicolon No lock_wait NULLs support Application keypad mode DTR> SET COLUMNS_PAGE = 132, ABORT, NO PROMPT, SEARCH, [Looking for SET option] CON> 9 NO FORM, VERIFY, SEMICOLON, LOCK_WAIT, NO APPLICATION_KEYPAD DTR>SHOW SET_UP Set-up: Columns_page: 132 Abort No prompt Search No form Verify Semicolon Lock_wait NULLs support Numeric keypad mode DTR> The following example sets your default dictionary directory at CDD$TOP and uses a variety of path names to change your default directory: DTR> SET DICTIONARY CDD$TOP DTR> SET DICTIONARY DTR$LIB.DEMO DTR> SHOW DICTIONARY The default directory is CDD$TOP.DTR$LIB.DEMO DTR> SHOW DICTIONARIES Dictionaries: DTR> SET DICTIONARY -.-; DTR> SHOW DICTIONARY The default directory is CDD$TOP DTR> SET DICTIONARY CDD$TOP.DTR32 Element "CDD$TOP.DTR32.JONES" not found in dictionary. DTR> SET DICTIONARY CDD$TOP.DTR32.TEST DTR> SHOW DICTIONARIES Dictionaries: DTR> SET DEF -; SHOW DICTIONARY The default directory is CDD$TOP.DTR32 DTR> SHOW DICTIONARIES Dictionaries: AWS BRADS BRENT DBF DDD DEMO DENN DETRIC DUNCAN JAS KELLERMAN LANDAU MARISON PLOTS STRONG TEST WAYNE DTR> SET DICTIONARY WAYNE DTR> SET DICTIONARY DISK1:[SWANSON.DTRWORK]TEST.NEWDICT DTR> The following example uses the SET SEARCH command to walk sets in a Oracle CODASYL DBMS database: DTR> READY SUPPLIES, VENDORS, PART_S DTR> SET SEARCH DTR> PRINT VEND_NAME, PART_DESC OF [Looking for name of domain, collection, or list] CON> VENDORS WITH VEND_NAME = "QUALITY COMPS" Not enough context. Some field names resolved by Context Searcher. --------------Vendor Name--------------- QUALITY COMPS VT100 KEYBOARD ASSY NUMERIC KEYPAD FRAME VT52 HOUSING When SET SEARCH is not in effect, you need to provide explicitly the inner print lists to give DEC DATATRIEVE the necessary context, as follows: DTR> SET NO SEARCH DTR> PRINT VEND_NAME, ALL ALL PART_DESC OF PART_S OWNER OF [Looking for set name] CON> PART_INFO OF SUPPLIES MEMBER OF VENDOR_SUPPLY OF [Looking for name of domain, collection, or list] CON> VENDORS WITH VEND_NAME = "QUALITY COMPS" --------------Vendor Name--------------- QUALITY COMPS VT100 KEYBOARD ASSY NUMERIC KEYPAD FRAME VT52 HOUSING DTR>