ESBOZO DE LA EVOLUCIÓN DE LA COMUNICACIÓN POLÍTICA MODERNA
2.3.2. Estructura de la comunicación política institucional
A file referenced in a USE statement can itself contain other USE statements. USE files can be nested to a maximum of 20 levels. Permanent files containing valid source code can be included at any time providing they are consistent with QUIZ syntax and structure.
Example
The source statements in this example are stored in a file called PRICELST. To print the report, the user enters
> USE PRICELST
A second USE statement, nested within the first, reads the file, STDREP, that contains a standard report format. STDREP can be used by many reports:
> ACCESS PARTS
>
> USE STDREP
QUIZ reads the statements from the file STDREP into the current report:
> SET NOBLANKS
> SET NOHEAD
> SET REPORT DEVICE PRINTER &
> LIMIT 3000 &
> COPIES 2
Chapter 3: QUIZ Statements USE
As each statement is read, it’s interpreted as if it were entered from the keyboard. (If the NOLIST option had been included, the contents of STDREP would not have been displayed.) When all the statements from the USE file have been processed, QUIZ continues to process the PRICELST file:
> DEFINE RETAILPRICE &
> NUMERIC * 9 &
> PICTURE "$^^^,^^^.^^" &
> = (UNITCOST * UNITMARKUP)
> REPORT &
> PARTNUMBER &
> PARTVARIANT &
> PARTNAME &
> RETAILPRICE
> GO
A
SET JOB statement,129 SET REPORT statement,145 ALIAS option
ACCESS statement,18 ALIGN option
FINAL FOOTING statement,74 FOOTING AT statement,78 HEADING AT statement,83 INITIAL HEADING statement,87 PAGE FOOTING statement,95 PAGE HEADING statement,98 SET REPORT statement,142 ALL option
BUILD statement,33 CHOOSE statement,40
query-specification (SELECT) statement,103 REPORT statement,107
ALTERNATE option
SET SUBFILE statement,154 AND option
ACCESS statement,19 AND SELECT option
SELECT statement,122 APPEND option
SET SUBFILE statement,155 appending data records,155 ascending
indexes,45
sort order,167,169 ASCENDING option
SEGMENT option, SET SUBFILE statement,155 SET SUBFILE statement,154
asterisk (*)
SET SUBFILE statement,155 summary operations,110 at-sign (@)
generic retrieval character,40 AVERAGE summary operation
FOOTING AT statement,78 HEADING AT statement,83
B
batch jobs executing,134 generating,135
submitting as text files,136 batch session defaults
tables,126 blank spaces
setting between report-items,145 blanks
transactions, selection conditions,122 BURST option
SET REPORT statement,146 BWZ option
titles of reports,140 CENTURY EXCLUDED option
DEFINE statement,56 CENTURY INCLUDED option
DEFINE statement,56 CHARACTERISTICS option
SET JOB statement,129 SET REPORT statement,146 characters
nonsubstitution, displaying,65 shifting case,58,69
CHOOSE statement,38-49 EDIT statement,45 SELECT statement,123 validating response values,69 with expressions,46
class
general term, BUILD statement,33 CLEAR option
CANCEL statement,36 SAVE statement,120
Index
Index
CLOSE option SET statement,127 collating sequence
effect on conditional selection,123 colon
substituting for THEN,58 column
headings in QUIZ reports,62 column-name general term
query-specification (SELECT) statement,104 combining statements
saving SET statement options,134 compiling
associated with footings,78 defining,167,169
COPIES option
SET REPORT statement,142,146 copyright,ii
COUNT summary operation FOOTING AT statement,78 HEADING AT statement,83 report-item statement,110 CPUTIME option
SET JOB statement,129 cursor
general term, ACCESS statement,17 cursor-name general term
SQL DECLARE CURSOR (stored procedure) statement, 52
SET SUBFILE statement,157 dates
optional separator characters,42,60,65,116 specifying formats,41,59,61,112
DBMODE option validating response values,69
defined items
CHOOSE statement,39 subfiles,164
derived tables
query-specification (SELECT) statement,103 descending
indexes,45 order, sorting,169 sort order,167 DESCENDING option
SEGMENT option, SET SUBFILE statement,155 SET SUBFILE statement,154
DESTINATION option
SET REPORT statement,142 detail lines
setting content and format,107-108,109 DETAIL option
SET REPORT statement,142 DEVICE option
SET REPORT statement,142 dictionaries
changing for current session,128 editing specifications,69
dictionary PowerHouse,7 DICTIONARY option
SET statement,128
SET SUBFILE statement,155 direct-linkage general term
ACCESS statement,18 DISC option
SET REPORT statement,143 DISK option
SET REPORT statement,143 DISPLAY option
BUILD statement,33 DISPLAY statement,68 displaying
blanks and zeros,60
dates, item values,41,59,61,112 items, pictures,64
messages,68
nonsubstitution characters,65 DISTINCT option
query-specification (SELECT) statement,103 DOWNSHIFT option
DEFINE statement,58 EDIT statement,69 SET statement,128 dummy records
DUPLICATES option execution-time parameters values,45 specifications for data dictionary,69 EJECTPAGE option
SET REPORT statement,144 ellipsis (...)
picture overflow,166 errors
unresolved, number of reprompts,42,60 EXECUTE statement,71-72
increasing speed and efficiency,123 execution-time parameters
editing,66
editing, CHOOSE statement,45 validating,70
EXIT statement,73 exiting QUIZ,73,106 expression general term
ACCESS statement,19 expressions
case-value,58
CHOOSE statement,47
defined items, CHOOSE statement,39 naming,55-67 FINAL FOOTING statement,74-77 FLAG option
SET REPORT statement,146 FLOAT option
DEFINE statement,61 report-item statement,112 flowcharts
locating subfiles, parse-time,160 FOOTING AT statement,78-81 footings
control, printing,78 final,74
setting content and format,95-97,109 FORCE CENTURY option
FORCE CENTURY option(cont'd) DEFINE statement,58
FORMAT option
CHOOSE statement,41 DEFINE statement,59,61 report-item statement,112 SET SUBFILE statement,156 format-option
report-item statement,112 FORMFEED option
SET statement,128 FORMS option
SET REPORT statement,144,145 four-digit year
specifying,41,59,61,112 FROM option
query-specification (SELECT) statement,103
G
GENERIC option
CHOOSE statement,38 generic retrieval
at-sign (@) character,40 CHOOSE statement,43,44 choosing data records,40 preventing,44
query-specification (SELECT) statement,104 HEAD option
SET statement,128 HEADING AT statement,83-86 HEADING option
DEFINE statement,62 report-item statement,113 headings
default column,62
default page heading contents,98
setting content and format,83-86,87-90,98-101,109 hierarchical linkage,24
mixed with parallel linkage,28 HOLD option
SET JOB statement,130 SET REPORT statement,146 HPSLAVE,128
HPSLAVE output blocks,149
I
IDENTIFY
SET JOB statement,130 IDENTIFY option
SET REPORT statement,146 IMAGES option
SET PAGE statement,140 IN option
SQL DECLARE CURSOR (query-specification) statement,50
SQL DECLARE CURSOR (stored procedure) statement,
Index
INDEX option
SET SUBFILE statement,154 indexed subfiles,158
multiple segment, linkage,30 order, CHOOSE statement,45 single segment, linkage,30 indexname general term,19 INITIAL HEADING statement,87-90 initial subset
specifying linkage,31 INITIAL VALUE option
summary operations,110 INOUT option
SQL DECLARE CURSOR (stored procedure) statement, 53
interactive session defaults tables,126
interim subfiles,159,164 internal tables,11 interrupting prompting
CHOOSE statement,44 DEFINE statement,66 ITEM option
SQL DECLARE CURSOR (stored procedure) statement, 52
writing to subfiles,161 ITOP
PAGE HEADING statement,98 SET JOB statement,130 SET SUBFILE statement,156
L
SET PAGE statement,140 LIMIT option
SET REPORT statement,145 limitations
mixed hierarchical and parallel,28 multiple segment indexes,30 optional,29
options, ACCESS statement,21 parallel,26
record numbers,31
relationships, one-to-many,23-28 relationships, one-to-one,23 segments,31
single segment indexes,30 using names,31
SET JOB statement,130 LOGICAL option
CHOOSE statement,43 lowercase characters
shifting to uppercase,58,69 LOWERCASE option
SET REPORT statement,147
M
matching wildcards,43
MAXIMUM summary operation FOOTING AT statement,78 HEADING AT statement,83 report-item statement,110 messages
displaying,68
prompting at execution-time,42,60 MINIMUM summary operation
FOOTING AT statement,78 HEADING AT statement,83 report-item statement,110
mixing
hierarchical and parallel linkage,28 monitor
SET JOB statement,130 SET REPORT statement,145 SET SUBFILE statement,156,157 names
assigning to expressions or specific values,55 conflicts, permanent subfiles,159
conflicts, temporary subfiles,158 specifying linkage,31
displayed in parentheses,65,116 leading sign,63
trailing sign,65,116 nesting
USE statements,171 NOALIGN option
FINAL FOOTING statement,74 FOOTING AT statement,78 HEADING AT statement,83 INITIAL HEADING statement,87 PAGE FOOTING statement,95 PAGE HEADING statement,98 SET REPORT statement,142 NOAPPEND option
SET SUBFILE statement,155 NOBLANKS option
SET statement,127 NOBURST option
SET REPORT statement,146 NOBWZ option
DEFINE statement,60 report-item statement,112 NOCHARACTERISTICS option
SET JOB statement,129 SET REPORT statement,146 NOCLOSE option
SET SUBFILE statement,155 NODUPLICATES option
SET statement,128 NOEJECTPAGE option
SET REPORT statement,144 NOFLAG option
SET REPORT statement,146 NOFORCE CENTURY option
SET JOB statement,130 SET REPORT statement,146 NOIDENTIFY
SET JOB statement,130 NOIDENTIFY option
SET REPORT statement,146 NOJOB option
SET statement,129 NOKEEP option
SET JOB statement,130 NOLIMIT option
SET REPORT statement,145 NOLIST option
SET JOB statement,130 NOLOWERCASE option
SET REPORT statement,147 NONOTIFY option
SET JOB statement,130 SET REPORT statement,147 NONSPOOLED option
SET REPORT statement,143 nonspooled printer
SET REPORT statement,147 NOPRINT option
SET statement,132 NOPRINTER option
SET JOB statement,131 NORANGE option
CHOOSE statement,42,43 NOREPORT statement,91 NORESTART option
SET JOB statement,131 SET REPORT statement,147 NOSHIFT option
SET REPORT statement,145
Index
NOTIFY option(cont'd)
SET REPORT statement,147 NOTRAILER option
SET REPORT statement,147 NOTRANSACTION option
SQL DECLARE CURSOR (stored procedure) statement, 52
SET PAGE statement,140 NUMERIC option
DEFINE statement,56 numeric values
displaying nonsubstitution characters and leading zeros, 65,116
leading spaces, filling,60,112
negative, displayed in parentheses,65,116 negative, specifying leading sign,63 negative, specifying trailing sign,65,116 numeric-expression general term,18
O
OMNIDEX indexes,93 statement,93 OmniQuest
access to values,94 ON ERROR CONTINUE option
DEFINE statement,53
ON ERRORS REPROMPT option CHOOSE statement,42
SET REPORT statement,147 optional linkage,29
OPTIONAL option ACCESS statement,20 parallel linkage,29 ORACLE
calling a stored procedure or function,52 synonym, stored procedure names,52 synonyms, package names,52 synonyms, stored function names,52 order
sort options,169
ORDER BY option
SQL DECLARE CURSOR (query-specification) statement,50
ORDERED option
SET SUBFILE statement,154 OUT option
SQL DECLARE CURSOR (stored procedure) statement, 53
PAGE FOOTING statement,95-97 PAGE HEADING statement,98-101 page length, specifying,140 PAGE option
SET statement,132 page width, specifying,140 page-control settings
SET JOB statement,131 parameters, execution-time
editing,66 parentheses
indicating negative numbers,65 PARM option parser processing phase,11 parse-time
locating subfiles,160 partial values
choosing data records with,38 PATTERN option
EDIT statement,69 PDL,7
PDL compiler,7
PERCENT summary operation FOOTING AT statement,78 HEADING AT statement,83 report-item statement,110 PHD screen system,7 PHDADMIN,8
PHDPDL compiler,7 overflow, ellipsis (...),166 PORTABLE option
SET SUBFILE statement,157 PowerHouse
components,7-8 description,7 utilities,8
PowerHouse Web, description,9 preventing generic retrieval
CHOOSE statement,44 PRIMARY option
SET SUBFILE statement,154 primary record-structure
extracting data records,38-49 primary-record option
SET JOB statement,131 SET REPORT statement,143 printing
control footings,78 reports,143
reports, to terminal,144 PRIORITY option
SET JOB statement,131
SET REPORT statement,145,147 processing
phases,11-13 processing phases
parser,11 reporter,11
processing source statements,171 PROMPT option
query-specification (SELECT) statement,103-105 QUEUE option
SET JOB statement,131 SET REPORT statement,147 QUICK, description,8
CHOOSE statement,42,43 ranges
CHOOSE statement,46 RATIO summary operation
FOOTING AT statement,78 HEADING AT statement,83 report-item statement,110
choosing with partial values,38 extracting data,38-49
number, specifying linkage,31 retrieving partial value,43 retrieving, index order,45 records complexes
recreating pre-7.29 subfiles,158 relationships
one-to-many,23-28 one-to-one,23 parallel,123 REPEATING option
SET SUBFILE statement,154 REPORT option
SET statement,133 REPORT statement,107-108 report-control settings
changing,142-152
reporter processing phase,11 report-group option
FINAL FOOTING statement,74 FOOTING AT statement,78 report-group statement,109
breaking into two passes,162 canceling,36
compiled, building,33 compiled, saving,33 defining,11
detail lines, setting content and format,107-108,109 executing,82
initial page numbers,140 lines between,107
Index
reports(cont'd)
printing to printer,143 printing to terminal,144 processing statements,171 producing,11
recompiling,33
routing to a nonspooled printer,148 routing to a printer,149
routing to a terminal,149 routing to disc,148
routing to magnetic tape,149 statistics,133
suppressing blank lines,127 titles, centering,140 writing to disc,143 RESERVE option
SET JOB statement,131 SET REPORT statement,147 RETAIN ORDER option
operating system in QUIZ,73,106 RETURNING option
SQL DECLARE CURSOR (stored procedure) statement, 53
REVISE statement,118 asterisk (*),118 routing reports
to magnetic tape,149 to nonspooled printer,148 to printer,149 reports to disc,143,148 temporary files,36 scaling
factor, establishing,63 SEGMENT item option
SET SUBFILE statement,155 SEGMENT option
SET SUBFILE statement,155 segments
specifying linkage,31 SELECT IF option
SELECT statement,122
SELECT record-structure IF condition SELECT statement,122
SELECT statement,122-124 CHOOSE statement,43 selecting values
selection conditions
adding to previously compiled reports,124 applying to transactions,122
selection criteria adding additional,124 SEPARATOR option
CHOOSE statement,42 DEFINE statement,60,65 report-item statement,116 sequence
prompts,45
SET DICTIONARY statement,128 SET JOB statement
SET statement,134 SET LIST SQL,46 SET option
SQL DECLARE CURSOR (stored procedure) statement, 53
SET PAGE statement,140-141 SET statement,134
SET REPORT statement,142-152 SET statement,134
SET statement,126-139
SET SUBFILE statement,154-165 SET statement,134
settings
blank spaces between report-items,145 name of output device,145
page-control, changing,140-141 shifting case
of characters,58,69 SHOW statement,166 SET SUBFILE statement,157 SKIP option
REPORT statement,107 report-item statement,110 slave printer support,150 SORT statement,167
performing,12
RESET PAGE option,167 SORTED statement,169
FOOTING AT statement,78 source statements
processing,171 SPACE option
SET statement,133 SPACING option
SET REPORT statement,145 special characters
date separator characters,42,65,116 fill character (*),60,112
SQL DECLARE CURSOR (query specification) statement, 50
SQL DECLARE CURSOR (stored procedure) statement, 52-54
sql-condition general term
query-specification (SELECT) statement,104 sql-substitution
displaying during processing,171 EDIT,69-70
SQL DECLARE CURSOR (query specification),50 SQL DECLARE CURSOR (stored procedure),52-54 table,15
SYBASE SQL SERVER support,54 stored-function (ORACLE) syntax
SQL DECLARE CURSOR (stored procedure) statement, 52
stored-procedure syntax
SQL DECLARE CURSOR (stored procedure) statement, 52 permanent, naming conflicts,159 storage,157
temporary, creating,158 temporary, naming conflicts,158 types,158
using,158 writing items,160
writing substructured items,161 substituting
a colon for THEN,58 substructured items
writing to subfiles,161 SUBTOTAL summary operation
FOOTING AT statement,78 HEADING AT statement,83 report-item statement,110 summaries
final footing,74 summary operations
FOOTING AT statement,78 HEADING AT statement,83 report-item statement,110 SUMMARY option
REPORT statement,107 SYBASE SQL Server support
stored procedures,54 SYMBOL option
CHOOSE statement,43 SYSTEMVALUE option
CHOOSE statement,42,48 using ranges,49
item datatype defaults,57
linkage options, ACCESS statement,21 naming permanent subfiles,159 statements,15
TAPE option
SET REPORT statement,144 TEMPORARY option
SET SUBFILE statement,156 temporary save files
clearing,36
temporary subfiles,158 TERMINAL option
SET REPORT statement,144 TERMINATE option
DEFINE statement,53 time-outs
parm-prompts,44 TITLE option
SET PAGE statement,140
Index
SET REPORT statement,147 trailing blanks
applying selection conditions,122 two-digit years
specifying,41,59,61,112
U
UNIQUE option
SET SUBFILE statement,154 UNORDERED option
SET SUBFILE statement,154 UNSIGNED option
DEFINE statement,56 uppercase characters
shifting to lowercase,58,69 UPSHIFT option
SET JOB statement,131 SET REPORT statement,147 USERS INCLUDE option
selecting in CHOOSE statement,45 VERIFY DELETE option
record-structures and items,21
W
query-specification (SELECT) statement,104 WIDTH option
SET PAGE statement,140 wildcard matches,43 SET JOB statement,131 WSEXTENT option
SET JOB statement,131 WSQUOTA option
SET JOB statement,131
Z
zeros
displaying,60