HP 3000 Manuals HP 3000 Manuals
Project Items Screen Use this screen to edit the list of items in the table. This screen shows all items from the source tables and which items are to be projected from the table.To review the list of items 1. Use Prev Item or Next Item to review the list of items or use quick browse. See Chapter 1 for details about quick browse. To project items from a table 1. Type X in the Project field to project an item . 2. You can type an alias name for any item in the Alias Name field. This alias name will then be used in the report. For a joined table, the alias name must be unique within the selected items for this table. For a merged table, items with the same alias name appear as the same item in the new table. 3. Press Enter. To exclude items from projection 1. Blank out the X in the Project field for any item you want excluded from projection. 2. Press Enter. Banner Line Displays the table name and type of combination for this table, either J (join) or M (merge). Field Descriptions Item Display. All items from the source tables in alphabetical order. Source Table Display. For items located in the source tables, the source is listed. For a table calculated item, this field is left blank. Type Display. The type of this item. Project An X for all items to be projected from the table. The defaults are as follows: * For a joined table, all items must have unique names. If they do not have unique names, specify aliases for them (see below). * For a merged table, items with identical names are projected as the same item. Alias Name Optional. The name of the item to be used outside the table. * For a joined table, if the name of an item in a table is different from its name in the source table, this column contains the name to be used after projection from the table. It must be a unique name within projected items in the table. * For a merged table, an item can have the same alias name if it is from a different source table; that is, you must give items from different source tables the same alias name if they are to be treated as one item after projection. NumPrec Optional. The numeric precision of an item, if you want it changed after the item is projected. This consists of a number and a method code. Valid number ranges are as follows: Item Type Number --------------------------------------------------------------------------------------- N: -6 to 12 I: 0 to 8 R: -90 to 76 The method code indicates how superfluous digits are treated: Method Code Digits are: --------------------------------------------------------------------------------------- R rounded T truncated C ceiled See the description of setting precision, including the special cases for Real precision, in Chapter 15 .
NOTE Project, Alias Name, and NumPrec only apply outside the table, for example, in a report layout definition, or if the table is used as source table, in another table. Therefore, if items have the same name and any are used in a formula for a table calc item, the name must be qualified with the source table name. For example, suppose you have two items named ORDER-DETAILS, one in the Quanty table and one in the Orders table. You have given one of the items an alias name so the two items are not confused in the final report. However, you want to use one of the items in a formula for a table calc item. You can't use the alias name. You must use the original item name, and qualify it with the source table name, like this: ORDER-DETAILS.QUANTITY. For HP ALLBASE/SQL source tables, the owner name is not necessary; only the table name is used.
NOTE Source tables which are IMAGE data sets, KSAM files, or MPE files always have the item TABLE-REC-NUMBER included in the result table, in addition to their other items. HP ALLBASE/SQL tables do not have the item TABLE-REC-NUMBER included. TABLE-REC-NUMBER provides the logical record number in that data set or file.
![[]](../../pic3k/M011795/FFN1963c50.gif)