home *** CD-ROM | disk | FTP | other *** search
- ENG|08 | 0 REPORT.enh 10.05.01 1998-04-24
- ENG|08 | 1| |
- ENG|08 | 3| | R E P O R T F U N C T I O N S :
- ENG|08 | 5| | Positioning in the result table
- ENG|08 | 7| M| #07 BOTTOM branching to the end of the result table
- ENG|08 | 8| M| #06 TOP branching to the beginning of the result table
- ENG|08 | 9| M| #05 DOWN scrolling forward in the result table
- ENG|08 | 10| M| #04 UP scrolling backward in the result table
- ENG|08 | 11| M| #08 LEFT moving the displayed section to the left
- ENG|08 | 12| M| #09 RIGHT moving the displayed section to the right
- ENG|08 | 13| M| #10 POS positioning to any table column
- ENG|08 | 14| M| #11 TAB tabulator in a wide column
- ENG|08 | 15| M| #37 FIX fixing a column on the screen
- ENG|08 | 16|SM| #38 WINDOW REPORT screen output in a window
- ENG|08 | 19| | Format of the result table
- ENG|08 | 21| M| #28 RTITLE heading for the first output page
- ENG|08 | 22| M| #29 TTITLE heading for every output page
- ENG|08 | 23| M| #30 BTITLE footing for every output page
- ENG|08 | 24| M| #12 NAME renaming a column
- ENG|08 | 25| M| #13 NUMBER displaying the column numbers
- ENG|08 | 26| M| #43 LINENO displaying row numbers
- ENG|08 | 27| M| #15 EXCLUDE excluding columns from the result table display
- ENG|08 | 28| M| #16 INCLUDE redisplaying excluded columns
- ENG|08 | 29| M| #14 WIDTH changing the column width
- ENG|08 | 30| M| #17 SEPARATOR separator character between the table columns
- ENG|08 | 31| M| #18 GROUP grouping rows of the result table
- ENG|08 | 32| M| #40 LFEEDS controllable line feed at the end of group
- ENG|08 | 33| M| #39 PAGE controllable form feed at the end of group
- ENG|08 | 34|SM| #45 LONG displaying the beginning of CHAR LONG columns
- ENG|08 | 37| | Calculations based on values of the result table
- ENG|08 | 39| M| #20 SUBTOTAL calculations across grouped columns
- ENG|08 | 40| M| #21 PSUBTOTAL subtotals per page for long groups
- ENG|08 | 41| M| #19 TOTAL calculations across columns
- ENG|08 | 43| | Representing values in the result table
- ENG|08 | 45| M| #22 SET display of the control parameters
- ENG|08 | 46| M| #23 NULL represention of the NULL values
- ENG|08 | 47| M| #24 DECIMAL defining the representation of numbers
- ENG|08 | 48| M| #41 FORMAT formatted output of numbers
- ENG|08 | 49| M| #42 CRDB sign representation in account representations
- ENG|08 | 50| M| #26 LEAD leading characters for numeric values
- ENG|08 | 51| M| #27 TRAIL trailing characters for numeric values
- ENG|08 | 52| M| #25 PROTECT treatment of leading zeros
- ENG|08 | 53|SM| #34 ASCII ASCII representation of BYTE columns
- ENG|08 | 55| M| #35 EBCDIC EBCDIC representation of BYTE columns
- ENG|08 | 56| M| #36 HEXADEC hexadecimal representation of BYTE columns
- ENG|08 | 58| | Writing the result table to paper or disk
- ENG|08 | 60| M| #31 PRINT prints the current result table
- ENG|08 | 61| M| #32 CLOSE prints the contents of the spool area
- ENG|08 | 62| M| #33 PUT writes the current result table into a file
- ENG|08 | 64| | General commands
- ENG|08 | 66| M| #01 HELP displays explanations on the screen
- ENG|08 | 67| M| #44 DETAIL displays Master-Detail REPORT
- ENG|08 | 68| M| #46 ZOOM displays the content of a LONG column
- ENG|08 | 69| M| #47 DATE displays date and time
- ENG|08 | 70| M| #03 END leaves the REPORT mode
- ENG|08 | 71|RM| #02 EXIT terminates a QUERY session
- ENG|0801 | 1| |
- ENG|0801 | 3| | H E L P command :
- ENG|0801 | 5| | Displays explanations on the screen.
- ENG|0801 | 7| | SYNTAX : HELP [ <command name> ]
- ENG|0801 | 9| | HELP without command name displays a menu. HELP with
- ENG|0801 | 10|R | command name directly displays the pertinent information.
- ENG|0802 | 1| |
- ENG|0802 | 3| | E X I T command :
- ENG|0802 | 5| | Terminates a QUERY session.
- ENG|0802 | 7| | SYNTAX : EXIT
- ENG|0802 | 9| | EXIT leaves QUERY. All the modifications are recorded in
- ENG|0802 | 10|R | the database.
- ENG|0803 | 1| |
- ENG|0803 | 3| | E N D command :
- ENG|0803 | 5| | END leaves the REPORT mode.
- ENG|0803 | 7| | SYNTAX : END
- ENG|0803 | 9| | The END command leaves the REPORT mode. When leaving the
- ENG|0803 | 10| | REPORT mode, take into account that unnamed result tables
- ENG|0803 | 11|R | will not exist any more.
- ENG|0804 | 1| |
- ENG|0804 | 3| | U P command :
- ENG|0804 | 5| | Scrolling back in the result table.
- ENG|0804 | 7| | SYNTAX : UP [<n> | MAX ]
- ENG|0804 | 9| | The screen is a window to the result table. UP can be used
- ENG|0804 | 10| | for scrolling back one page, UP n can be used for scrolling
- ENG|0804 | 11| | back n lines, UP MAX can be used for scrolling back to the
- ENG|0804 | 12|R | beginning of the result table.
- ENG|0805 | 1| |
- ENG|0805 | 3| | D O W N command :
- ENG|0805 | 5| | Scrolling forward in the result table.
- ENG|0805 | 7| | SYNTAX : DOWN [<n> | MAX]
- ENG|0805 | 9| | The screen is a window to the result table. DOWN can be
- ENG|0805 | 10| | used for scrolling forward one page, DOWN n can be used for
- ENG|0805 | 11| | scrolling forward n lines, DOWN MAX can be used for
- ENG|0805 | 12|R | scrolling to the end of the result table.
- ENG|0806 | 1| |
- ENG|0806 | 3| | T O P command :
- ENG|0806 | 5| | Branching to the beginning of the result table.
- ENG|0806 | 7| | SYNTAX : TOP
- ENG|0806 | 9| | The screen is a window to the result table. TOP branches to
- ENG|0806 | 10|R | the beginning of the result table.
- ENG|0807 | 1| |
- ENG|0807 | 3| | B O T T O M command :
- ENG|0807 | 5| | Branching to the end of the result table.
- ENG|0807 | 7| | SYNTAX : BOTTOM
- ENG|0807 | 9| | The screen is a window to the result table. BOTTOM branches
- ENG|0807 | 10|R | to the end of the result table.
- ENG|0808 | 1| |
- ENG|0808 | 3| | L E F T command :
- ENG|0808 | 5| | Moving the displayed section to the left.
- ENG|0808 | 7| | SYNTAX : LEFT [<n>]
- ENG|0808 | 9| | The screen is a window to the result table. LEFT moves this
- ENG|0808 | 10| | window to the left. LEFT n moves the window n table columns
- ENG|0808 | 11| | to the left. LEFT without n moves the window one screen
- ENG|0808 | 12|R | width to the left.
- ENG|0809 | 1| |
- ENG|0809 | 3| | R I G H T command :
- ENG|0809 | 5| | Moving the displayed section to the right.
- ENG|0809 | 7| | SYNTAX : RIGHT [<n>]
- ENG|0809 | 9| | The screen is a window to the result table. RIGHT moves the
- ENG|0809 | 10| | window to the right. RIGHT n moves the window n table
- ENG|0809 | 11| | columns to the right. RIGHT without n moves the window one
- ENG|0809 | 12|R | screen width to the right.
- ENG|0810 | 1| |
- ENG|0810 | 3| | P O S command :
- ENG|0810 | 5| | Positioning to any table column.
- ENG|0810 | 7| | SYNTAX : POS <n>
- ENG|0810 | 9| | The POS command has the effect that the selected table
- ENG|0810 | 10| | column begins at the left margin. n is always the number of
- ENG|0810 | 11|R | the column in the original result table.
- ENG|0811 | 1| |
- ENG|0811 | 3| | T A B command :
- ENG|0811 | 5| | Tabulator in a wide column.
- ENG|0811 | 7| | SYNTAX : TAB <n>
- ENG|0811 | 9| | TAB positions within a column which is wider than the
- ENG|0811 | 10| | screen. The position specified by n is displayed at the
- ENG|0811 | 11|R | left margin of the screen.
- ENG|0812 | 1| |
- ENG|0812 | 3| | N A M E command :
- ENG|0812 | 5| | Renaming a column.
- ENG|0812 | 7| | SYNTAX : NAME <column> <new name> [CENTER]
- ENG|0812 | 9| | The NAME command can be used for defining new names for
- ENG|0812 | 10| | columns of the result table. <column> is the name or the
- ENG|0812 | 11| | number of the column to be modified.
- ENG|0812 | 13| | The old name cannot be used any more in subsequent REPORT
- ENG|0812 | 14| | commands. The new column name must not begin with a digit,
- ENG|0812 | 15| | it must not contain blanks, and it must be enclosed in
- ENG|0812 | 16|S | single quotes if lower case letters are to be included.
- ENG|0812 | 19| | If BLANK is inserted in place of <new name>, the column
- ENG|0812 | 20| | name will subsequently consist of blanks only. This special
- ENG|0812 | 21| | name only represents the column. It does not designate it.
- ENG|0812 | 22| | Therefore further operations can only be performed via the
- ENG|0812 | 23| | column number.
- ENG|0812 | 25| | '>' characters in new column names mean that the name is
- ENG|0812 | 26| | displayed in more than one row. The option CENTER has the
- ENG|0812 | 27| | effect that the new name is displayed in the middle of the
- ENG|0812 | 28| | column.
- ENG|0812 | 30| | The length of the name may have 40 characters at the most.
- ENG|0812 | 32| | Examples:
- ENG|0812 | 33| E|
- ENG|0812 | 34| E| NAME cno customer_no. | CUSTOMER_NO. |
- ENG|0812 | 35|SE| NAME cno 'Customer_No.' | Customer_No. |
- ENG|0812 | 37| E| NAME cno customer CENTER | CUSTOMER |
- ENG|0812 | 38| E| NAME cno customer>no. | CUSTOMER |
- ENG|0812 | 39|RE|
- ENG|0813 | 1| |
- ENG|0813 | 3| | N U M B E R command :
- ENG|0813 | 5| | Displaying the column numbers.
- ENG|0813 | 7| | SYNTAX : NUMBER ON | OFF
- ENG|0813 | 9| | NUMBER ON displays the column numbers in the original
- ENG|0813 | 10| | result table below the column names.
- ENG|0813 | 12| | These numbers can be used in REPORT commands instead of
- ENG|0813 | 13| | column names. NUMBER ON is in effect for the entire
- ENG|0813 | 14| | QUERY/REPORT session.
- ENG|0813 | 16|R | The default setting is NUMBER OFF.
- ENG|0814 | 1| |
- ENG|0814 | 3| | W I D T H command :
- ENG|0814 | 5| | Changing the column width.
- ENG|0814 | 7| | SYNTAX : WIDTH <column> [+|-] <n> [<m>]
- ENG|0814 | 8| | WIDTH * | <
- ENG|0814 | 9| | WIDTH [<column>] OFF
- ENG|0814 | 11| | The WIDTH command changes the width of columns. <column> is
- ENG|0814 | 12| | the name or number of the column to be modified.
- ENG|0814 | 14| | <n> specifies the new column width. If a sign is specified,
- ENG|0814 | 15| | the current width is increased or decreased by the
- ENG|0814 | 16| | indicated value. <m> indicates the number of rows into
- ENG|0814 | 17|S | which the values of the column are to be divided. <m> must
- ENG|0814 | 19| | not be greater than 8. Default is 1.
- ENG|0814 | 21| | * and < change the column width depending on the values in
- ENG|0814 | 22| | the columns. These changes apply to the entire table. Both
- ENG|0814 | 23| | options have only an effect on CHAR columns.
- ENG|0814 | 25| | < calculates the new column width in such a way that the
- ENG|0814 | 26| | longest value from the current buffer may be represented.
- ENG|0814 | 27| | The column header can be truncated, if necessary.
- ENG|0814 | 29| | * works in a similar way, but the column header is taken
- ENG|0814 | 30| | into consideration when computing the minimum lengths.
- ENG|0814 | 32| | OFF redisplays one or all columns with their default
- ENG|0814 | 33|R | widths.
- ENG|0815 | 1| |
- ENG|0815 | 3| | E X C L U D E statement :
- ENG|0815 | 5| | Excluding columns from the result table.
- ENG|0815 | 7| | SYNTAX : EXCLUDE [ALL BUT] <column>...
- ENG|0815 | 9| | EXCLUDE excludes columns from the display of the result
- ENG|0815 | 10| | table. The columns are defined either by their names or
- ENG|0815 | 11| | numbers. ALL BUT excludes all the columns except those
- ENG|0815 | 12|R | which have been specified.
- ENG|0816 | 1| |
- ENG|0816 | 3| | I N C L U D E command :
- ENG|0816 | 5| | Redisplaying excluded columns.
- ENG|0816 | 7| | SYNTAX : INCLUDE [ ONLY ] [<column>...]
- ENG|0816 | 9| | INCLUDE can be used for redisplaying columns which have
- ENG|0816 | 10| | been excluded from the display by EXCLUDE. INCLUDE without
- ENG|0816 | 11| | value includes all the columns. INCLUDE with a value only
- ENG|0816 | 12| | includes the specified columns.
- ENG|0816 | 14| I| INCLUDE ONLY has the same effect as ##0815EXCLUDE^ALL^BUT. Only
- ENG|0816 | 15| | those columns will be displayed which are specified in the
- ENG|0816 | 16|R | column list.
- ENG|0817 | 1| |
- ENG|0817 | 3| | S E P A R A T O R command :
- ENG|0817 | 5| | Separator character between table columns.
- ENG|0817 | 7| | SYNTAX : SEPARATOR <character string>
- ENG|0817 | 9| | The character string must be enclosed in single quotes if
- ENG|0817 | 10| | it contains blanks or lower case letters.
- ENG|0817 | 12| | The character string specified by the SEPARATOR command is
- ENG|0817 | 13| | only in effect for the current result table and does not
- ENG|0817 | 14| I| change the ##0822SET parameter. The length of the character
- ENG|0817 | 15| | string may be 20 characters at the most.
- ENG|0817 | 17|R | example : SEPARATOR ' | '
- ENG|0818 | 1| |
- ENG|0818 | 3| | G R O U P statement :
- ENG|0818 | 5| | Grouping rows of the result table.
- ENG|0818 | 7| | SYNTAX : GROUP [ REPEAT ] <column>... [ LEVEL <n> ]
- ENG|0818 | 8| | GROUP [<column>...] OFF
- ENG|0818 | 10| | GROUP can be used for grouping the result table according
- ENG|0818 | 11| | to any columns. This is only useful if the table has been
- ENG|0818 | 12| | sorted according to these columns.
- ENG|0818 | 14| | A change in the value of one of the columns always creates
- ENG|0818 | 15| | a new group. Upon changing groups, a blank row will always
- ENG|0818 | 16|SI| be inserted, if nothing else was determined by ##0840LFEEDS.
- ENG|0818 | 19| | If LEVEL numbers are assigned, columns will be grouped
- ENG|0818 | 20| | hierarchically. LEVEL 1 is the highest level; a column of
- ENG|0818 | 21| | LEVEL 2 will therefore only be grouped within a group of
- ENG|0818 | 22| | LEVEL 1.
- ENG|0818 | 24| | OFF cancels the grouping either of the specified column or
- ENG|0818 | 25|R | of all columns.
- ENG|0819 | 1| |
- ENG|0819 | 3| | T O T A L command :
- ENG|0819 | 5| | Enables cross-column calculations.
- ENG|0819 | 7| | SYNTAX : TOTAL [<function>] [<comment>] <column>...
- ENG|0819 | 8| | TOTAL [<column>] OFF
- ENG|0819 | 10| | Possible functions:
- ENG|0819 | 11| | SUM : sum of all column values (default)
- ENG|0819 | 12| | MIN : smallest column value
- ENG|0819 | 13| | MAX : largest column value
- ENG|0819 | 14| | AVG : average value
- ENG|0819 | 15| | COUNT : number of result rows
- ENG|0819 | 16| | VAL1 ( <column> ) to VAL4 ( <column> )
- ENG|0819 | 17|S | : storage spaces for own calculations
- ENG|0819 | 19| | The functions are performed for each of the specified
- ENG|0819 | 20| | columns and the result is displayed at the end of the
- ENG|0819 | 21| | result table in the order of the commands.
- ENG|0819 | 23| | The result values can be provided with a comment. The
- ENG|0819 | 24| | character string must be enclosed in single quotes. &COUNT
- ENG|0819 | 25| | in the character string is replaced by the number of result
- ENG|0819 | 26| | rows. &COLi is replaced by the last value of the i-th
- ENG|0819 | 27| | column.
- ENG|0819 | 29| | OFF disables all the functions either for the specified
- ENG|0819 | 30| | column or for all columns.
- ENG|0819 | 32| | examples:
- ENG|0819 | 33| E|
- ENG|0819 | 34| E| TOTAL amount turnover
- ENG|0819 | 35|SE| TOTAL MIN 'smallest of &COUNT values' amount
- ENG|0819 | 37| E| TOTAL turnover OFF
- ENG|0819 | 38| E| TOTAL VAL1(5) 'VAT sum' 14 * SUM (6) / 100
- ENG|0819 | 39| E| TOTAL VAL1(4) 'total units' COUNT (6)
- ENG|0819 | 40| E| TOTAL VAL1(6) 'VAT/unit' VAL1(5) / VAL1 (4)
- ENG|0819 | 41| E|
- ENG|0819 | 43| | The variables designated as VAL1 to VAL4 form a kind of
- ENG|0819 | 44| | spreadsheet having as many columns as are included in the
- ENG|0819 | 45| | result table. VAL2(7), e.g., addresses the value stored in
- ENG|0819 | 46| | row two, column seven. Values can be assigned to each of
- ENG|0819 | 47| | these variables by means of calculation formula. These
- ENG|0819 | 48| | formula can continue computing with constants, the
- ENG|0819 | 49| | functions SUM, MIN, MAX etc. as well as with values which
- ENG|0819 | 50| | are already available in other variables of the same
- ENG|0819 | 51|R | spreadsheet.
- ENG|0820 | 1| |
- ENG|0820 | 3| | S U B T O T A L command :
- ENG|0820 | 5| | Enables calculations across grouped columns.
- ENG|0820 | 7| | SYNTAX : SUBTOTAL <function> [<comment>] <column> [LEVEL <n>]
- ENG|0820 | 8| | SUBTOTAL <column> OFF
- ENG|0820 | 10| | Possible functions:
- ENG|0820 | 11| | SUM : sum of all column group values (default)
- ENG|0820 | 12| | MIN : smallest column group value
- ENG|0820 | 13| | MAX : largest column group value
- ENG|0820 | 14| | AVG : average group value
- ENG|0820 | 15| | COUNT : number of group result rows
- ENG|0820 | 16| | VAL1 ( <column> ) to VAL4 ( <column> )
- ENG|0820 | 17|S | : storage spaces for own calculations
- ENG|0820 | 19| | @<function>
- ENG|0820 | 20| | : cumulating the values accumulated
- ENG|0820 | 21| | in previous groups
- ENG|0820 | 23| I| The results are only displayed if the ##0818GROUP command is in
- ENG|0820 | 24| | effect.
- ENG|0820 | 26| | The functions are performed for each of the specified
- ENG|0820 | 27| | columns and the result is displayed at the end of the
- ENG|0820 | 28| | result table in the order of the commands.
- ENG|0820 | 30| | Specifying a LEVEL number enables the calculation of
- ENG|0820 | 31| | subtotals even for the grouping of another column.
- ENG|0820 | 33| | The result values can be provided with a comment. The
- ENG|0820 | 34| | character string must be enclosed in single quotes. &COUNT
- ENG|0820 | 35|S | in the character string is replaced by the number of result
- ENG|0820 | 37| | rows. &COLi is replaced by the last value of the i-th
- ENG|0820 | 38| | column.
- ENG|0820 | 40| | OFF disables all the functions either for the specified
- ENG|0820 | 41| | column or for all columns.
- ENG|0820 | 43| | examples:
- ENG|0820 | 44| E|
- ENG|0820 | 45| E| GROUP department
- ENG|0820 | 46| E| SUBTOTAL amount turnover
- ENG|0820 | 47| E| SUBTOTAL MIN 'smallest of &COUNT values' amount
- ENG|0820 | 48| E| SUBTOTAL turnover OFF
- ENG|0820 | 49| E| SUBTOTAL VAL1(6) 'unit' COUNT
- ENG|0820 | 50| E| SUBTOTAL VAL2(6) 'VAT' 14 * SUM / 100
- ENG|0820 | 51| E| SUBTOTAL VAL1 (DEBIT) @SUM (DEBIT)
- ENG|0820 | 52|SE|
- ENG|0820 | 55| | The variables designated as VAL1 to VAL4 form a kind of
- ENG|0820 | 56| | spreadsheet having as many columns as are included in the
- ENG|0820 | 57| | result table. VAL2(7), e.g., addresses the value stored in
- ENG|0820 | 58| | row two, column seven. Values can be assigned to each of
- ENG|0820 | 59| | these variables by means of calculation formula. These
- ENG|0820 | 60| | formula can continue computing with constants, the
- ENG|0820 | 61| | functions SUM, MIN, MAX etc. as well as with values which
- ENG|0820 | 62| | are already available in other variables of the same
- ENG|0820 | 63| | spreadsheet. Functions without column specifications
- ENG|0820 | 64|R | implicitly refer to the spreadsheet columns.
- ENG|0821 | 1| |
- ENG|0821 | 3| | P S U B T O T A L command :
- ENG|0821 | 5| | Enables subtotals computed for long groups to be output at
- ENG|0821 | 6| | the end of each page.
- ENG|0821 | 8| | SYNTAX : PSUBTOTAL <column> ...
- ENG|0821 | 9| | PSUBTOTAL [<column>] OFF
- ENG|0821 | 11| | At the end of each page, the current subtotals are output
- ENG|0821 | 12|R | for grouped columns which are set to SUBTOTAL.
- ENG|0822 | 1| |
- ENG|0822 | 3| | S E T command :
- ENG|0822 | 5| | Displaying the control parameters.
- ENG|0822 | 7| | SYNTAX : SET
- ENG|0822 | 9| | The SET command enables the individual setting of control
- ENG|0822 | 10| | parameters. The control parameters determine, among other
- ENG|0822 | 11| | things, the default format for the REPORT display of
- ENG|0822 | 12| | tables. These parameters may be changed by overwriting.
- ENG|0822 | 14| | Input is checked and may be rejected if, e.g., a number has
- ENG|0822 | 15| | been entered instead of letters. The altered values remain
- ENG|0822 | 16|S | valid beyond the session's end.
- ENG|0822 | 19| | The SET parameters can temporarily be overridden for the
- ENG|0822 | 20| | current result table by means of the REPORT commands
- ENG|0822 | 21| I| ##0824DECIMAL, ##0817SEPARATOR, ##0823NULL, and ##0831PRINT.
- ENG|0822 | 23| | The meanings of the individual SET parameters are described
- ENG|0822 | 24|R | in detail in the QUERY manual.
- ENG|0823 | 1| |
- ENG|0823 | 3| | N U L L command :
- ENG|0823 | 5| | Representation of NULL values.
- ENG|0823 | 7| | SYNTAX : NULL <character string>
- ENG|0823 | 8| | or NULL <column> <position>
- ENG|0823 | 9| | position ::= LEFT | RIGHT
- ENG|0823 | 11| | The character string must be enclosed in single quotes if
- ENG|0823 | 12| | it contains blanks or lower case characters.
- ENG|0823 | 14| | The character string specified via the NULL command only
- ENG|0823 | 15| | affects the current result table and does not alter the SET
- ENG|0823 | 16|S | parameter. The number of characters must be <= 20.
- ENG|0823 | 19| | example : NULL ' ? '
- ENG|0823 | 21| | It may be specified for every single column, whether the
- ENG|0823 | 22| | NULL value is to be displayed left-justified or right-
- ENG|0823 | 23| | justified. Default representation is right-justification
- ENG|0823 | 24| | for FIXED and FLOAT columns, otherwise left-justification.
- ENG|0823 | 26|R | example : NULL column_3 LEFT
- ENG|0824 | 1| |
- ENG|0824 | 3| | D E C I M A L command :
- ENG|0824 | 5| | Defining the representation of numbers.
- ENG|0824 | 7| | SYNTAX : DECIMAL <column> <n>
- ENG|0824 | 8| | DECIMAL <column> <n> [<t>/<d>]
- ENG|0824 | 10| | n is the number of fractional digits. t defines the
- ENG|0824 | 11| | thousands punctuation. d defines the decimal punctuation.
- ENG|0824 | 13| | The values specified via the DECIMAL command only affect
- ENG|0824 | 14| | the current result table and do not alter the SET
- ENG|0824 | 15| | parameter.
- ENG|0824 | 17|S | examples:
- ENG|0824 | 19| E|
- ENG|0824 | 20| E| DECIMAL amount 3 / /,/ 1 234,567
- ENG|0824 | 21| E| DECIMAL amount 2 /./,/ 1.234,56
- ENG|0824 | 22| E| DECIMAL amount 1 1.234,5
- ENG|0824 | 23| E| DECIMAL amount 1 /,/./ 1,234.5
- ENG|0824 | 24| E| DECIMAL amount 2 //,/ 1234,56
- ENG|0824 | 25|RE|
- ENG|0825 | 1| |
- ENG|0825 | 3| | P R O T E C T command :
- ENG|0825 | 5| | Treatment of leading zeros.
- ENG|0825 | 7| | SYNTAX : PROTECT <column> [<character>]
- ENG|0825 | 8| | PROTECT [<column>] OFF
- ENG|0825 | 10| | PROTECT serves to protect decimal fields. The column is
- ENG|0825 | 11| | defined by means of its name or number. The number fields
- ENG|0825 | 12| | are padded with the specified character from the left.
- ENG|0825 | 13| | Default is blank.
- ENG|0825 | 15|R | OFF disables the PROTECT command for the specified column.
- ENG|0826 | 1| |
- ENG|0826 | 3| | L E A D command :
- ENG|0826 | 5| | Leading characters for numeric values.
- ENG|0826 | 7| | SYNTAX : LEAD <column> <character string> [IMMEDIATE]
- ENG|0826 | 8| | LEAD [<column>] OFF
- ENG|0826 | 10| | Characters may be set in front of numeric values by means
- ENG|0826 | 11| | of LEAD. This function serves especially to provide numbers
- ENG|0826 | 12| | with currency symbols (e.g. $ ). If IMMEDIATE is specified,
- ENG|0826 | 13| | the characters are placed directly before the numbers;
- ENG|0826 | 14|R | otherwise they will be left-justified.
- ENG|0827 | 1| |
- ENG|0827 | 3| | T R A I L command :
- ENG|0827 | 5| | Trailing characters for numeric values.
- ENG|0827 | 7| | SYNTAX : TRAIL <column> <character string>
- ENG|0827 | 8| | TRAIL [<column>] OFF
- ENG|0827 | 10| | Characters may be set after numeric values by means of
- ENG|0827 | 11| | TRAIL. This function serves especially to provide numbers
- ENG|0827 | 12|R | with currency symbols or dimensions (e.g. DM or km).
- ENG|0828 | 1| |
- ENG|0828 | 3| | R T I T L E command :
- ENG|0828 | 5| | Heading for output.
- ENG|0828 | 7| | SYNTAX : RTITLE [<n>] <heading> [LEFT | RIGHT | CENTER]
- ENG|0828 | 8| | RTITLE [<n>] OFF
- ENG|0828 | 10| | The entered title (consisting of up to three lines) appears
- ENG|0828 | 11| | at the beginning of the report. It may contain formal
- ENG|0828 | 12| | parameters which will be replaced by current values when
- ENG|0828 | 13| | the heading is output.
- ENG|0828 | 15| | The parameter &COLn (1 <= n <= 254) is replaced by the
- ENG|0828 | 16| | column value of the n-th output table column in the first
- ENG|0828 | 17|S | result row.
- ENG|0828 | 19| | &USER and &GROUP are replaced by the name of the current
- ENG|0828 | 20| | user or usergroup.
- ENG|0828 | 22| | &DATE is replaced by the current date. The date is output
- ENG|0828 | 23| | according to the current SET definition.
- ENG|0828 | 25| | The title can be written left-justified or right-justified,
- ENG|0828 | 26|R | or centered. Default is CENTER.
- ENG|0829 | 1| |
- ENG|0829 | 3| | T T I T L E command :
- ENG|0829 | 5| | Enables one heading per output page.
- ENG|0829 | 7| | SYNTAX : TTITLE [<n>] <heading> [LEFT | RIGHT | CENTER]
- ENG|0829 | 8| | TTITLE [<n>] OFF
- ENG|0829 | 10| | The entered heading appears on every output page.
- ENG|0829 | 12| | On output &COUNT is replaced by the number of the first row
- ENG|0829 | 13| | of the page, and &COLi is replaced by the value of the i-th
- ENG|0829 | 14| | column.
- ENG|0829 | 16|S | &PAGE is replaced by the current page number.
- ENG|0829 | 19| | &USER and &GROUP are replaced by the name of the current
- ENG|0829 | 20| | user or usergroup.
- ENG|0829 | 22| | &DATE is replaced by the current date. The date is output
- ENG|0829 | 23| | according to the current SET definition.
- ENG|0829 | 25| | Allowed are up to n = 3 top titles. They may be left-
- ENG|0829 | 26| | justified, right-justified, or centered on output. Default
- ENG|0829 | 27|R | is CENTER.
- ENG|0830 | 1| |
- ENG|0830 | 3| | B T I T L E command :
- ENG|0830 | 5| | Enables a footing for each output page.
- ENG|0830 | 7| | SYNTAX : BTITLE [<n>] <footing> [LEFT | RIGHT | CENTER]
- ENG|0830 | 8| | BTITLE [<n>] OFF
- ENG|0830 | 10| | The specified footing appears at the end of each page.
- ENG|0830 | 12| | For print output &COUNT is replaced by the number of the
- ENG|0830 | 13| | last result row of the page and &COLi is replaced by the
- ENG|0830 | 14| | value of the i-th column of this row.
- ENG|0830 | 16| | &PAGE, &DATE, &USER, and &GROUP are replaced in the same
- ENG|0830 | 17|S | way as in other TITLE commands.
- ENG|0830 | 19| | Allowed are up to n = 3 footings. They may be left-
- ENG|0830 | 20|R | justified, right-justified, or centered on output.
- ENG|0831 | 1| |
- ENG|0831 | 3| | P R I N T command :
- ENG|0831 | 5| | Prints the current result table.
- ENG|0831 | 7| | SYNTAX : PRINT [<n>] [<printer>] [ONLY]
- ENG|0831 | 9| | PRINT writes the entire formatted result table into the
- ENG|0831 | 10| | spool area.
- ENG|0831 | 12| | <n> defines the number of copies to be printed. The
- ENG|0831 | 13| | identifier <printer> can be enclosed in single quotes if
- ENG|0831 | 14| | the operating system is case sensitive. If these parameters
- ENG|0831 | 15| | are not specified, the SET regulation will be valid.
- ENG|0831 | 17|S | The option ONLY has the effect that the result table is
- ENG|0831 | 19|R | only printed and not displayed on the screen.
- ENG|0832 | 1| |
- ENG|0832 | 3| | C L O S E command :
- ENG|0832 | 5| | Prints the contents of the spool area.
- ENG|0832 | 7| | SYNTAX : CLOSE [ PRINTER ]
- ENG|0832 | 9| | Everything that has been written to the spool area since
- ENG|0832 | 10| | the last CLOSE is output via the printer. An implicit CLOSE
- ENG|0832 | 11|R | is performed at the end of each QUERY/REPORT session.
- ENG|0833 | 1| |
- ENG|0833 | 3| | P U T command :
- ENG|0833 | 5| | Writes the current result table into a file.
- ENG|0833 | 7| | SYNTAX : PUT '<filename>' [APPEND] [ONLY]
- ENG|0833 | 9| | PUT writes the entire formatted result table into the file
- ENG|0833 | 10| | defined by <filename>. The option APPEND has the effect
- ENG|0833 | 11| | that an existing file will not be overwritten, but the
- ENG|0833 | 12| | result is added to it.
- ENG|0833 | 14| | The option ONLY is only enabled if it is specified in a
- ENG|0833 | 15| | stored command. It has the effect that the result table is
- ENG|0833 | 16|R | only output to the file and not displayed on the screen.
- ENG|0834 | 1| |
- ENG|0834 | 3| | A S C I I command :
- ENG|0834 | 5| | Converts representable ascii characters stored in CHAR BYTE
- ENG|0834 | 6| | columns into plaintext.
- ENG|0834 | 8| | SYNTAX : ASCII <column>
- ENG|0834 | 10| | The default hexadecimal representation for CHAR BYTE
- ENG|0834 | 11| | columns will be replaced by a plaintext representation.
- ENG|0834 | 12| | Non-representable characters will be output as '?'.
- ENG|0834 | 14| | This command only makes sense, when the column contains a
- ENG|0834 | 15|R | great amount of ascii-coded plaintext.
- ENG|0835 | 1| |
- ENG|0835 | 3| | E B C D I C command :
- ENG|0835 | 5| | Converts representable ebcdic characters stored in CHAR
- ENG|0835 | 6| | BYTE columns into plaintext.
- ENG|0835 | 8| | SYNTAX : EBCDIC <column>
- ENG|0835 | 10| | The default hexadecimal representation for CHAR BYTE
- ENG|0835 | 11| | columns will be replaced by a plaintext representation.
- ENG|0835 | 12| | Non-representable characters will be output as '?'.
- ENG|0835 | 14| | The command only makes sense, when the column contains a
- ENG|0835 | 15|R | great amount of ebcdic-coded plaintext.
- ENG|0836 | 1| |
- ENG|0836 | 3| | H E X A D E C command :
- ENG|0836 | 5| | Default representation of CHAR BYTE columns.
- ENG|0836 | 7| | SYNTAX : HEXADEC <column>
- ENG|0836 | 9| I| If CHAR BYTE columns were processed with an ##0834ASCII or ##0835EBCDIC
- ENG|0836 | 10| | command for output, the original hexadecimal representation
- ENG|0836 | 11|R | may be restored.
- ENG|0837 | 1| |
- ENG|0837 | 3| | F I X command :
- ENG|0837 | 5| | Serves to fix any column on the screen.
- ENG|0837 | 7| | SYNTAX : FIX <column> [<column>] ...
- ENG|0837 | 8| | FIX OFF
- ENG|0837 | 10| | The corresponding columns are permanently displayed at the
- ENG|0837 | 11| | left margin of the screen, even if scrolling to the left or
- ENG|0837 | 12| | to the right.
- ENG|0837 | 14|R | FIX OFF cancels the fixing of these columns.
- ENG|0838 | 1| |
- ENG|0838 | 3| | W I N D O W command :
- ENG|0838 | 5| | REPORT screen output in form of a window.
- ENG|0838 | 7| | SYNTAX : WINDOW <position> [<size>] [NOFRAME]
- ENG|0838 | 8| | position ::= POS <row> <column>
- ENG|0838 | 9| | size ::= SIZE <rows> <columns>
- ENG|0838 | 10| | The window is closed by means of
- ENG|0838 | 11| | WINDOW OFF
- ENG|0838 | 13| | The WINDOW command can be used for representing the REPORT
- ENG|0838 | 14| | screen output in form of a window. This can be useful, e.g.
- ENG|0838 | 15| | from an SQL-PL application, if REPORT is not to occupy the
- ENG|0838 | 16|S | whole screen.
- ENG|0838 | 19| | POS defines the upper left-hand corner of the window, SIZE
- ENG|0838 | 20| | defines the size of the window specifying the number of
- ENG|0838 | 21| | rows and columns. The SIZE specification can be omitted;
- ENG|0838 | 22| | the window will then be displayed in its maximum size.
- ENG|0838 | 24| | In case of a NOFRAME specification a window is generated
- ENG|0838 | 25|R | without a frame.
- ENG|0839 | 1| |
- ENG|0839 | 3| | P A G E statement :
- ENG|0839 | 5| | Controllable form feed at the end of group.
- ENG|0839 | 7| | SYNTAX : PAGE [<number of lines>] [<level>]
- ENG|0839 | 9| | Resetting with
- ENG|0839 | 10| | PAGE OFF [<level>]
- ENG|0839 | 11| | <level> ::= LEVEL <n>
- ENG|0839 | 13| | The PAGE command can be used for performing a conditional
- ENG|0839 | 14| | or unconditional form feed at the end of a group.
- ENG|0839 | 16| | If no number of lines is specified, an unconditional form
- ENG|0839 | 17|S | feed is performed at the end of a group. Specifying a
- ENG|0839 | 19| | number of lines n means: if there are less than n lines
- ENG|0839 | 20| | free on the current page, then a form feed will be
- ENG|0839 | 21| | performed.
- ENG|0839 | 23| | The LEVEL option reduces the form feed to the ends of
- ENG|0839 | 24|R | groups of the specified level.
- ENG|0840 | 1| |
- ENG|0840 | 3| | L F E E D S command :
- ENG|0840 | 5| | Controllable line feed at the end of group.
- ENG|0840 | 7| | SYNTAX : LFEEDS <number of lines> [LEVEL <n>]
- ENG|0840 | 9| | The LFEEDS command can be used for controlling a line feed
- ENG|0840 | 10| | at the end of group. Default setting is one blank line for
- ENG|0840 | 11| | each end of group.
- ENG|0840 | 13| | The LEVEL option can be used for defining an individual
- ENG|0840 | 14|R | number of blank lines for each group level.
- ENG|0841 | 1| |
- ENG|0841 | 3| | F O R M A T command :
- ENG|0841 | 5| | Formatted number output.
- ENG|0841 | 7| | SYNTAX : FORMAT <column> <pattern>
- ENG|0841 | 8| | or FORMAT [<column>] OFF
- ENG|0841 | 10| | The FORMAT command enables flexible editing of numeric
- ENG|0841 | 11| I| values in accordance with a given pattern. Previous ##0826LEAD,
- ENG|0841 | 12| I| ##0827TRAIL, and ##0825PROTECT commands are disabled by the FORMAT
- ENG|0841 | 13| | command.
- ENG|0841 | 15| | Examples of possible patterns:
- ENG|0841 | 16| E|
- ENG|0841 | 17|SE| FORMAT column '9 999' : 1234 --> '1 234'
- ENG|0841 | 19| E| FORMAT column '9,999.99 Kg' : 1234 --> '1,234.00 Kg'
- ENG|0841 | 20| E| FORMAT column 'DM 999,99' : 12.3 --> 'DM 12,30'
- ENG|0841 | 21| E| FORMAT column '9 Kg 555 g' : 1.234 --> '1 Kg 234 g'
- ENG|0841 | 22| E| FORMAT column '.9999e-99' : 12.34 --> '.1234e+02'
- ENG|0841 | 23| E|
- ENG|0841 | 25| | Every '9' in the mask designates a digit position. The
- ENG|0841 | 26| | first point or comma (from left to right) will be
- ENG|0841 | 27| | interpreted as position and representation of the decimal
- ENG|0841 | 28| | sign; if it is not to be represented by a point or comma,
- ENG|0841 | 29| | the fractional positions must be designated by a '5'.
- ENG|0841 | 31| | If the mask does not contain any signs, only floating
- ENG|0841 | 32| | negative signs precede the first digit. Otherwise a '-'
- ENG|0841 | 33| | (only negative signs) or a '+' (all signs) determines the
- ENG|0841 | 34| | sign position in the mask:
- ENG|0841 | 35|S | FORMAT column '99 999' : -123 --> ' -123'
- ENG|0841 | 37| | FORMAT column '-9 999' : 123 --> ' 123'
- ENG|0841 | 38| | FORMAT column '+9 999' : 123 --> '+ 123'
- ENG|0841 | 39| | FORMAT column '99 999-' : -1234 --> ' 1 234-'
- ENG|0841 | 41| | The leading digit can also be designated by 0, *, or >
- ENG|0841 | 42| | instead of 9. For 0 leading zeros will be displayed, for *
- ENG|0841 | 43| | not required positions in front of the number are padded
- ENG|0841 | 44| | with * (cheque protection). For > floating text will be
- ENG|0841 | 45| | placed before the first digit.
- ENG|0841 | 46| | FORMAT column '099 999' : 123 --> '000 123'
- ENG|0841 | 47| | FORMAT column '*99 999' : 123 --> '****123'
- ENG|0841 | 48|R | FORMAT column '$>99 999' : 123 --> ' $123'
- ENG|0842 | 1| |
- ENG|0842 | 3| | C R D B command:
- ENG|0842 | 5| | Sign representation in an account representation.
- ENG|0842 | 7| | SYNTAX : CRDB <column>
- ENG|0842 | 8| | CRDB [<column>] OFF
- ENG|0842 | 10| | CRDB can only be applied to numerical columns. The values
- ENG|0842 | 11| | of the specified column will not be output with a plus or
- ENG|0842 | 12| | minus sign. It will, however, be followed by CR(edit) in
- ENG|0842 | 13| | case of positive values and by D(e)B(it) in case of
- ENG|0842 | 14|R | negative values.
- ENG|0843 | 1| |
- ENG|0843 | 3| | L I N E N O command :
- ENG|0843 | 5| | Displaying the row numbers.
- ENG|0843 | 7| | SYNTAX : LINENO [<column header>]
- ENG|0843 | 8| | LINENO OFF
- ENG|0843 | 10| | LINENO displays a column with row numbers on the left side
- ENG|0843 | 11| | of the result table. A column header is optional.
- ENG|0843 | 13|R | LINENO OFF excludes the column from the display.
- ENG|0844 | 1| |
- ENG|0844 | 3| | DETAIL command :
- ENG|0844 | 6| | Displaying a Master-Detail REPORT.
- ENG|0844 | 8| | SYNTAX : DETAIL [OFF]
- ENG|0844 | 10| | The master detail functionality enables the user to
- ENG|0844 | 11| | simultaneously represent and evaluate two tables which are
- ENG|0844 | 12| | related to each other.
- ENG|0844 | 14| | The relation between two tables is thereby described either
- ENG|0844 | 15| | explicitly by join conditions or implicitly by FOREIGN
- ENG|0844 | 16|S | KEYs.
- ENG|0844 | 19| | The select statement for the DETAIL command is requested in
- ENG|0844 | 20| | an additional input window.
- ENG|0844 | 22| | Example of a DETAIL select:
- ENG|0844 | 24| | <select statement>
- ENG|0844 | 25| | [WHERE ... AND|OR <detail column> = :<master column> ... ]
- ENG|0844 | 26| | [FOREIGN KEY <name> REFERENCED BY <table> ]
- ENG|0844 | 28| | Example of a FOREIGN KEY condition:
- ENG|0844 | 30| | DETAIL
- ENG|0844 | 31| | SELECT "detail table"
- ENG|0844 | 32| | ( rno, cno, hno, num_pers, price )
- ENG|0844 | 33| | FROM reservation
- ENG|0844 | 34| | FOREIGN KEY customer_reservation REFERENCED BY reservation
- ENG|0844 | 35|S | ORDER BY hno
- ENG|0844 | 37| | REPORT
- ENG|0844 | 38| | WIDTH *
- ENG|0844 | 39| | NUMBER on
- ENG|0844 | 40| | ENDDETAIL
- ENG|0844 | 41| | WIDTH *
- ENG|0844 | 43| | and with JOIN conditions
- ENG|0844 | 45| | DETAIL
- ENG|0844 | 46| | SELECT "detail table"
- ENG|0844 | 47| | ( rno, cno, hno, num_pers, price )
- ENG|0844 | 48| | FROM reservation
- ENG|0844 | 49| | WHERE cno = :cno
- ENG|0844 | 50| | ORDER BY hno
- ENG|0844 | 51| | REPORT
- ENG|0844 | 52| | WIDTH *
- ENG|0844 | 53|S | NUMBER on ENDDETAIL WIDTH *
- ENG|0844 | 55|R | DETAIL OFF returns to the normal report representation.
- ENG|0845 | 1| |
- ENG|0845 | 3| | L O N G command :
- ENG|0845 | 5| | Displaying LONG CHAR columns.
- ENG|0845 | 7| | SYNTAX : LONG ALL | <column> ON
- ENG|0845 | 8| | LONG ALL | <column> OFF
- ENG|0845 | 10| | The command LONG displays the beginnings of the specified
- ENG|0845 | 11| | LONG column in the report. This command only works on CHAR-
- ENG|0845 | 12| | type LONG columns.
- ENG|0845 | 14| | With a keyword ALL specification the command is valid for
- ENG|0845 | 15| | all LONG CHAR columns.
- ENG|0845 | 17|R | LONG OFF redisplays the columns in normal way.
- ENG|0846 | 1| |
- ENG|0846 | 3| | Z O O M command :
- ENG|0846 | 5| | Displaying LONG columns.
- ENG|0846 | 7| | SYNTAX : ZOOM <column> [<row number>]
- ENG|0846 | 8| | ZOOM <column> [<row number>] PUT <filename>
- ENG|0846 | 10| | The ZOOM command allows contents of LONG columns to be
- ENG|0846 | 11| | represented in a special window (viewer).
- ENG|0846 | 13| | The LONG content is specified by the column and optionally
- ENG|0846 | 14| | by the row number. If no row number is specified, the first
- ENG|0846 | 15| | row displayed in the report will be used.
- ENG|0846 | 17|S | It is also possible to position the cursor to the desired
- ENG|0846 | 19| | LONG column and row and to get to the display window by
- ENG|0846 | 20| | means of the ZOOM function key.
- ENG|0846 | 22| | In the viewer it is possible to scroll through the LONG
- ENG|0846 | 23| | column, to choose between hexadecimal and ASCII
- ENG|0846 | 24| | representation, and to write the content to a file.
- ENG|0846 | 26| | Writing to a file can also be enabled from the report. For
- ENG|0846 | 27| | this purpose enter, after the ZOOM command, the keyword PUT
- ENG|0846 | 28|R | and the filename.
- ENG|0847 | 1| |
- ENG|0847 | 3| | D A T E command :
- ENG|0847 | 5| | Displaying date and time.
- ENG|0847 | 7| | SYNTAX : DATE
- ENG|0847 | 9| | The DATE command displays the current date and the current
- ENG|0847 | 10|R | time.
- ENG|0850 | 1| |
- ENG|0850 | 3| | R E P O R T F U N C T I O N S :
- ENG|0850 | 5| | Positioning in the result table
- ENG|0850 | 7| I| ##0807 BOTTOM branching to the end of the result table
- ENG|0850 | 8| I| ##0806 TOP branching to the beginning of the result table
- ENG|0850 | 9| I| ##0805 DOWN scrolling forward in the result table
- ENG|0850 | 10| I| ##0804 UP scrolling backward in the result table
- ENG|0850 | 11| I| ##0808 LEFT moving the displayed section to the left
- ENG|0850 | 12| I| ##0809 RIGHT moving the displayed section to the right
- ENG|0850 | 13| I| ##0810 POS positioning to any table column
- ENG|0850 | 14|SI| ##0811 TAB tabulator in a wide column
- ENG|0850 | 19| | Writing the result table to paper or disk
- ENG|0850 | 21| I| ##0831 PRINT prints the current result table
- ENG|0850 | 22| I| ##0832 CLOSE prints the contents of the spool area
- ENG|0850 | 23| I| ##0833 PUT writes the current result table into a file
- ENG|0850 | 25| | General commands
- ENG|0850 | 27| I| ##0801 HELP displays explanations on the screen
- ENG|0850 | 28|RI| ##0803 END leaves the REPORT mode
-
