Piper's Pit BBS/FTP: ibm 0010

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

/ Piper's Pit BBS/FTP: ibm 0010 - 0019 / ibm0010-0019 / ibm0010.tar / ibm0010 / PROCINST.ZIP / HELP.ZIP / TABMOD.HLP < prev next >

Wrap

Text File | 1990-08-10 | 28.5 KB | 826 lines

0e014f0a3dd04000000000000000000000000001 082c240a3dd04000000000000000000000000002 DEVICE SELECTION Select the printer or device you want to use to print the documentation and press <Enter>. Press <Esc> to return to the previous menu. 101131083dd04000000000000000000000000003 09014f0f3dd04000000000000000000000000004 DOCUMENTATION MENU You can print the program documentation. Select Printer: Choose the printer you will use to print the documentation and PRO-C will include the appropriate control characters and escape sequences in the generated document. Select Device: Choose the output device for the document. The output devices listed are the devices detected by the Project Manager. Print the Report: This option creates the report and sends it to the appropriate device. Check Paper Alignment: The Alignment option sends a test page to the printer. 0c01500c3dd04000000000000000000000000005 0c01500c3dd04000000000000000000000000006 0c01500c3dd04000000000000000000000000007 0c01500c3dd04000000000000000000000000008 0c01500c3dd04000000000000000000000000009 0c01500c3dd0400000000000000000000000000a 0c01500c3dd0400000000000000000000000000b 02014f0e3dd0400000000000000000000000000c VIEWING A DOCUMENT You can browse through a document that was printed to a file. Press <PgDn> to move one screen down in the report. Press <PgUp> to move one screen up in the report. Use the <Up> and <Dn> arrow keys to move one line at a time. <Home> moves to the top of the report. <End> moves to the end of the report. Press <Esc> to return to the Document menu. 070150113dd0400000000000000000000000000d 070150113dd0400000000000000000000000000e 0c01500c3dd0400000000000000000000000000f 070150113dd04000000000000000000000000010 0c01500c3dd04000000000000000000000000011 0c01500c3dd04000000000000000000000000012 030150073dd04000000000000000000000000013 FILE The File menu allows you to create, open, save, copy, rename, and delete table definitions. You can import and export table definitions, shell to the operating system, or exit to the Project Manager. 0c01500c3dd04000000000000000000000000014 0c01500c3dd04000000000000000000000000015 0c01500c3dd04000000000000000000000000016 0c01500c3dd04000000000000000000000000017 0c01500c3dd04000000000000000000000000018 0c01500c3dd04000000000000000000000000019 0c01500c3dd0400000000000000000000000001a 0c01500c3dd0400000000000000000000000001b 0c01500c3dd0400000000000000000000000001c 0c01500c3dd0400000000000000000000000001d 0c01500c3dd0400000000000000000000000001e 0c01500c3dd0400000000000000000000000001f 030150133dd04000000000000000000000000020 12222f053dd04000000000000000000000000021 0c01500c3dd04000000000000000000000000022 030150153dd04000000000000000000000000023 TABLE FILE MAINTENANCE <F2> Open a window on the Element file this table is based on. <F4> Change the key status of the current element. <F5> or <A> Add new elements to the table. <F6> or <D> Delete an element from the table. <F7> or <C> Change the description, occurrences, or key field for the current element. <F8> or <T> Tag an element to change its position in the table. <Esc> Return to the Main menu of the Table Definition Module. <F2> Alter Element File You can add or change elements in the Element file this table is based on without leaving the Table Definition Module. <F2> opens a window on the element file to allow you to change it. Changes to existing elements will be reflected immediately in the table file. Any new elements you create must be added separately to the table file. <F4> Key Pressing <F4> allows you to change the key status of the current element. Every table must have at least one keyed field. <F5> or <A> Add mode Add mode allows you to add elements to the table. A window lists the elements in the associated element file. <F6> or <D> Delete Pressing <F6> or <D> tags an element for deletion from the table file. The element will be deleted when the file is saved. Until you save the file, you can "undelete" the element by positioning the pointer at the element and pressing <F6> or <D> again. <F7> or <C> Change mode Change mode allows you to change the descriptive name, occurrences, or key type for any element. To change an element, position the pointer beside it and press <F7> or <C>. If occurrences is greater than 1, you cannot change the key type. If key type is Unique or Duplicate, you cannot change occurrences. <F8> or <T> Tag Tagging elements allows you to change the order of the elements within the file. To tag an element, position the pointer beside it and press <T>. Once an element is tagged, you can move it or switch it with another element. <M> Move Position the pointer beside the element above the new location for the tagged element and press <M>. If you move a segmented key definition, it will return to the end of the file when the file is saved. <S> Switch Position the pointer beside the element which you want to switch with the tagged element and press <S>. The tagged element moves to the pointer location and the element at that position moves to the space vacated by the tagged element. If you switch a segmented key definition, it will return to the end of the file when the file is saved. <F8> or <T> Reset Tag Pressing <F8> or <T> a second time removes the tag. 0c01500c3dd04000000000000000000000000024 0c01500c3dd04000000000000000000000000025 0c01500c3dd04000000000000000000000000026 0c01500c3dd04000000000000000000000000027 0c01500c3dd04000000000000000000000000028 030f32073dd04000000000000000000000000029 OPEN Open calls an existing PRO-C table definition. A selection box displays the available table definitions. 040f33063dd0400000000000000000000000002a NEW New creates a new PRO-C table definition at the Header box. 050f2d053dd0400000000000000000000000002b SAVE Save stores the current table definition. 060f32063dd0400000000000000000000000002c SAVE AS Save as stores the current program under a new name. The old file retains its original name. 080f31063dd0400000000000000000000000002d COPY Copy duplicates a table definition. You must supply a name for the new file. 0b0f37063dd0400000000000000000000000002e RENAME Rename renames a table definition. You must supply a new name for the file. 0a0f26053dd0400000000000000000000000002f DELETE Delete erases a table definition. 0c0d41073dd04000000000000000000000000030 HEADER BOX The Header box allows you to view and edit the header of a table file which has already been created. The only header field you can change is the file structure. 0b0e40073dd04000000000000000000000000031 IMPORT FILE You can import element definitions from other files to the current file. You can import all the elements as a group or select elements individually for import. 0e0e430a3dd04000000000000000000000000032 EXPORT FILE The Export Station allows you to create a data definition file that can be used by other systems. The field names and characteristics are copied into file headers for the other file managers. You can export to dBASE III or ASCII delimited files. Exported files are stored in the RECORDS subdirectory with the file extension of .ASC or .DBF. 100f33053dd04000000000000000000000000033 SHELL Shell creates a window on the operating system. 110f28053dd04000000000000000000000000034 EXIT Exit returns to the Project Manager. 0c01500c3dd04000000000000000000000000035 0c01500c3dd04000000000000000000000000036 030150073dd04000000000000000000000000037 030150063dd04000000000000000000000000038 MAINTENANCE STATION The Maintenance Station is the place to choose the elements for the data table. You also define keys used for indexing the file here. 0c01500c3dd04000000000000000000000000039 0c01500c3dd0400000000000000000000000003a 0c01500c3dd0400000000000000000000000003b 030150073dd0400000000000000000000000003c DOCUMENT MENU The Document Menu allows you to create a report that documents the element definition file. You can choose from several output channels and devices or you can browse through the report. 0c01500c3dd0400000000000000000000000003d 0c01500c3dd0400000000000000000000000003e 030150063dd0400000000000000000000000003f KEYS STATION The Keys Station is the place to define segmented keys. Your segmented key can contain up to five elements or sub-strings. 0c01500c3dd04000000000000000000000000040 0c01500c3dd04000000000000000000000000041 030150053dd04000000000000000000000000042 0c01500c3dd04000000000000000000000000043 052623133dd04000000000000000000000000044 FILE SELECTION BOX Highlight the file you want to copy, rename, or delete. If you are copying or renaming a file, type in a new name and press <Enter> to complete the action. If you are deleting a file, press <Space> to mark the file and <Enter> to delete it. You can mark multiple files with <Space> and delete all the marked files at once. Press <Space> again to unmark a file. Press a letter to select the next file name beginning with that letter. <PgUp> moves up 6 files. <PgDn> moves down 6 files. <Home> moves to the top of the list. <End> moves to the bottom of the list. 052424133dd04000000000000000000000000045 052423133dd04000000000000000000000000046 0c01500c3dd04000000000000000000000000047 0c01500c3dd04000000000000000000000000048 0c01500c3dd04000000000000000000000000049 0c01500c3dd0400000000000000000000000004a 0c01500c3dd0400000000000000000000000004b 0c01500c3dd0400000000000000000000000004c 0c01500c3dd0400000000000000000000000004d 0c01500c3dd0400000000000000000000000004e 0c01500c3dd0400000000000000000000000004f 0c01500c3dd04000000000000000000000000050 0c01500c3dd04000000000000000000000000051 0c01500c3dd04000000000000000000000000052 03242d153dd04000000000000000000000000053 03242c153dd04000000000000000000000000054 0c01500c3dd04000000000000000000000000055 030150063dd04000000000000000000000000056 KEYS STATION The Keys Station is the place to define segmented keys. Your segmented key can contain up to five elements or sub-strings. 0c01500c3dd04000000000000000000000000057 0c01500c3dd04000000000000000000000000058 0c01500c3dd04000000000000000000000000059 0c01500c3dd0400000000000000000000000005a 0c01500c3dd0400000000000000000000000005b 0c01500c3dd0400000000000000000000000005c 0a1f2f0e3dd0400000000000000000000000005d IMPORTING dBASE III FILES You can import dBASE III/III+ data file definitions (.DBF files) into the Table Module. PRO-C looks for these files in the EXE subdirectory. Logical fields (type L) must be converted to Character fields (type C) before you import the dBASE file. In addition, the field you will use as the unique key must be in the first index field. 0b1f320d3dd0400000000000000000000000005e IMPORTING PRO-C TEMPLATE FILES PRO-C template files (.TPL files) are data definition files created by PRO-C version 1.3x. PRO-C looks for .TPL files in the RECORDS subdirectory. The element prompts and data types are copied from the original file. Key status is set to N and format masks are set to the default for the data type. The Occurrence field is set to 1. 0c01500c3dd0400000000000000000000000005f 0a1f320e3dd04000000000000000000000000060 IMPORTING TABLE FILES You can combine PRO-C table files or copy tables for new projects by importing an existing table file into the current file. The imported file must have the same controlling element file as the current file. PRO-C looks for the file in the RECORDS subdirectory. Elements are imported exactly as they are defined in the source file, including key status and occurrences. 091f2f0e3dd04000000000000000000000000061 IMPORTING ASCII DELIMITED FILES You can import table definitions that are straight ASCII text. PRO-C looks for ASCII files (extension .ASC) in the RECORDS subdirectory. The ASCII file must contain all the field information in correct order. Fields must be separated by commas. Character fields must begin and end with quotation marks. 0c01500c3dd04000000000000000000000000062 0b20310d3dd04000000000000000000000000063 IMPORTING PARADOX FILES You can import table definitions from Paradox files. The Paradox files must be stored in the RECORDS subdirectory. In order for the key fields to be imported correctly, the primary key must be the first field in the Paradox file. Any compound keys you have defined in Paradox must be composed of contiguous fields. 0b1f31093dd04000000000000000000000000064 EXPORTING dBASE III FILES You can export the table file definition to a file which can be used by dBASE III/III+. The exported file will be stored in the EXE subdirectory with a file extension of .DBF. You must supply a file name. 0c1f320c3dd04000000000000000000000000065 EXPORTING ASCII FILES You can export the table file definition to a file in ASCII format. The exported file will be stored in the RECORDS subdirectory with a file extension of .ASC. You must supply a file name. All elements are exported as type "N" and segmented keys are not included. 0c01500c3dd04000000000000000000000000066 0c01500c3dd04000000000000000000000000067 0c01500c3dd04000000000000000000000000068 0c01500c3dd04000000000000000000000000069 0c01500c3dd0400000000000000000000000006a 0c01500c3dd0400000000000000000000000006b 0c01500c3dd0400000000000000000000000006c 0c01500c3dd0400000000000000000000000006d 0c01500c3dd0400000000000000000000000006e 0c01500c3dd0400000000000000000000000006f 0c01500c3dd04000000000000000000000000070 0c01500c3dd04000000000000000000000000071 0c01500c3dd04000000000000000000000000072 0c01500c3dd04000000000000000000000000073 0c01500c3dd04000000000000000000000000074 0c01500c3dd04000000000000000000000000075 0c01500c3dd04000000000000000000000000076 0c01500c3dd04000000000000000000000000077 0c01500c3dd04000000000000000000000000078 0c01500c3dd04000000000000000000000000079 0c01500c3dd0400000000000000000000000007a 0c01500c3dd0400000000000000000000000007b 0c01500c3dd0400000000000000000000000007c 0c01500c3dd0400000000000000000000000007d 0c01500c3dd0400000000000000000000000007e 0c01500c3dd0400000000000000000000000007f 0c01500c3dd04000000000000000000000000080 0c01500c3dd04000000000000000000000000081 0c01500c3dd04000000000000000000000000082 0c01500c3dd04000000000000000000000000083 0c01500c3dd04000000000000000000000000084 0c01500c3dd04000000000000000000000000085 0c01500c3dd04000000000000000000000000086 0c01500c3dd04000000000000000000000000087 0c01500c3dd04000000000000000000000000088 0c01500c3dd04000000000000000000000000089 0c01500c3dd0400000000000000000000000008a 0c01500c3dd0400000000000000000000000008b 0c01500c3dd0400000000000000000000000008c 061040073dd0400000000000000000000000008d ELEMENT NAME Enter a name for the element and press <Enter>. The name must be unique within the element file and can contain up to ten alphabetic characters. 050140133dd0400000000000000000000000008e FORMAT MASK The format mask determines how the data stored in the element is displayed on screens and in reports. There are special mask characters for character, numeric, and date fields. The following characters have special meanings in masks for numeric elements. Z,z hide leading and trailing zeros 9 show leading and trailing zeros 8 floating decimal point + show "+" if positive, "-" if negative - show "-" if negative . decimal place location , thousands separator ( bracket negative integers ) bracket negative integers $ currency symbol All other characters are output literally. Character fields use different mask characters. A,a alphabetic and space only B alphabetic only, lower case C alphabetic only, lower case c alphanumeric and space, lower case I any ASCII character P alphanumeric and space, upper case p alphanumeric and space Q alphanumeric and space, lower case X,x alphanumeric, punctuation, and space only All other characters in the mask are output literally. Date mask characters must be in upper case. DD date MM month number YY year's last two digits HH hour NN minute SS second Characters entered in password fields are not displayed on screen. They are always represented by "*". <Enter> stores the current mask and moves to the next field. <Tab> moves to the previous field. <Ins> toggles between insert and overtype. <Esc> returns to the Main menu. 040132133dd0400000000000000000000000008f LENGTH The element length is the number of bytes used to store it. For character elements, this is equivalent to the number of characters the element can hold. Character fields (types A, C, and P) can hold a maximum of 254 characters and have a default length of 1. Date, numeric, and memo fields have fixed lengths. <Enter> stores the current length and moves to the next field. <Tab> moves to the previous field. <Del> deletes the current digit. <Esc> returns to the Maintenance prompt ">". 042e23133dd04000000000000000000000000090 DESCRIPTIVE NAME The descriptive name serves as the default prompt in screens and reports and provides a meaningful description of the element. The default descriptive name is the element name. Press <Enter> to accept the default value. Type a new name in and press <Enter> to provide another name. The new name can contain up to 30 characters. <Ins> toggles between insert and overtype mode. <Tab> moves to the previous field. <Esc> returns to the Maintenance prompt ">". 04012b143dd04000000000000000000000000091 TYPE The data type determines the data the field can hold. Special numeric, date, and character types are available. Press <F2> to call up a list of data types. Enter a data type and press <Enter> to move to the next field. <Tab> moves to the previous field. <Esc> returns to the Maintenance prompt ">'. Types A, C, E, and P are character fields. Numerals entered in character fields cannot be used in calculations. Types B, D, I, L, M, N, and R are numeric fields. Their lengths are fixed. The same is true of the date fields, T and Y. 050148133dd04000000000000000000000000092 06014c103dd04000000000000000000000000093 0523280c3dd04000000000000000000000000094 SELECT FILE Select a file to operate on and press <Enter>. Typing a letter selects the next file that begins with that letter. <Esc> returns to the previous menu. 0c01500c3dd04000000000000000000000000095 0c01500c3dd04000000000000000000000000096 08222f093dd04000000000000000000000000097 TABLE FILE NAME Type in a name for the table file and press <Enter>. The table file name must be a valid file name for your operating system. <Esc> returns to the File menu. 080b320a3dd04000000000000000000000000098 SAVE AS FILE NAME Type in a valid file name for your operating system and press <Enter>. The file will be saved in the RECORDS subdirectory with this name. <Esc> returns to the File menu. 08232e0c3dd04000000000000000000000000099 ELEMENT FILE NAME Select an element file and press <Enter>. <Esc> returns to the Header box. Any changes made in the element file you select will be reflected in this table. 0a014f0e3dd0400000000000000000000000009a DESCRIPTIVE NAME The Descriptive Name provides the table file with a more useful name than the file name. The Descriptive Name can contain up to 30 characters; any character is valid. The default descriptive name is the table file name followed by the word TABLE. Press <Enter> to accept the default Descriptive Name. Type in a new name and press <Enter> to change the name. <Esc> returns to the File menu. 07321e083dd0400000000000000000000000009b DATA FILE MANAGER Select the file manager that corresponds to the file manager you are using and press <Enter>. 0c01500c3dd0400000000000000000000000009c 060147123dd0400000000000000000000000009d OCCURRENCES Press <Enter> to accept the default value of 1 or type in the number of occurrences for the current element and press <Enter>. The maximum value is 99. The Occurrences field determines how many times a field appears in a record. For example, you may have an ADDRESS element for company addresses. If you want to provide three lines on the screen for the address, set Occurrences to three. This is an alternative approach to having three separate address fields. Elements with multiple occurrences cannot be keyed or used as part of a segmented key When a field has more than one occurrence, extra occurrences appear in screens and reports (and are stored in data files) as separate fields. In the example given above, the original element was named ADDRESS, and the other occurrences would be known as ADDRES02 and ADDRES03. Field names are truncated if required. 041c2f143dd0400000000000000000000000009e KEY STATUS Key fields are used by the file manager to find records in a file. Unique keys require a unique value for each record in the data file. Duplicate keys allow several records to have the same key value. Every table must have at least one Unique or Duplicate field. By default, fields are classed as N, Not a Key. Segmented keys can be classed as Unique or Duplicate; they default to D, Duplicate. Press <Enter> to accept the default key type. Press <F2> to call a list of key types. <Esc> returns to the Main menu. 0c01500c3dd0400000000000000000000000009f 03252a153dd040000000000000000000000000a0 SEGMENT SELECTION Choose a field for the segment and press <Enter>. Typing a letter moves to the next field that begins with that letter. <Esc> returns to the Main menu. If the element is a character field, you can use the whole element or a sub-string of it in a segmented key. Date and numeric elements cannot be broken down into sub-strings. Elements used in segmented keys must have Occurrences set to 1. You can combine elements of different types in a segmented key. 03012a153dd040000000000000000000000000a1 SEGMENT SUB-STRING SELECTION You must indicate how much of the element you want to use as a segment. To select the entire element, press <Enter> twice. To indicate the start of the sub-string, position the '*' pointer at the start location and press <Enter>. To indicate the end of the sub-string, position the '*' pointer at the end location and press <Enter>. Press <Esc> to use the end of the element as the end of the sub-string. 042927143dd040000000000000000000000000a2 MODIFYING SEGMENTED KEYS You can modify individual segments of the key you have defined. Press <F2> to change the field used in the current segment. Press <F3> to change the sub- string used in the current segment. Press <F6> to delete the current segment from the segmented key. To delete the entire segmented key, return to the Maintenance Station and delete the key with <F6>. 03212e0c3dd040000000000000000000000000a3 ASCII FILE NAME Enter a valid file name for your operating system and press <Enter>. The file will be given the file extension .ASC and stored in the RECORDS subdirectory. <Esc> returns to the Export file type menu. 031f320c3dd040000000000000000000000000a4 EXPORT TO dBASE Enter a valid file name for your operating system and press <Enter>. The file will be given the file extension .DBF and stored in the RECORDS subdirectory. <Esc> returns to the Export file type menu. 0c242d0c3dd040000000000000000000000000a5 SELECT IMPORT FILE NAME Highlight the file you want to import and press <Enter>. Press <Esc> to return to the Import menu. <PgUp> moves up 6 files. <PgDn> moves down 6 files. <Home> moves to the top of the list. <End> moves to the end of the list. 0c01500c3dd040000000000000000000000000a6 0c01500c3dd040000000000000000000000000a7 0f1b26083dd040000000000000000000000000a8 0e01500a3dd040000000000000000000000000a9 0f0150093dd040000000000000000000000000aa 0e01500a3dd040000000000000000000000000ab 0a012a083dd040000000000000000000000000ac DUPLICATE ELEMENTS You have tried to import an element with the same name as an element already in the file. You have five options: Ignore the duplicate element: The duplicate element is not imported except from dBASE files. For dBASE files, the name of the file in which the duplicate occurred is added to the descriptive name and the element is imported with the new name. Replace the existing element: The element in the current file is deleted and the duplicate element is imported. Rename the NEW element: The element in the current file is left unchanged, and you are prompted for a new name for the imported element. Rename the OLD element: You are prompted for a new name for the element already in the file, and the duplicate element is imported using its existing name. Abort importation of this file: Importing elements is halted and you return to the import file type menu. Elements already imported remain in the file. 0c01500c3dd040000000000000000000000000ad DUPLICATE ELEMENT FOUND You have tried to import an element with the same name as an element already in the file. You have five options: Ignore the duplicate element: The duplicate element is not imported except from dBASE files. For dBASE files, the name of the file in which the duplicate occurred is added to the descriptive name and the element is imported with the new name. Replace the existing element: The element in the current file is deleted and the duplicate element is imported. Rename the NEW element: The element in the current file is left unchanged, and you are prompted for a new name for the imported element. Rename the OLD element: You are prompted for a new name for the element already in the file, and the duplicate element is imported using its existing name. Abort importation of this file: Importing elements is halted and you return to the import file type menu. Elements already imported remain in the file. 040128133dd040000000000000000000000000ae 060128113dd040000000000000000000000000af SELECT ELEMENTS FROM ELEMENT FILE The window on the right side of the screen shows the elements in the element file. Any elements already in the table file are highlighted. Position the pointer beside an element you want to include and press <Space>. <Esc> returns to the Main menu. Each element can appear only once in a table. 080150103dd040000000000000000000000000b0 ELEMENT FILE GATEWAY You are operating on the element file associated with the table file. You cannot delete elements using this gateway. Press <F5> or <A> to add new elements to the element file. Press <F7> or <C> to change existing elements. Any changes you make will automatically be reflected in the table file. <Esc> returns to the table file. WARNING! If you change an element file which has been used to create other table files, you may corrupt some of your data files. Any changes made to the element file are reflected in all table files controlled by this element file. 0c0150083dd040000000000000000000000000b1 0c01500c3dd040000000000000000000000000b2 0c01500c3dd040000000000000000000000000b3 0c0150083dd040000000000000000000000000b4 c01500c3ed0400000000000000000000000000b5