-
Notifications
You must be signed in to change notification settings - Fork 0
/
help22.txt
4776 lines (3692 loc) · 173 KB
/
help22.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
This is System 1022, a database management system. The 1022 HELP command
provides online information about the 1022 features and commands listed below.
To read the HELP information for a given feature or command, type HELP and then
a space and then the topic keyword followed by a <RETURN>. For example, to
read about the FIND command, type:
HELP FIND<RET>
&HELP
The HELP command provides on-line information about 1022 features and commands.
To read the information for a given feature or command, type HELP, then a
space, then the topic keyword followed by a <RETURN>. For example, to read
about the INFORM command, type:
HELP INFORM<RET>
Additional information may be found under the subtopics listed at the end of
individual HELP messages. To read this information, type HELP, a space, the
topic keyword, a space, and then the subtopic keyword followed by a <RETURN>.
For example, to learn about the BASE subtopic listed at the end of the INFORM
message, type:
HELP INFORM BASE<RET>
For a list of the 1022 features and commands for which there are HELP messages,
type:
HELP<RET>
&117
Version 117 of System 1022 introduces major internal changes that make it
possible to support the Large Data Sets Module. As a result, data sets
created under 117 have an internal format that is different from that of data
sets created under previous versions of 1022. 117 supports both formats but
operates more efficiently on data sets in new format than on data sets in
pre-117 format. Until the old format structures are converted, data sets
cannot exceed the block and record maxima of previous versions of System 1022.
Conversion from old format to new is therefore strongly recommended.
Conversion from old to new format is accomplished with two commands. First,
the user issues an UPTO 117 command. If there are key tables or delete
lists in the old format, UPTO issues a warning. The user then issues an
OPTIMIZE ALL command, which performs the actual conversion.
For further details, see the document 117B.MEM.
&@
The @-construction may be used to supply portions of commands or command blocks
provided in disk files, supplied in text variables, or typed directly by the
user at the time of execution. If no extension is specified in the
file-descriptor following @, DMC is assumed first, then a null extension. The
syntax is:
{ file-descriptor }
@ { =variable-name }
{ TTY: }
See also USE
&ADD
The ADD command adds a new record to the current data set. The simple use of
ADD prompts the user for the value of each attribute. ADD with a list allows
the user to enter data for a new record by listing each attribute followed by
its value. The syntax is:
ADD [attribute-name value [attribute-name value] [NUL] ]
For example:
ADD TITLE 'APOCALYPSE NOW' YEAR 1979 NUL - adds the value APOCALYPSE NOW for
the attribute TITLE, the value
1979 for the attribute YEAR, and
null values for all the other
attributes of a new record in the
current data set.
&APPEND
The APPEND command adds a group of new records to the current data set. The new
records are read from a data file or data set. Unlike ADD, APPEND postpones
updating the key tables until all the data records have been appended to the
data set. The syntax is:
{ DATA file-descriptor1 [DESC file-descriptor2] }
APPEND { }
{ SET data-set-descriptor }
[NOMSG] [NODME] [CUSTDMI] [LRECL option]
[FORMFEED option] [CORE option] [BUFFER n]
For example:
APPEND DATA CINE DESC FILMS - reads the data file CINE.DMI according to the
format specified in FILMS.DMD and appends the
records to the current data set, ignoring any
attributes in FILMS.DMD not found in the data
description of the current set.
&CHANGE
The CHANGE command changes the value of an attribute in a currently selected
record or records to a new value specified by the user. A change to a keyed
attribute automatically updates the key tables. The changed record is
immediately retrievable using its new values. The syntax is:
CHANGE attribute-name expression [attribute-name expression]...
where an expression is an attribute, variable, or value (or a string thereof
containing one or more arithmetical operators).
For example:
CHANGE S1FN MARLON - changes the value of the attribute S1FN in the currently
selected record(s) to MARLON.
CHANGE GROSS 2*GROSS - changes the value of the attribute GROSS to two times
GROSS in the currently selected record(s).
&CLEAR
The CLEAR command removes certain user-assigned definitions. By itself, CLEAR
removes all previously defined variables; when followed by COLLECT or JOIN,
CLEAR removes previously defined collections or joins, respectively. The
syntax is:
{ COLLECT }
CLEAR [ { } ]
{ JOIN }
&CLEAR JOIN
The CLEAR JOIN command removes JOIN definitions. If no join names are
specified in issuing the command, CLEAR JOIN will clear all defined joins.
The syntax is:
CLEAR JOIN [join-name-1]...[[,]join-name-n]
See also DISABLE, ENABLE, JOIN
&CLEAR COLLECT
The CLEAR COLLECT command releases data sets from collections defined by
COLLECT commands. It does not alter the selection groups or the current
data set. When no collection name is specified all currently defined
collections are cleared. The syntax is:
CLEAR COLLECT [collection-name-1] ... [ [,] collection-name-n]
See also COLLECT
&CLOSE
The CLOSE command closes the current data set. A closed data set is unavailable
for retrieval or modification until it is opened again. The syntax is:
CLOSE
&COLLECT
The COLLECT command groups one or more open data sets into a collection which
is then treated in most respects as a single data set containing all the
records of the constituent data sets. All of the data sets in the collection
must share identical structure and ADMIT specifications and may be referenced
and accessed only as part of the collection. Collections are referenced by
their unique collection names. The syntax is:
{ set-1 ... [set-n] AS collection-name }
COLLECT { } [ADD set]
{ ALL [AS] collection-name }
The ADD set clause allows you to specify which of the data sets in the
collection subsequent ADD or APPEND commands should apply. The default is
the last data set named in the COLLECT command.
For example:
COLLECT FILMS CINE as A - forms a collection named A from the identically
structured open data sets FILMS and CINE and names.
See also CLEAR COLLECT, INFORM COLLECT
&CREATE
The CREATE command forms an unbundled data set from an existing data file. That
is, the CREATE command forms a data set in which the data records are kept
in a separate file from the key tables and other 1022 information. The syntax
is:
CREATE DESC file-desc1 [DATA file-desc2] [SET data-set-desc]
[NOMSG] [LRECL n]
where DESC file-descriptor1 names a file containing a data set description,
DATA file-descriptor2 names the corresponding data input file, and SET data-
set-descriptor names the data set being built.
For example:
CREATE DESC FILMS DATA FILMS SET CINE - builds the (unbundled) data set
CINE.DMS from the description file
FILMS.DMD and the data file FILMS.DMI.
See also LOAD
&DBSET
The DBSET command establishes a specified open data set as the current one.
The syntax is:
{ data-set-descriptor }
DBSET { alias }
{ number }
For example:
OPEN FILMS DIRECT - opens the data sets FILMS and DIRECT.
DBSET DIRECT - specifies DIRECT as the current data set.
DBSET 1 - specifies FILMS (which is the first of the two data sets
named in the OPEN command) as the current data set.
See also INFORM BASE, INFORM SET
&DELETE
DELETE removes selected records from the current data set. These records are
still present in the data set, but cannot be selected by FIND commands. The
syntax is:
DELETE
For example:
FIND CTRY USA - selects the records in the current data set with the value
USA for the attribute CTRY.
DELETE - removes those records from the current data set.
See also DFIND, UNDELETE
&DFIND
The DFIND command forms a selection group using keyed attributes of records
that have been deleted from the current data set. The syntax is:
{ ALL }
DFIND { }
{ rel-expr [ [NOT] logical-operator rel-expr]... }
where a relational expression is:
{ attribute }
{ [NOT] relational-operator value }
{ SYSID }
{ LAST }
{ FILE file-descriptor }
For example:
FIND ALL - forms a selection set of all of the records in the data set.
DELETE - deletes those records from the data set.
DFIND ALL - forms a selection set of all of the just deleted records.
See also DELETE, UNDELETE, FIND
&DISABLE
The DISABLE JOIN command turns off previously defined join definitions in
a PL1022 or report program. If no join name is specified, DISABLE JOIN
disables all currently defined joins. The syntax is:
DISABLE JOIN [join-name-1]...[[,]join-name-n]
See also CLEAR JOIN, ENABLE, JOIN
&DROP
The DROP command removes the current record, selected by GETREC, from a
selection group. The record is still part of the data set and can be
retrieved with a new FIND command. DROP does not alter or delete any records.
The syntax is:
DROP
For example:
FIND ALL - forms a selection group containing all the records in the data set.
GETREC 20 - selects the 20th record in the selection group.
DROP - removes the 20th record from the selection group.
See also DELETE, GETREC
&ENABLE
The ENABLE JOIN command turns on previously defined join definitions in a
PL1022 or report program. It can be used conditionally. If no join name is
specified, ENABLE JOIN enables all previously defined joins. The syntax is:
ENABLE JOIN [join-name-1]...[[,]join-name-n]
See also CLEAR JOIN, DISABLE, JOIN
&EXIT
The EXIT command ends a System 1022 session and returns the user to operating
system level, closing any data sets and output files. EXIT is identical to
QUIT. The syntax is:
EXIT
&FILE
The FILE command manipulates disk files from System 1022. The four
options which may be used with FILE are COPY, DELETE, RENAME, and TYPE.
A file name and extension must be given, as no wildcards are accepted in the
FILE commands. The syntax is:
{ COPY }
{ DELETE }
FILE { RENAME }
{ TYPE }
&FILE COPY
The FILE COPY command copies a disk file. The syntax is:
FILE COPY file-descriptor1 [TO] file-descriptor2 [BUFFERS n]
where file-descriptor1 names the source file and file-descriptor2 names the
destination file.
For example:
FILE COPY FILMS.DMD MYFIL.DMD - makes a copy of the file FILMS.DMD and names
the new file MYFIL.DMD
&FILE DELETE
The FILE DELETE command deletes the named disk file. The syntax is:
FILE DELETE file-descriptor
For example:
FILE DELETE TEST.DMS - deletes the file TEST.DMS
&FILE RENAME
The FILE RENAME command renames a disk file. The syntax is:
FILE RENAME file-descriptor1 [TO] file-descriptor2
where file-descriptor1 is the original name of the file and file-descriptor2
is the file's new name.
For example:
FILE RENAME DIRECT.DMD MENS.DMD - takes the file DIRECT.DMD and renames it
MENS.DMD
&FILE TYPE
The FILE TYPE command prints a disk file at the user's terminal.
The syntax is:
FILE TYPE file-descriptor
For example:
FILE TYPE PRIZE.DMI - displays the contents of this file on
the terminal.
&FIND
The FIND command forms a selection group of active records from the current data
set using keyed attributes. The syntax is:
{ ALL }
FIND { }
{ rel-expr [ [NOT] logical-operator rel-expr]...}
where a relational expression is:
{{ attribute1 } }
{ [NOT] relational-operator value }
{{ SYSID } }
{ LAST }
{ FILE file-descriptor }
For example:
FIND YEAR LT 1979 - forms a selection group of the records in which the
value for the keyed attribute YEAR is less than 1979.
&GETREC
The GETREC command selects a single record from the current selection group.
The simple GETREC command will single out the first record in the group.
Succeeding GETREC commands will select succeeding records, one at a time. A
record can also be selected by its SYSRECNO with GETREC. The $LOCK option
allows you to deny other users access to the selected record if the data set
is ENQ and RECLOCK. The syntax is:
GETREC [$LOCK] [n]
For example:
FIND YEAR BET 1950 1960 - forms a selection group of the records in which the
value for the attribute YEAR is between 1950 and 1960.
GETREC - selects the first record in the selection group.
GETREC - selects the next record in the selection group.
GETREC 5 - selects the fifth record in the selection group.
&JOIN
The JOIN command performs automatic mapping between two open data sets or
collections by matching locator attribute values. Each join relation created
by the JOIN command is unidirectional (from set1 to set2) if the UNI option is
used and bidirectional otherwise. The syntax is:
JOIN set1 [TO] set2 [VIA] attr1 [[TO] attr2] [AS name] [UNI] [NOMSG]
where set1 and set2 are the data sets to be joined; attr1 is the attribute
in set1 which is used as a locator to relate the two sets (and must be
keyed unless UNI is in effect); attr2 is the (keyed) locator in set2; and
name is the user-assigned name or system-assigned number which uniquely
identifies the join.
For example:
OPEN FILMS DIRECT - opens the data sets FILMS and DIRECT.
JOIN FILMS DIRECT VIA DIR TO SURNAME - joins the data sets FILMS and DIRECT
using the keyed attributes DIR (in FILMS)
and SURNAME (in DIRECT) as locators.
See also: CLEAR JOIN, ENABLE, DISABLE, INFORM JOIN, MAP
&INFORM
The INFORM command displays information about the structure and condition
of the current data set at the user's terminal or, if the ON option is
used, writes this information into a file. The syntax is:
{ ADMIT [user-id] }
{ ATTRIBUTE attribute-name [LENGTH] }
{ AUDIT }
{ BASE }
{ { COLLECT } { [NAME] } }
{ { JOIN } { NUMBER } }
{ DAMAGE }
INFORM [ON file-descriptor] { DATA }
{ DMX }
{ FILES }
{ NAMES }
{ SET }
{ STATUS }
{ STRUCTURE [LENGTH] }
{ VERSION }
&INFORM ADMIT
The ADMIT option of the INFORM command displays ADMIT information about the
security structure of the current data set. If user-id is specified, only
the ADMIT information applying to that user is given. Otherwise, all ADMIT
specifications for the data set are given. This command is restricted to use
by the System Administrator or data set owner. The syntax is:
INFORM [ON file-descriptor] ADMIT [user-id]
&INFORM ATTRIBUTE
The ATTRIBUTE option of the INFORM command displays information about the
structure of specified attributes in the current data set. The LENGTH option
gives the attribute length rather than column position. The syntax is:
INFORM [ON file-descriptor] ATTRIBUTE attribute-name [LENGTH]
For example:
OPEN FILMS - opens the FILMS data set.
INFORM ATTRIBUTE S1S LENGTH - displays the following information:
ATTRIBUTE STAR_1_SURNAME ABBREV S1S TEXT
KEYED LENGTH 12 !PRE-117
See also INFORM STRUCTURE
&INFORM AUDIT
The AUDIT option of the INFORM command displays information concerning the
status of the audit trail for the current data set. The syntax is:
INFORM [ON file-descriptor] AUDIT
&INFORM BASE
The BASE option of the INFORM command displays the full data set descriptors
of all open data sets and identifies the current data set with an arrow
(<=). The syntax is:
INFORM [0N file-descriptor] BASE
For example:
OPEN FILMS DIRECT - opens the data sets FILMS and DIRECT.
INFORM BASE - displays the following information:
FILMS2 in FILMS.DMS !is set #1 <=
DIRECT in DIRECT.DMS !is set
See also INFORM SET
&INFORM COLLECT
The COLLECT option of the INFORM command displays all the current
collection names together with the names or numbers of their constituent
data sets. The syntax is:
{ [NAME] }
INFORM [ON file-descriptor] COLLECT { }
{ NUMBER }
For example:
COLLECT FILMS CINE AS A - forms a collection of the data sets FILMS and CINE.
INFORM COLLECT - displays the following information:
COLLECT FILMS CINE as A.
INFORM COLLECT NAME - displays the following information:
COLLECT FILMS CINE as A.
INFORM COLLECT NUMBER - displays the following information:
COLLECT 1 2 AS A.
&INFORM DAMAGE
The DAMAGE option of the INFORM command displays the DAMAGE information for
each open data set. No message prints for open data sets which are
undamaged. When a set is damaged, the message lists the data set name,
number, user-ids, and the date and time when the data set was first damaged.
The syntax is:
INFORM [ON file-descriptor] DAMAGE
&INFORM DATA
The DATA option of the INFORM command displays the data file descriptor of the
current unbundled data set. The syntax is:
INFORM [ON file-descriptor] DATA
See also CREATE
&INFORM DMX
The DMX option of the INFORM command displays information about the run-time
environment that must exist for the execution of a precompiled PL1022 or
report program with the PERFORM command or for the recompilation of the
source file with the COMPILE command. The information returned by INFORM DMX
includes the full name of the specified DMX file, the major and minor version
of 1022 under which the file was compiled, a warning that the version under
which the file was compiled is incompatible with the current version (if that
is so), the full name of the source file, a descriptive list of all user-
defined variables referenced by the program, and a descriptive list of all
data sets, collections, and join relations referenced, explicitly or implicitly,
by the program. The syntax is:
INFORM [ON file-descriptor-1] DMX file-descriptor-2
&INFORM FILES
The FILES option of the INFORM command displays a list of all of the 1022 I/O
channels (in TOPS-10) or JFNs (in TOPS-20) in use and the file specification
associated with each. If the channel or JFN is reserved by a background 1022
function, the message "(reserved)" is given. The syntax is:
INFORM [ON file-descriptor] FILES
&INFORM JOIN
The JOIN option of the INFORM command displays a list of all currently defined
joins. The list gives the name or number of each join and
each constituent data set, identifies the locators, and labels all disabled
joins. The syntax is:
{ [NAME] }
INFORM [ON file-descriptor] JOIN { }
{ NUMBER }
For example:
JOIN FILMS DIRECT VIA DIR TO SURNAME - joins the data sets FILMS and DIRECT
using the attributes DIR (IN FILMS) and
SURNAME (in DIRECT) as locators.
INFORM JOIN - displays the following information:
JOIN FILMS TO DIRECT VIA DIR TO
SURNAME ! AS 10000.
&INFORM NAMES
The NAMES option of the INFORM command displays a list of all the attribute
names in the current data set. The syntax is:
INFORM [ON file-descriptor] NAMES
For example:
OPEN DIRECT - opens the data set DIRECT.
INFORM NAMES - displays the following information: DIRECTOR_ID
FIRST_NAME
SURNAME
YEAR_OF_BIRTH
BIRTHPLACE
&INFORM SET
The SET option of the INFORM command displays the full data set descriptor
of the current data set. The syntax is:
INFORM [ON file-descriptor] SET
For example:
OPEN DIRECT FILMS - opens the data sets DIRECT and FILMS with DIRECT as
the current data set.
INFORM SET - displays the following information:
DIRECT in DIRECT.DMS !is set #1
See also INFORM BASE
&INFORM STATUS
The STATUS option of the INFORM command displays information concerning the
status of the current data set. The display contains:
The name of the data file (for unbundled data sets).
The mode (if unbundled).
The blocking factor and data mode of the data file (if unbundled).
The version of 1022 under which it was created.
UPDATE status (ON, PREVENTed, or blank).
The message "Default update mode is ENQ" if that is so.
The message "Dataset is RECLOCK" if that is so.
The specification "Dataset opened readonly" if that is so.
The message "data set damaged" if that is so.
Compatibility information.
The total number of records, both active and deleted.
The statement "dataset damaged" if damage has occurred.
The number of records allocated to the data set.
The date and time of the last update.
The user-id of the last update.
The number of disk reads since startup (Rd0) (for all open data sets).
The number of requests of a disk block (Rd1) (for all open data sets).
The number of disk writes since startup (Wd0) (for all open data sets).
The syntax is:
INFORM [ON file-descriptor] STATUS
&INFORM STRUCTURE
The STRUCTURE option of the INFORM command lists all of the attributes in the
current data set and describes the structure of each as it appears in the
set's description (DMD) file. If the data set is in pre-version 117A format,
the comment !PRE-117 follows each keyed or keyed inactive attribute. The
LENGTH option gives the number of columns (rather than the column positions)
which the values for each attribute may occupy and shows filler lines where
they exist. The syntax is:
INFORM [ON file-descriptor] STRUCTURE [LENGTH]
For example:
OPEN DIRECT - opens the data set DIRECT.
INFORM STRUCTURE - displays the following information:
ATTRIBUTE DIRECTOR_ID INTEGER_OF_IDENTIFICATION KEYED
COL 1 3 !PRE-117
ATTRIBUTE FIRST_NAME ABBREV FN TEXT COL 4 18
ATTRIBUTE SURNAME ABBREV SN TEXT COL 19 33
ATTRIBUTE YEAR_OF_BIRTH ABBREV YOB INTEGER KEYED
RANGE 1870 1990 COL 34 37 !PRE-117
ATTRIBUTE BIRTHPLACE ABBREV B TEXT COL 38 67
&INFORM VERSION
The VERSION option of the INFORM command displays information concerning the
current version of System 1022. The display contains:
A version banner, e.g., "System 1022B 116A (402)".
A list of the optional 1022 modules licensed by your site. Modules
not licenses by your site appear in parentheses, e.g.,
"System Options: Security, Audit Trails, LDS, HLI (no Accounting)"
The file name of the current high segment, e.g.,
"Segment origin: <V116I.20>QN1600".
A list of all patches installed (if any).
The system generation date.
&DUMP
The DUMP command creates a new data set or file from the records
in the current selection group. The syntax is:
{ [SET] data-set-desc }
DUMP { [UNBUNDLED SET data-set-desc] [DATA file-desc1] }
{ DATA file-desc1 }
[DESC file-desc2]
[BUFFER n] [SORTED [BY] sort-clause]
For example:
DUMP SET NEWSET - creates the data set NEWSET.DMS
DUMP DATA OLDFIL - creates the data file OLDFIL.DMI
DUMP SET NEWSET DESC OLDSET - creates the data set NEWSET with
the structure of OLDSET.DMD.
&VALUES
The VALUES command displays the value distributions of a specified keyed
attribute in the current selection group. The syntax is:
VALUES [ON file-desc] attribute [VALUES] [SYSID] [COUNT] [COLUMN]
For example:
FIND YEAR BET 1947 1951 - creates a selection group of the records in
which the value for the (keyed) attribute YEAR
is between 1947 and 1951.
VALUES YEAR - displays the following information:
1947 (4)
1948 (1)
1949 (2)
1950 (2)
1951 (3)
&USE
The USE command executes a set of 1022 commands stored in a disk file. The
syntax is:
USE file-descriptor
where the file-descriptor names the file which contains the commands to be
executed.
For example:
USE PUB:PRM1 - executes the commands in the file PUB:PRM1.DMC
See also @
&UNKEY
The UNKEY command deletes key tables for specified attributes. The syntax is:
UNKEY attribute-list
where each entry in the attribute list is:
{ [REUSE] } { attribute }
{ NOREUSE } { }
{ REMOVE } { ALL }
For example:
UNKEY STUDIO CTRY - deletes the key tables for the attributes STUDIO
and COUNTRY.
UNKEY REMOVE GROSS REUSE ALL - deletes the key table for the attribute GROSS,
exempting it from rekeying by a future KEY ALL
command, and deletes the key tables for all the
other attributes (which may be rekeyed by KEY
ALL).
See also KEY
&UNDELETE
The UNDELETE command reactivates previously deleted records selected by the
DFIND command. The syntax is:
UNDELETE
For example:
DFIND ALL - finds all of the previously deleted records in the current
selection group.
UNDELETE - restores those records to the selection group.
See also DELETE, DFIND
&TYPE
The TYPE command directs output to the terminal. The syntax is:
TYPE output-list [FORMAT format END]
where an output list may contain, singly or in combination: ALL, attribute
names, quoted literals, user-defined or system variables, arithmetical
expressions, and totals functions.
For example:
TYPE TITLE - displays the values for the attribute TITLE in the current
selection group at the user's terminal.
TYPE "TITLE" - displays the quoted literal TITLE at the user's terminal.
See also FORMAT, PRINT
&STARTREC
The STARTREC command returns to selection-group (global) mode from single-
record (local) mode, preserving the original (or sorted) order of records in
the selection group but omitting any records dropped while in local mode. The
syntax is:
STARTREC
For example:
FIND YEAR 1945 - creates a selection group
GETREC - accesses the first record in that selection group
DROP - drops that record
STARTREC - returns to the original selection group (from which the first
record has been dropped).
See also GETREC
&SPSS
The SPSS command produces files to be analyzed with the Statistical Package
for the Social Sciences. The syntax is:
SPSS FILE file-name [SUBFILE file-name] [option(s)]
where the available options are:
ATTRIBUTES attr1 attr2 attr3...
NOTEXT
INFORM
VARNUM
CASWGT expression
GO [USING command-string]
&SORT
The SORT command arranges the records in a selection group alphabetically,
numerically, or by date. The syntax is:
SORT [CORE n] [USING structure] [BY] expr seq-desc [ [BY] expr seq-desc ]...
where an expression is an attribute or sequence of attributes (which may be
linked by arithmetical symbols or operated on by string functions), and a
sequence-descriptor is one of the following:
[ASCENDING] (or [UP])
DESCENDING (or DOWN)
For example:
SORT YEAR DOWN TITLE - arranges the records in the selection group by their
values for the attribute YEAR, from the most recent to
the least recent, and arranges those records sharing the
same value for YEAR in alphabetical order by value for
the attribute TITLE.
&SEARCH
The SEARCH command is used to narrow a selection group created by a prior FIND
command. Unlike FIND, SEARCH works on both keyed and unkeyed attributes. The
syntax is:
SEARCH rel-expr [ [NOT] logical-operator rel-expr ]...
where a relational-expression is:
{{ attribute1 } { attribute2 }}
{ [NOT] relational-operator }
{{ SYSID } { value }}
{ LAST }
For example:
FIND CTRY EQ USA - creates a selection group
SEARCH DIR EQ WRITE - selects the records from that group in which the value
for the attribute DIR is the same as that for WRITE.
See also FIND, SELECT
&SELECT
The SELECT command narrows a selection group created by a prior FIND
command. SELECT differs from SEARCH only in that it does not take effect until
record retrieval time. The syntax is:
SELECT rel-expr [ [NOT] logical-operator rel-expr]...
where a relational-expression is:
{{ attribute1 } { attribute2 }}
{ [NOT] relational-operator }
{{ SYSID } { value }}
{ LAST }
For example:
SELECT MUSIC EQ AURIC - locates the records in the current selection group in
which the value of the attribute MUSIC is AURIC.
PRINT TITLE - retrieves those records and prints their values for the
attribute TITLE.
See also FIND, SEARCH
&SAVE
The SAVE command stores the record numbers of the current selection group in a
disk file, preserving the sorted order of the records. The saved selection
group may be retrieved with a FIND FILE command. The syntax is:
SAVE file-descriptor
See also FIND, DFIND
&QUIT
The QUIT command ends a System 1022 session and returns to the operating system.
QUIT is identical to EXIT. The syntax is:
QUIT
&PUSH
The PUSH command suspends System 1022 operations and goes to TOPS-20 EXEC level
while preserving the 1022 environment. The TOPS-20 POP command returns the user
to 1022. The syntax is:
PUSH [USING string END]
where string is a list of commands to be executed at TOPS-20 EXEC level.
For example:
PUSH USING DEL MEMO.* END - leaves 1022, preserving the environment, goes to
TOPS-20 EXEC level, and deletes the MEMO files.
POP - returns to 1022 environment.
&PRINT
The PRINT command directs output to the terminal or, with the ON option, to a
disk file. The syntax is:
{ file-desc } { }
PRINT [ON { }] { output-list } [FORMAT format END]
{ channel-n } { }
where an ouput list may contain, singly or in combination: ALL, attribute
names, quoted literals, user-defined or system variables, arithmetical
expressions, and totals functions.
For example:
PRINT ON TY.OUT TITLE - writes the values for the attribute TITLE in the
current selection group into a file TY.OUT.
PRINT TITLE YEAR - displays the values for the attributes TITLE and
YEAR of the current selection group.
See also FORMAT, INIT, RELEASE, TYPE
&OPEN
The OPEN command opens one or more data sets, closing any previously opened
files unless the NOCLOSE option is used. The $MISSING keyword is used to
open a multifile data set after one or more of its auxiliary files have
been lost. The syntax is:
OPEN [NOCLOSE] item-1 [$MISSING] [item-2 [$MISSING]...]
where an item is:
{ ENQ }
[data-set-desc IN] file-name [PASS pswd] [RO] [AS alias] [ { } ]
{ NOENQ }
For example:
OPEN FILMS RO DIRECT RO - opens the data sets in the FILMS and DIRECT files
which the user may read but not update (Read Only).
OPEN CAST NOCLOSE - opens the data sets in the CAST file without closing
other open files.
OPEN MYFILE $MISSING - opens the multifile data set MYFILE one of whose
auxiliary files is missing.
&MAP
The MAP command locates the records in a second open data set that share
attribute values with records in the current selection group. The syntax is:
{ KEY } { AND }
MAP [BY { }] [LOGICAL { OR }] [TO] ds-desc [VIA] attr1 [ [TO] attr2]
{ GETREC } { CLEAR }
[AND [VIA] attr3 [ [TO] attr4] ]...
where ds-desc is the name, alias, or number of the target (second) data set in
which records are to be located by matching values for attribute1 in the source
(current) data set with values for (keyed) attribute2 in the second.
For example:
MAP TO FILMS VIA SURNAME TO S1S - locates the records in the FILMS data set
in which the value of the attribute S1S is
the same as that for SURNAME in the current
selection group (of the source data set).
&LOAD
The LOAD command builds a bundled data set. The syntax is:
LOAD [DESC] file-desc1 [DATA file-desc2] [SET data-set-desc] [NOKEYS] [MAX n]
[NOMSG] [NODME] [CUSTDMI] [CORE n] [BUFFER n]
{ n } { TERMINATOR }
[LRECL { } ] [FORMFEED { } ]
{ [V] } { IGNORE }
where DESC file-descriptor1 names a file containing a data set description,
DATA file-descriptor2 names the corresponding data input file, and SET data-set-
descriptor names the data set being built.
For example:
LOAD DESC FILMS DATA FILMS SET CINE - builds the data set CINE.DMS from the
description file FILMS.DMD and the data
file FILMS.DMI.
See also CREATE
&KEY
The KEY command creates or rebuilds key tables for specified attributes for
fast retrieval. The syntax is:
KEY [NOMSG] [USING structure] [BUFFER n] attribute-list
where each entry in the attribute-list is:
{ [REUSE] } { attribute-name }
[NULL n] [CORE n] { } { }
{ NOREUSE } { ALL }
For example:
KEY NOREUSE MUSIC S1FN - builds key tables for the attributes MUSIC and S1FN
on new disk space (rather than on blocks previously
occupied by old key tables).
See also UNKEY
&KEY $CHECKSUM
The KEY $CHECKSUM command informs the user whether or not the key tables for
specified attributes have been damaged. The syntax is: