Download eShell
Transcript
User’s Manual eShell Example 12-1. Query the QUAD4 Relation. eSh> SELECT * FROM QUAD4; EID -------1 2 3 4 PID -------1 2 1 2 G1 -------1 2 3 4 G2 -------2 3 4 5 G3 -------7 8 9 10 G4 -------6 7 8 9 .... 4 Entries Selected Any or all columns of the query results may be titled by using the command: SET COLUMN attribute_name column_options ; where column_options are a list of one or more options describing the manner in which the column will be printed. These options include: column_option ⇒ [ [ [ [ heading_info ] format_info ] justification ] TEMP ] [ CLEAR ] Each of these options will be described in detail below. When you change the title of an attribute, this change remains in effect for your entire eShell session, or until you issue the SET COLUMN command with the CLEAR option. If you want a title to remain in effect for only the next query, you may specify the TEMP option when you issue the SET COLUMN command. The heading_info is a string defining the title that you wish placed on the column. Its format is: column_option ⇒ [ heading_info ] [ format_info ] [ justification ] [ TEMP ] [ CLEAR ] ’string’ heading_info ⇒ LABEL ’multi _line_title’ where a string may be any sequence of characters with or without embedded blanks. A multi_line_title is specified by separating the lines with the slash (/) character as will be shown in the next example. Should the slash character itself be wanted in the label, then two consecutive slashes (//) are entered. The optional justification parameter specifies the manner in which the title will be justified over the column. 12-2 REPORT GENERATION