Welch Company
San Francisco, CA


S U M M A R Y


DIARY: March 1, 2001 09:10 AM Thursday; Rod Welch

Op Tech Sort seems to solve problem by replacing Supersort.

1...Summary/Objective
2...Opt Tech Sort Conversion from Supersort Commands
3...Opt Tech Sort Solves Performance Problem Experienced with Supersort
....no-o Not Needed?????
....no-r Not Needed?????
4...06112 Subject, File and Contact Reports
....DoS /c s i 360 cr;no-r;s d:\sd\08\UUUUU\TT\YY\__;o 1Y___ k-out;no-o;cf 1z >nul:
............Input filename
5...OTS has a much simpler, streamlined method of specifying the selection
.....................o.input output control
6...061122 Selection Conrol Statement
.....Outrec replaces K-out to Capture Pointers in 1Y
.....Include Replaces Select and Supports Exclude
.....Exclude Accomplished with NE Param for Include
.....Sort Replaces Key
7...Primary Selection Spec for Doc Log
8...061122 Optech Sort Command File Common Code for 06112 06113
9...Selection Loop for Subjects and Other Reports
10...Secondary Selection Op for Doc Log - 06113
....06113 Counter 266 Sets Criteria Secondary Selection
....061122 Secondary Doc Log Selection Criteria
....Secondary Doc Log Selection Criteria
....Contacts Selection Spec Loaded from Contact Summary
....Contacts Selection Spec Loaded from Contact Record
....044012 Subjects Posted to 06113 Doc Log Secondary Spec
11...000009 Change Method of Transferring Contact to Target Records
12...06113 Doc Log Reports Opt Tech Sort Replace Supersort
13...06113 Primary Selection Criteria for Doc Log Reports
....DoS /c s i 360 cr;no-r;s d:\sd\08\UUUUU\TT\YY\__;o 1Y___;cf 1z1
.............. Control statement file
....Consolidated report formats....
.......Cross Reference Field Abandoned
.......Doc ID field reduced and placed in right margin because it not
14...06113 Doc Log Report Format Revised
15...06113 Doc and SDS File Specs Positioned to Open Original Sources
16...06113 Report Headers Modified to New Layout
17...25.bat Global Pointers OTS Replaces Supersort.
18...0011 Select and Sort DocLog and Publication Pointers


..............
Click here to comment!

CONTACTS 
0201 - Opt Tech Data Processing
020101 - Ms. Page Newman
020103 - Technical Support Department

SUBJECTS
Opt Tech Sort, 010222
Supersort Convert to OTS
Reports Opt Tech Sort Replaced Supersort to Improve Reports on High S
06111 References Contacts Consolidated into 06112 on 010301
References, 06111 Consolidated into 06112 on 010301
061122 Selection Command File, Configure

1708 -
1708 -    ..
1709 - Summary/Objective
1710 -
171001 - Follow up ref SDS 57 0000, ref SDS 56 0000.
171002 -
171003 - Guidance for Opt Tech Sort (OTS), ref SDS 0 G8TG, made it possible to
171004 - change from using Supersort to using OTS applied with a new control
171005 - macro for building selection specs, 061122. ref SDS 0 CE4R  Testing
171006 - shows this solved problems running SDS under Windows 2000 on newer,
171007 - high end computer systems. ref SDS 0 KX5M  OTS appears to be 13+ times
171008 - faster than Supersort for selection operations on the global pointer
171009 - file running under w2k on a Pentium 1.4 GHz, 400 MHz bus computer.
171010 - OTS and Supersort produce SDS reports at about the same speed on
171011 - Pentium III and earlier systems.  This change enables c13 to perform
171012 - SDS reports much faster than slower systems, which it was previously
171013 - unable to accomplish under Windows 2000.  Converting to a stronger
171014 - technology (Optech Sort) for sorting and selecting data, based on the
171015 - new 061122 command file processor, ref SDS 0 PSPR, enabled other
171016 - improvements.  SDS now runs faster, ref SDS 0 4Q4K, with fewer User
171017 - steps, and reduced the overall size of the code to save memory, e.g.,
171018 - 06111 has been consolidated into 06112. ref SDS 0 IF6L
171019 -
171020 -     [On 010311 major improvement to doc log management in SDS records,
171021 -     and linking. ref SDS 58 7684
171023 -      ..
171024 -     [On 010313 notify Microsoft this problem solved. ref SDS 59 0001
171026 -      ..
171027 -     [On 010323 fixed Action Item report and make new task. ref SDS 60
171028 -     0001
171030 -      ..
171031 -     [On 010328 updated 06116 that creates HTML data base based on
171032 -     subjects, using 070405. ref SDS 61 0001
171034 -      ..
171035 -     [On 010402 sent letter thanking OTS for excellent program, and
171036 -     asking for submission of the Windows version. ref SDS 62 0001
171038 -      ..
171039 -     [On 010517 received inquiry from another customer who experienced
171040 -     performance difficulties running Windows 2000. ref SDS 63 0001
171041 -
171042 -
171043 -
171045 -  ..
1711 -
1712 -
1713 - Scope of Work
1714 -
171401 - Work in this record was performed fairly continuously from today,
171402 - 010301 until 010310, i.e, about 10 days for 15+ hours per day.
171404 -  ..
171405 - Substituted o.exe (Opt Tech Sort version 5.0a.4) to replace Supersort,
171406 - s.exe, and as explained below. ref SDS 0 G8TG
171408 -  ..
171409 - Changed following systems.....
171410 -
171411 -    1.  Global pointers
171412 -
171413 -           25.bat,............... ref OF 12 4L7J, below, ref SDS 0 J55K
171414 -           001 .................. ref OF 1 BK6H
171415 -           0011 ................. ref OF 2 OK5H
171417 -         ..
171418 -        These systems substitute OTS for Supersort
171420 -         ..
171421 -    2.  Reporting for......
171422 -
171423 -        a.  Files and Contacts
171424 -
171425 -            06111
171426 -
171427 -               This is deleted by consolidating into 06112, using the
171428 -               new command file development processor 061122, per
171429 -               below. ref SDS 0 PSPR
171431 -             ..
171432 -        b.  Subjects, Files and Contacts
171433 -
171434 -            06112,.......................... ref OF 8 FR4K
171435 -
171436 -               Substitute OTS for Supersort, per below. ref SDS 0 GTY4
171437 -
171438 -               Combined 06111 operation that formerly created reports
171439 -               on files and contacts, with original 06112 function to
171440 -               report on subjects.
171442 -                    ..
171443 -                   This change reduces time and cost for maintenance
171444 -                   and improvements, since these two operations were
171445 -                   very close, and were only seprated up until now,
171446 -                   because some selection criteria were different, and
171447 -                   it was easier 10 years ago to create separate
171448 -                   processors within the time available, at that time,
171449 -                   and it has been an effective solution, except for
171450 -                   having to duplicate changes for maintenance and
171451 -                   improvements.  The new design for 061122 that builds
171452 -                   nested selection specs as needed, explaind below,
171453 -                   eliminated the prior reason for having separate
171454 -                   processors, and so 06111 can now be eliminated.
171456 -                ..
171457 -               061122 created today makes it possible to eliminate cut
171458 -               and paste by developing report control statement op
171459 -               explained below, ref SDS 0 PSPR, that builds nested
171460 -               selection and sort specifications, as needed, rather
171461 -               than the prior method of holding them constant in the
171462 -               code. ref SDS 0 CE4R
171463 -
171464 -                   This seems like it improves memory management, but
171465 -                   not sure.
171467 -                ..
171468 -               Major design improvement today reduces the time to
171469 -               produce a report by 70%.  Since many reports only take a
171470 -               few seconds, the 70% mistake was not noticable.  Testing
171471 -               the new configuration, revealed the problem, and so the
171472 -               corretion was made.
171474 -                ..
171475 -               Expanded scope of subject reports by adding an "or"
171476 -               feature to look for following combinations, where s =
171477 -               subject, and f = function...
171478 -
171479 -                    s s s f f f
171480 -                      s f   s f
171482 -                ..
171483 -               Contact composite searches with subjects and functions
171484 -               has not yet been restored, but is rarely needed, and
171485 -               can be obtained by other means.
171487 -                ..
171488 -               Simplified screen layout and functions for entering
171489 -               selection specifications.
171491 -                ..
171492 -               Menu for Subject Reports still needs work.....
171494 -                       ..
171495 -                  1.  F5 Users needs to be eliminated because it
171496 -                      doesn't do much, or at least needs to be fixed,
171497 -                      so it does correctly whatever it is trying to do.
171499 -                       ..
171500 -                  2.  F6 Web Reports on Internet
171501 -
171502 -                      Not sure how or what this does.
171503 -
171505 -             ..
171506 -        c.  06113.................................. ref OF 10 GX5G
171508 -                ..
171509 -               Substitute OTS for Supersort
171510 -               ..
171511 -               Eliminated cut and paste by developing report
171512 -               control statement macro 061122, explained below, that
171513 -               builds nested selection and sort specifications, as
171514 -               needed, rather than prior method of holding them in the
171515 -               code.
171517 -                ..
171518 -               Expanded method of loading report specifications from
171519 -               Contact Summary and Contact Records so the person is
171520 -               automatically loaded as a second criteria.
171522 -                ..
171523 -               Personal Contacts were incorporated into doc log, after
171524 -               getting changes for organizations up and running.
171526 -                ..
171527 -               Added mouse control to open the Subject Index by double
171528 -               clicking, similar to this function in the Subject
171529 -               report.
171531 -                ..
171532 -               Simplified screen layout and functions for entering
171533 -               selection specifications.
171534 -
171535 -                  Eliminated a selection choice for.....
171536 -
171537 -                          Subject and Organization
171539 -                   ..
171540 -                  This choice is still available, but it arises more
171541 -                  natually now, in a way that is too difficult to
171542 -                  explain.
171544 -                ..
171545 -               Revised report formats slightly to improve utility.
171546 -
171548 -             ..
171549 -        d.  061122 ................................ ref OF 9 OZ6H
171550 -
171551 -               This constructs the command file for Op Tech Sort called
171552 -               in 06112, per above. ref SDS 0 6K5M
171553 -
171554 -               Developing 061122 the primary focus of work reported in
171555 -               this record took several days.  Pehaps 30 hours were
171556 -               devoted to modifying other processors. ref SDS 0 K85M
171558 -                ..
171559 -               The new 06112 command file development processor
171560 -               integrates 06112, 06113 and 000007, and it eliminates
171561 -               formerer macro file 06111 because it can be accomplished
171562 -               now with 06112 and the new command file processor
171563 -               061122.
171565 -                ..
171566 -               Provides a single process for developing control files
171567 -               with nested selection commands OTS uses to select
171568 -               records for all the reports, including Action Items.
171569 -
171571 -             ..
171572 -        e.  000007 ................................ ref OF 13 6290
171573 -
171574 -               Pulled a fair amount of code out of this and
171575 -               consolidated in 061122.
171576 -
171577 -               It calls 061122 to support both 06112 and 06113.
171578 -
171579 -
171580 -
171582 -  ..
1716 -
1717 -
1718 - Background
1719 -
171901 - On 010202 experience showed that Supersort under w2k does not support
171902 - computers that are faster than the computers we have used until now.
171903 - Supersort runs 13 times slower on a Pentium 4 1.4 GHz processor with
171904 - 400 MHz bus, high performance, PC800 RDRAM memory, and 7200 RPM 46 GB
171905 - hard disk, than it does on either a Pentium 800 MHz or 650 MHz
171906 - processor with 100 MHz bus, slower memory, and slower hard disks.
171907 - ref SDS 43 QL5K
171909 -  ..
171910 - On 010207 notified Microsoft that w2k was not performing correctly
171911 - with high performance hardware. ref SDS 47 4F8J  On 010209 Microsoft
171912 - failed to address this issue. ref SDS 48 JF2G  On 010214 notified
171913 - Microsoft to address performance issue. ref SDS 52 DD5F
171915 -  ..
171916 - On 010210 inquired to find vendor that supports Supersort. ref SDS 49
171917 - XX7G
171919 -  ..
171920 - On 010216 inquired about OTS to correct the problem. ref SDS 53 0001
171922 -  ..
171923 - On 010222 ordered Supersort. ref SDS 55 CR4O
171925 -  ..
171926 - Work today indicates OTS solves the problem.  Configured on c13, SDS
171927 - report operations are now considerably faster than using the slower
171928 - computers configured with Supersort. ref SDS 0 KX5M
171929 -
171931 -  ..
1720 -
1721 -
1722 - Testing
1723 -
172301 - We now have two basic report systems.
172302 -
172303 - It is not necessary to specify a field length, because the system
172304 - now automatically determines this factor.
172306 -  ..
172307 - Reports can be specified for a single user, multiple users, a group,
172308 - or everyone.
172309 -
172310 -          SDS Records                                    06112
172311 -
172312 -            Subjects - setup by 044011, 06112 profile 47 = 12
172313 -
172314 -               Subject at various levels for various Users
172315 -
172316 -                  Change specification by clicking on spec.
172318 -                   ..
172319 -                  Change specification by clicking on Subject menu
172321 -                ..
172322 -               Subject and function
172324 -                ..
172325 -               Subject or another subject
172326 -
172327 -                  Options for subjects are "replace" or append, with
172328 -                  an "or" selection command.
172329 -
172330 -                  Report screens are created initially by F1 Alt F9 in
172331 -                  an SDS record on a Control Field subject sub-field.
172333 -                   ..
172334 -                  Once opened, SI can be opend to "append" another
172335 -                  subject in a secondary selection spec by double
172336 -                  clicking on the subject description.  This creates a
172337 -                  secondary subject spec beginning in column 36 of the
172338 -                  report screen.  Alternatively, user can double
172339 -                  click, or press Enter, with cursor within 10 spaces
172340 -                  in front of subject description in Subject Index,
172341 -                  and this will replace both secondary and primary
172342 -                  spec with a new primary subject spec in column 36.
172344 -                ..
172345 -               Subject and Contacts
172346 -
172347 -                  This is set up for specifying a secondary spec using
172348 -                  the Contact menu, F5, but not yet for processing by
172349 -                  061122.  It is rarely used, but might be useful.
172350 -
172351 -                  Having the spec process available makes the subject
172352 -                  report screen compatible with Doc Log.
172354 -             ..
172355 -            Functions - setup by 044011, 06112 profile 47 = 12
172356 -
172357 -               Functions only at one level.
172358 -
172359 -                  Change specification by clicking on spec.
172360 -
172361 -                  Change specification by clicking on Function menu
172363 -                ..
172364 -               Function and subject
172366 -                ..
172367 -               Function or another function
172369 -             ..
172370 -            Files - setup by 044011, 06112 profile 47 = 11
172371 -
172372 -               Finds SDS records where a file is entered in
172373 -               References, indicating work related to the file
172374 -               occurred that day.
172376 -             ..
172377 -            Contacts
172378 -
172379 -              1.  Report where contact applies to an SDS record.
172380 -
172381 -              2.  Report where contact applies to a control field
172382 -                  subject in an SDS record.
172384 -                   ..
172385 -              3.  Organizations
172386 -
172387 -                  a.  As entities
172388 -
172389 -                  b.  Individuals in organizations.
172391 -                   ..
172392 -              4.  Individuals
172394 -             ..
172395 -            Actions Items
172396 -
172397 -               Automatic last 90 days, setup by 0612, profile 47 = 12
172398 -
172399 -               By subject, function, 06112, 044011 profile 47 = 12
172400 -
172402 -           ..
172403 -          Documents                                      06113
172404 -
172405 -            SDS Records
172406 -            Correspondence
172407 -            Publications
172408 -            Subjects
172409 -            Contacts
172410 -            Pending Response
172411 -
172412 -
172413 -
172415 -  ..
1725 -
1726 -
1727 - Progress
1728 -
172801 - Opt Tech Sort Conversion from Supersort Commands
172802 -
172803 - Need help rendering this Supersort spec in Opt Tech Sort....
172804 -
172805 -     i 360 cr
172806 -     no-r
172807 -     s e:\sd\08\00000\06\00001
172808 -     o c:\09\1Y001 k-out
172809 -     work f
172810 -     no-o
172811 -     se (fi 1 6 bt "990106","991231" or fi 1 6 bt "000101","010205") &
172812 -     and fi 75 88 ="03 00050 01 02" &
172813 -      and fi 15 19 = "00101"
172814 -     k=1 19 220 225 23 24
172815 -     go
172817 -  ..
172818 - Paige assisted in converting above Supersort spec to Opt Tech Sort
172819 - commands, where.....
172820 -
172821 -     o = otsort.exe
172822 -
172823 -     o e:\sd\08\00000\06\00001 c:\09\1Y001 112
172824 -
172825 - ....and where 112 is a control file that has....
172826 -
172827 -     s(1,18,c,a,220,5,c,a,23,1,c,a)
172828 -     in((1,6,c,ge,"990106",and,1,6,c,le,"991231"),
172829 -     or,(1,6,c,ge,"000101",and,1,6,c,le,"010205"),
172830 -     and,75,14,c,eq,"03 00050 01 02",and,15,5,c,eq,"00101")
172831 -
172833 -  ..
172834 - Opt Tech Sort Solves Performance Problem Experienced with Supersort
172835 -
172836 - The new command string using Opt Tech Sort shown above produces 452
172837 - output records, the same as Supersort above, but in 1 second instead
172838 - of 13 seconds.
172839 -
172841 -     ..
172842 -    no-o  Not Needed?????
172843 -    -----------------------------
172844 -    This spec ran successfully without the no-o param required by
172845 -    Supersort, reported on 910321. ref SDS 2 5R9O
172846 -
172848 -     ..
172849 -    no-r  Not Needed?????
172850 -    --------------------------------
172851 -    This spec ran successfully without the no-r param required by
172852 -    Supersort to avoid stopping processing because it does not find a
172853 -    specified record in a file, as reported on 920907. ref SDS 6 G3EY
172854 -
172855 - This seems therefore to solve the performance problem reported on
172856 - 010202. ref SDS 43 QL5K
172857 -
172858 -
172859 -
172860 -
172861 -
172862 -
1729 -

SUBJECTS
Subject, 06112
Opt Tech Sort, 010222
DOS Main Call to Select Records
DOS Prompt Commands Begins with Opsort Changed to "o"
Input Output Control, Specified as 3 Separate Files

2207 -
220801 -  ..
220802 - 06112   Subject, File and Contact Reports
220803 -
220804 - Follow up ref SDS 54 CY5W.
220805 -
220806 - Line 50, ref OF 8 TQ6K, changed primary selection processor from....
220808 -  ..
220809 - The DOS call in 06112 has used the following Supersort command
220810 - for the past 15 years.....
220812 -            ..
220813 -    DoS /c s i 360 cr;no-r;s d:\sd\08\UUUUU\TT\YY\__;o 1Y___ k-out;no-o;cf 1z >nul:
220814 -           ---------------                           --      ----- ---- --
220815 -
220817 -  ..
220818 - Today, this is changed to commands for running OTS in DOS specified in
220819 - chapter 3. ref OF 19 IB4F
220821 -            ..
220822 -           +- command calling Opt Tech Sort
220823 -           |                          +- Output filename
220824 -           |                          |
220825 -           |                          |     Control statement file
220826 -           | Input filename           |
220827 -           | ----------------------- ----- --
220828 -    DoSe/c o d:\sd\08\UUUUU\TT\YY\__ 1Y___ 1z >nul:
220829 -
220831 -  ..
220832 - Changed Medit for accessing DOS prompt from "dos" to use "dose" and so
220833 - hopefully will not run out of memory as often.
220834 -
220835 -     [On 010328 changed 06116 for HTML Internet data base to use same
220836 -     front end processing created today for 06112. ref SDS 61 WX5G
220837 -
220839 -  ..
220840 - OTS has a much simpler, streamlined method of specifying the selection
220841 - process, as shown in chapter 3 of the ots manual. ref OF 19 3R6O
220843 -                        ..
220844 -                     o input output control
220845 -                       ----- ------ -------
220847 -  ..
220848 - OTS does not need following stuff used in Supersort.....
220849 -
220850 -            s i 360 cr;no;
220851 -
220852 -            s input filename
220853 -
220854 -            o command to introduce the output file,
220856 -             ..
220857 -            k-out is done differently.
220859 -                ..
220860 -               There is a kout command in ots, ref OF 19 SR5G, however
220861 -               experimentation showed that outrec command, ref OF 19
220862 -               DW8L, with a crlf parameter, ref OF 19 2X6H, works
220863 -               closer to Supersort k-out.
220864 -
220865 -
220866 -
220867 -
220868 -
2209 -

SUBJECTS
Subject, 06112
061122 Selection Command File, Configure
Commands Can Be in Any Order
OUTRec - special output record format
INclude/OMit - criteria for record selection

2807 -
280801 -  ..
280802 - 061122  Selection Conrol Statement
280803 -
280804 - Follow up ref SDS 54 425F.
280805 -
280806 - Retain process reported recently on 010221 to fix y2k problem, and
280807 - modify to use OTS rather than Supersort commands.
280809 -  ..
280810 - Op Tech Sort (OTS) can be configured to replace Supersort (s.exe)
280811 - using guidance in the product manual....
280812 -
280813 -                    h: 00 20 ot.doc
280814 -
280815 - ...stored as reported on 010227. ref SDS 57 J38O
280817 -  ..
280818 - For convenience connecting the work to the manual, a text version was
280819 - created...
280820 -
280821 -                    h: 00 20 manual
280823 -  ..
280824 - OTS calls the command file a control statement, which we can create
280825 - with 061122, per below. ref SDS 0 437O  Chapter 6 in the OTS manual
280826 - explains control statement commands. ref OF 19 NY9M
280828 -  ..
280829 - Commands in the control statement file can be in any order.
280830 - ref OF 19 H15F
280832 -  ..
280833 - Commands for control statements are enclosed by parentheses, and
280834 - parameters for commands are joined by commas that look like this....
280835 -
280836 -      outrec(1,24,crlf)
280837 -      in(1,6,c,ge,"010131",and,1,6,c,le,"010302",
280838 -      and,75,17,c,eq,"03 00050 01 CKEGC")
280839 -      s(1,19,c,a,23,2,c,a)
280841 -  ..
280842 - ....where,
280843 -
280844 -      outrec
280845 -
280846 -          Comparable to k-out in Supersort.
280848 -           ..
280849 -          Tells OTS to output only columns from 1 for a length of 24
280850 -          columns, and put a carriage return line feed at the end of
280851 -          each line, and the output is stacked vertically to facilicate
280852 -          sequencial processing, see more below. ref SDS 0 437O
280854 -       ..
280855 -      in for "include"
280856 -
280857 -          Comparable to se for select in Supersort.
280858 -
280859 -          Tells ots to select from the input file on records that meet
280860 -          the criteria in parentheses, see more below. ref SDS 0 JP4F
280862 -           ..
280863 -          30 is maximum length of this field, so if a subject is longer
280864 -          than 30 characters, then need to break up the command string
280865 -          into multiple pieces. ref OF 19 Y66J and ref OF 19 TH3I
280867 -       ..
280868 -      s
280869 -
280870 -          Combines both sort and key, s, k, in Supersort.
280871 -
280872 -          Tells OTS to sort the output based on certain keys, see more
280873 -          below. ref SDS 0 ER3K
280874 -
280876 -      ..
280877 -     Outrec replaces K-out to Capture Pointers in 1Y
280878 -
280879 -     Op Tech Sort uses "outrec" to specify format of output file,
280880 -     explained in the manual. ref OF 19 DW8L
280881 -
280882 -     Line 50, ref OF 9 VY5K, in 061122
280883 -
280884 -        ...is now the first entry in the control statement file.
280885 -        ref OF 19 DW8L
280886 -
280888 -                      ..
280889 -                     outrec(1,24,crlf)
280891 -      ..
280892 -     This is needed to hold the structure of the 1y output file.  It
280893 -     replaces k-out in Supersort.  OTS has keyout command, but it does
280894 -     not work well.
280896 -      ..
280897 -     There is no particular reason to put it first.  The orginal code
280898 -     was organized in a way that made it easier to create this command
280899 -     first.  It has no variables, so that might be a good reason to
280900 -     put it first, then do the variables.
280901 -
280903 -      ..
280904 -     Include Replaces Select and Supports Exclude
280905 -     Exclude Accomplished with NE Param for Include
280906 -
280907 -     Line 50, ref OF 9 VY5K, this is second entry after outrec, and it
280908 -     accomplishes the heart of the report process that selects SDS
280909 -     records for a particilar period on partular subjects.
280910 -
280911 -     Selection routine to specify subjects is below. ref SDS 0 K85M
280913 -      ..
280914 -     Looks lik this....
280915 -
280916 -                start date              end date
280917 -
280918 -          in(1,6,c,ge,"010131",and,1,6,c,le,"010302",
280919 -          and,75,17,c,eq,"03 00050 01 CKEGC")
280920 -                      --
280922 -      ..
280923 -     To exclude lines can change the above command to.....
280924 -
280925 -          in(1,6,c,ge,"010131",and,1,6,c,le,"010302",
280926 -          and,75,17,c,ne,"03 00050 01 CKEGC")
280927 -                      --
280928 -
280929 -     ...would exclude "03 00050 01 CKEGC from column 75 for 17 columns
280930 -     simply by changing "eq" to "ne" in the above specification.
280931 -
280932 -         [On 031114 applied to method to subject index macro file
280933 -         03501. ref SDS 64 NB8M
280935 -     ..
280936 -    start pos and length of
280937 -    subject spec
280938 -                              subject spec
280939 -
280941 -      ..
280942 -     Include is in chapter 6 of the OTS manual. ref OF 19 H49G
280944 -      ..
280945 -     Key difference is that OTS does not have a between (bt) command
280946 -     that is available in Supersort for the se command.  So need a
280947 -     little extra coding.
280949 -      ..
280950 -     OTS commands are separated by commas.
280952 -      ..
280953 -     Fields are identified by start position and length, rather than
280954 -     start and end columns.
280956 -      ..
280957 -     Maximum length of an include selction field is 30. ref OF 19 Y66J
280958 -     A length of greater than 30 will therefore require making another
280959 -     line, otherwise will get an error message #207. ref OF 19 TH3I
280960 -
280962 -      ..
280963 -     Line 120, ref OF 9 VJ3N, -label docS about 70 lines below.
280964 -
280965 -         For some reason OTS control file command "ne" is not excluding
280966 -         lines with a space in column 270.
280967 -
280968 -         Changed algorithm to select between 0 9 and A - z.
280969 -
280970 -
280971 -
280972 -
2810 -

SUBJECTS
Sort - specifies field(s) to sort on
DUPOut - eliminates duplicate records(keeps one)
Sort Subject Index and Exclude Redundant Lines for Chained Segments

3105 -
310601 -      ..
310602 -     Sort Replaces Key
310603 -
310604 -     Line 230, ref OF 9 YA4H, -label SvE2 3rd entry is the sort
310605 -     command, which combines the functions of sort and keys in
310606 -     Supersort.
310608 -      ..
310609 -     Looks like this....
310610 -
310611 -                 s(1,19,c,a,23,2,c,a)
310613 -      ..
310614 -     Duplicate keys deleted looks like this....
310615 -
310616 -                 s(1,19,c,a,23,2,c,a) dupout(1,19)
310617 -
310619 -          ..
310620 -         [On 031114 more samples for select and exclude. ref SDS 64
310621 -         NB8M
310623 -      ..
310624 -     Sort is in chapter 6 of the OTS manual. ref OF 19 GQ4N
310626 -      ..
310627 -     Note similar syntax to include, but has an additional parameter to
310628 -     identify the order of "a" for ascend, or "d" for descending.
310629 -
310630 -
310631 -
310632 -
310633 -
310634 -
310635 -
3107 -

SUBJECTS
Doc Log Report, Primary Selection
Publications
061122 Selection Command File, Configure
Opt Tech Sort, 010222
Selecting

3607 -
360801 -  ..
360802 - Primary Selection Spec for Doc Log
360803 -
360804 - Line 120, ref OF 9 VJ3N, OTS in 061122 failed to select
360805 - Publication records using control file with following string....
360806 -
360807 -
360808 -       and,35,11,c,eq,"02 14 01 60",and,270,1,c,ne," ")
360809 -
360810 -
360811 - ....got it to work by using a command that affirmatively selects
360812 - something in column 270, rather than select on not equal to a space.
360813 -
360815 -      ..
360816 -     and,35,11,c,eq,"02 14 01 60",and,((270,1,c,ge,"0",and,
360817 -     270,1,c,le,"9"),
360818 -     or,(270,1,c,ge,"A",and,270,1,c,le,"z")))
360819 -
360821 -  ..
360822 - Wound up changing this to.....
360823 -
360824 -
360825 -   and,35,11,c,eq,"02 14 01 60",and,270,1,c,ge,"0",and,270,1,c,le,"z"),
360826 -
360827 -      [...below had same problem creating global poniters for
360828 -      publications. ref SDS 0 5P6J
360829 -
360830 -
360832 -  ..
360833 - 061122 Optech Sort Command File Common Code for 06112 06113
360834 - Selection Loop for Subjects and Other Reports
360835 -
360836 - This implements planning for common method to build command files for
360837 - subjects and document reports, per planning above. ref SDS 0 PSPR
360838 -
360839 - Line 230, ref OF 9 V54I, -label subspc in 061122
360840 -
360841 -      Call selection subroutine.
360843 -  ..
360844 - Line 530, ref OF 9 254H, -label lspc
360845 -
360846 -      Selection subroutine for all reports.
360848 -       ..
360849 -      It has two passes, primary and secondary.
360851 -       ..
360852 -      It will look for spec on line 14 of report screen on first pass,
360853 -      and then do another pass to look for a secondary spec, created by
360854 -      044011, ref OF 3 I76L, also, explained on 010221. ref SDS 54 V73K
360856 -       ..
360857 -      If secondary specs are for the same selection type, i.e., both
360858 -      are subjects or both are functions, then change primary selection
360859 -      from....
360860 -
360861 -                        and,75,
360862 -
360863 -      ....to....
360865 -                         ..
360866 -                        and,(75,
360867 -
360868 -
360869 -      ....determined by reading the selection field.
360870 -      ..
360871 -      Length of this field can be at most 30 positions, per OTS
360872 -      manual, above. ref SDS 0 T39G
360874 -       ..
360875 -      We need to check the length, and create a second selection spec
360876 -      for anything that exceeds 30.
360878 -  ..
360879 - Line 570, ref OF 9 1302, -label rdSpc
360880 -
360881 -      Read selection specification in report screen q1, and store in
360882 -      global 131.  Return to 1yz3 OTS control file.
360884 -  ..
360885 - Line 620, ref OF 9 556M, -label 06112op
360886 -
360887 -      In 1yz3 add a line to the control statement by calling....
360888 -
360889 -                         -gosub newLn
360890 -
360891 -   Jump to explanation below for evaluating length of selection string.
360892 -   ref SDS 0 LE6G
360894 -  ..
360895 - Line 280, ref OF 9 EU9K, -label ns2ndry
360896 -
360897 -    Location of User ID in report screens is 12 36 for subjects and
360898 -    references.  It is 12 32 in doc log reports, because the location
360899 -    was changed on 010221 to accomodate full year date fields.
360900 -    ref SDS 54 6O5M
360902 -  ..
360903 - Line 610, ref OF 9 H46I, -label 06112op
360904 -
360905 -        If we have subject and subject, or function and function
360906 -        (which there is no particular need to do), then use "or," if
360907 -        we have subject and function, or subject and contact, then use
360908 -        "and."
360910 -     ..
360911 -    Configure secondary selection spec for and "and" or an "or"
360912 -    operation.
360913 -
360914 -        See if the prior selection type is the same as the
360915 -        current selection type, because in that case this is an
360916 -        "or" statement that needs parentheses added; and if it
360917 -        is a different type, then use "and" and no parentheses.
360919 -  ..
360920 - Line 740, ref OF 9 HK5K, -label and1 about 80 lines below.
360921 -
360922 -    Doc Log 2nd selection spec for Contacts has 2 fields, which have
360923 -    to be set using an "or" parm and within parentheses.
360924 -
360926 -  ..
360927 - Line 800, ref OF 9 465H, -label ss1
360928 -
360929 -    Subroutine that creates selection specs with "or" statement.
360930 -
360931 -    Obtain length of the string from global 131.
360932 -
360933 -    Contact orgz and contact name fields must be separated by 2
360934 -    spaces, so for organizations, have to move the contact person name
360935 -    field over one position.
360936 -
360937 -        We could enter the thing in the report screen with two spaces,
360938 -        but then would need special code to distinguish getting this
360939 -        field from others that are separated only by a single space.
360940 -        So this seems like the easier place to add the extra space.
360941 -        ..
360942 -        Need to distinguish Individual contacts, because that
360943 -        field does not have a second element, i.e., there is a single
360944 -        string, but it is identified by an "I" at the beginning.
360946 -  ..
360947 - Line 840, ref OF 9 IM5F, -label ss1 about 40 lines below
360948 -
360949 -    If 131 is greater than 30, set
360950 -
360951 -
360952 -
360953 -
360954 -
360955 -
360956 -
360957 -
360958 -
3610 -

SUBJECTS
Doc Log Report, Primary Selection
Publications
061122 Selection Routines
Subjects, Contacts
Subjects & Contacts

4007 -
400801 -  ..
400802 - Secondary Selection Op for Doc Log  - 06113
400803 -
400804 - Line 940, ref OF 10 6G5F, -label cntxs in 06113 simplifying process of
400805 - configuring secondary selection criteria.  It is basically subjects.
400806 - contacts, or both.
400807 -
400808 -     Previously, returned an error message if User selected Contacts
400809 -     without first setting a subject.  This was needed because the code
400810 -     created a Supersort selection spec, prior to run time, and it had
400811 -     to be correct in order to be adjusted for the next field, or at
400812 -     least that seemed like the easiest way to code things at the time.
400814 -      ..
400815 -     Today, however, the process is changed.  Selection is being done
400816 -     by OTS, and the specs will be created as needed.  This makes it
400817 -     possible to avoid a lot of error messages, because OTS will be
400818 -     configured by 06112 to run what what ever it finds in the report
400819 -     screen, similar to subjects functions.
400821 -  ..
400822 - Line 1380, ref OF 10 DS7N, -label cROut in 06113, has been running on
400823 - counter 266, but today will change to work similar to Subject report,
400824 - since now processing will be done with a common system in 061122.
400826 -  ..
400827 - We therefore eliminate for now error messages that were previously
400828 - needed because the status was off screen, and so could not tell.  Now
400829 - Users can run a default report getting all records, if they click on a
400830 - secondary feature, but don't complete it.
400832 -  ..
400833 - Line 230, ref OF 9 6V3H, -label nxLin in 061122.
400835 -  ..
400836 - After entering primary spec, 061122 will return to q1 06113 doc log
400837 - report screen and see if there is a subject at location, 14 36, and
400838 - if not, look for Contact spec on column 46.  If either, then will
400839 - process as a secondary spec.
400840 - ..
400841 - If there is a subject, then will post to selection spec, then
400842 - return to doc log and look for tertiary contact spec.
400844 -  ..
400845 - Line 560, ref OF 9 GQ7M, -label lspc
400846 -
400847 -     If there is a subject entered in q1, 06113, in col 36, which
400848 -     means the counter will be 35, because we do setcur, then adjust
400849 -     the current selection spec line to select param 2 in col 64 in
400850 -     case a User used multi-spec entry for original doc entry in SDS
400851 -     record.  This applies multi-subjects for documents.
400852 -
400853 -
400854 -
400855 -
400856 -
4009 -

SUBJECTS
Doc Log Reports, Secondary Selection Criteria, All Records

4103 -
410401 -     ..
410402 -    06113   Counter 266 Sets Criteria Secondary Selection
410403 -    061122  Secondary Doc Log Selection Criteria
410404 -    Secondary Doc Log Selection Criteria
410405 -
410406 -    Revised format for 06113 by placing secondary selection specs on
410407 -    the visible screen.  Until today, selection criteria has been
410408 -    entered off screen, directly in a control spec for transfer to a
410409 -    Control File with cut and paste.  Now we are going to do this
410410 -    similar to 06112, by entering the string in the report screen, then
410411 -    when the report is run, read the string and enter it in a control
410412 -    file, rather than use cut and paste.
410414 -     ..
410415 -    Macro 061122 will get a flag from global 266 set in 06113 and
410416 -    modify the primary selection spec, as previously accomplished by
410417 -    06113.
410419 -     ..
410420 -    This method makes it possible to do contact and file search reports
410421 -    in the same macro that does subjects, so 06111 can be eliminated,
410422 -    because 06112 will be configured do all of this work.
410423 -
410425 -     ..
410426 -    Line 690, ref OF 10 5S4J, -label xg88 in 06113
410427 -
410428 -       266 is control for secondary selection, it has three options...
410429 -
410430 -              266 = 0 or 4  default report, all records.
410431 -              266 = 1       subjects
410432 -          *   266 = 2       subjects and contacts
410433 -              266 = 3       contacts only
410434 -
410436 -        ..
410437 -       Will eliminate this option as no longer needed, explained as
410438 -       follows....
410439 -
410441 -     ..
410442 -    Line 980, ref OF 10 T89J, -label oRgnly
410443 -
410444 -       Contacts field setup for secondary selection criteria.
410445 -
410446 -       Eliminate modifying Supersort selection spec, since this is
410447 -       changed today to use 061122. ref OF 10 4410
410449 -        ..
410450 -       Eliminate....
410451 -
410452 -
410453 -               Subject           Organization
410454 -
410455 -
410456 -          ...process.  Instead, options will simply scroll between
410457 -          Subjects and Contacts.  If a Contact is appended to a
410458 -          Contact, then that will be posted.
410460 -        ..
410461 -       Eliminate Subject Index and Contact F8 message below the
410462 -       fields.
410463 -
410464 -          This will be accomplished by placing a message off to the
410465 -          right of Subject or Contact, saying to "click here, or F8 to
410466 -          open SI or Contacts menu.
410468 -     ..
410469 -    Line 2400, ref OF 10 393K, -label no11
410470 -
410471 -       This is where Primary and Secondary selection choices are
410472 -       scrolled by clicking.
410473 -
410474 -       Secondary op calls -label cSn_Sel about line 690, ref OF 10 VX8O,
410475 -       which is discussed a few lines above just below -label 5S4J.
410476 -       ref SDS 0 4X5O
410477 -
410478 -
410479 -
410480 -
4105 -

SUBJECTS
Doc Log Reports, Secondary Selection Criteria, Contacts
Subjects - F8

4304 -
430501 -     ..
430502 -    Contacts Selection Spec Loaded from Contact Summary
430503 -
430504 -    Line 1020, ref OF 10 RE7I, -label lcOn in 06113
430505 -
430506 -       Contact spec loaded to Doc Log report screen from Contact
430507 -       Summary.
430509 -        ..
430510 -       Change this today.
430512 -        ..
430513 -       Now modify Enter and double clicking to load a contact from the
430514 -       Contact Summary for the name of the person listed in the
430515 -       Summary, by using code that loads a record to an SDS record
430516 -       from a Contact Summary.
430518 -            ..
430519 -           Personal records identified by 128 = 2 in Contact Summary
430520 -           get spec directly from Summary, because only the name is
430521 -           needed.
430523 -            ..
430524 -           Organization records need contact name field ID from
430525 -           Contact record, so open Contact Record.
430527 -            ..
430528 -           Enter in Contact Summary is macro 1305 in 000009 set by
430529 -           047041. ref OF 6 8352
430530 -
430531 -               This is configured to run until it finds the contact
430532 -               name line in the Contact record, and then exit.  At
430533 -               that point, 06113 calls macro 1307 to load the contact
430534 -               spec into 06113.
430536 -            ..
430537 -           ecur 31 returns to 06113 Q1 report screen and runs code in
430538 -           next section that calls Enter in Contact Record to run macro
430539 -           1304 in 000009, per below. ref SDS 0 U34F
430540 -
430542 -     ..
430543 -    Contacts Selection Spec Loaded from Contact Record
430544 -
430545 -    Line 1040, ref OF 10 HT6G, -label conNam in 06113 enters a contact
430546 -    specification from Contact Record processed by 000009, per below,
430547 -    ref SDS 0 U34F, that calls macro 1807 in 000009 to call this
430548 -    address in 06113.
430549 -
430550 -       Changed this code.
430552 -        ..
430553 -       It no longer needs to track counter 266.  It will load a spec
430554 -       in position 14 46.  It first checks position 14 36 to see if a
430555 -       subject spec has been entered.  If so, it puts the contact spec
430556 -       two lines below.
430557 -       ..
430558 -       Then enters description on secondary line in position 19
430559 -       13, unless a subject has been entered, then it puts the stuff on
430560 -       the line below.
430562 -     ..
430563 -    Line 1360, ref OF 10 DS7N, -label cROut 06113
430564 -
430565 -       This location lists report options for secondary flag 266....
430566 -        ..
430567 -       -if @266 = 0 -goto contA.... ref OF 10 2080
430568 -       -if @266 > 0 -if @266 < 4 -gosub tsubj... ref OF 10 MZ8O
430569 -       -if @266 = 1 -if @1 > 32 -goto contA.... ref OF 10 2080
430570 -       -if @266 = 2 -if @1 > 32 -if @2 > 32 -goto contA
430571 -       -if @266 = 3 -if @1 > 32 -goto contA
430572 -       -if @266 = 4 -goto contA
430573 -       ..
430574 -       Today, we are trying to disconnect this feature that posts
430575 -       an error message if User has not entered a subject or contact,
430576 -       since the User can see this now from the screen, because 044012
430577 -       is changed today to place the spec on the screen.
430579 -        ..
430580 -       We are going to have the program read the screen, instead of
430581 -       rely on 266 counter flags.  If there is a subject and or a
430582 -       contact, then it will be processed.
430584 -     ..
430585 -    Line 1430, ref OF 10 PE4K, -label contA in 06113 40 lines below,
430586 -    save globals....
430587 -
430588 -        167
430589 -        266
430591 -     ..
430592 -    Line 1470, ref OF 10 WS6K, -label contA in 06113 70 lines below.
430593 -
430594 -        Call 061122 to process selection specification.
430595 -
430596 -        Selection has been established by User input.
430597 -
430598 -        This step needs global 266 criteria.
430599 -
430600 -              266 = 0   default report, all records.
430602 -               ..
430603 -              266 = 1   subjects
430605 -               ..
430606 -              266 = 2   subjects and contacts
430608 -               ..
430609 -              266 = 3   contacts only
430610 -
430612 -     ..
430613 -    Line 1500, ref OF 10 5Z7G, -label proc
430614 -
430615 -        Selection control file is now prepared by 061122, which is
430616 -        closed.
430617 -
430618 -        Macro 1205 in 000007 executes control file created by 061122,
430619 -        as a subset of macro 120 called by subject report processor,
430620 -        06112.
430621 -
430623 -     ..
430624 -    Subjects begin in the reference archive files at col 270.
430625 -
430626 -
430627 -
4307 -

SUBJECTS
Subjects

4403 -
440401 -     ..
440402 -    044012  Subjects Posted to 06113 Doc Log Secondary Spec
440403 -
440404 -    Follow up ref SDS 54 327K. ref SDS 54 GU3L
440405 -
440406 -    Revised the way this works.
440407 -
440408 -    Considered eliminating this macro file to save the overhead, but
440409 -    decided to keep it separate, since it is rarely used, because
440410 -    documents can be looked up based on subjects using the SDS subject
440411 -    report.
440413 -     ..
440414 -    Line 60, ref OF 4 6T6L, change method of entering a subject so it
440415 -    uses char read 1182 instead of cut and paste, per work on 044011,
440416 -    on 010221. ref SDS 54 GU3L
440417 -
440418 -       Markcur 27 added to return to get description after entering the
440419 -       subject code.
440421 -        ..
440422 -       Setgbl 200 1000 for some reason. ref OF 4 3036
440423 -
440424 -
440425 -
4405 -

SUBJECTS
Contacts, 06111

4603 -
460401 -  ..
460402 - 000009  Change Method of Transferring Contact to Target Records
460403 -
460404 - Line 220, ref OF 15 JH6F, -label rPtzz
460405 -
460406 -    Code is using cut and paste to get the User's name from Contact
460407 -    record.
460409 -     ..
460410 -    Change this today to use macro 1182.
460412 -  ..
460413 - Line 310, ref OF 15 156G, -label orgRep
460414 -
460415 -    Flag setglb 135 9991 = contact name included with spec
460416 -
460417 -    Flag setglb 135 9992 = contact name not included with spec
460418 -
460419 -    setgbl 128 = 2 = personal contacts
460420 -    setgbl 128 = 4 = organizational contacts
460422 -  ..
460423 - Line 320, ref OF 15 9G3K, -label orgRep under macro 1807
460424 -
460425 -    Call macro 06113 #52, which runs -label conNam, ref OF 10 HT6G, per
460426 -    above, ref SDS 0 538H, to complete loading a selection parameter
460427 -    in to a report screen.
460428 -
460430 -  ..
460431 - Line 1920, ref OF 15 GP7T, -label aM_sDs_c
460432 -
460433 -    Code at this point has positioned cursor in Contact record on the
460434 -    line with the name of the person listed in the Contact Summary for
460435 -    organiztions, processing returns to 06113, per above. ref SDS 0
460436 -    X15J
460437 -    ..
460438 -    Next call macro 1807, which is the Enter key in a Contact
460439 -    record. It loads the current line into 06113 Q1 and is completed by
460440 -    code in Q1 #52, per above. ref SDS 0 U34F and for 06113, way above.
460441 -    ref SDS 0 538H
460442 -
460443 -
460444 -
460445 -
460446 -
460447 -
460448 -
4605 -

SUBJECTS
Received Pending Response
Publications
Specification Screen
Primary Selection Criteria
Types of Reports
Cross-ref Docs
Doc ID

5409 -
541001 -  ..
541002 - 06113   Doc Log Reports Opt Tech Sort Replace Supersort
541003 - 06113   Primary Selection Criteria for Doc Log Reports
541004 -
541005 - Line 50, ref OF 10 7S6M, make change similar to 06112, per above,
541006 - ref SDS 0 GTY4, to DOS call for selection spec, from....
541008 -            ..
541009 -    DoS /c s i 360 cr;no-r;s d:\sd\08\UUUUU\TT\YY\__;o 1Y___;cf 1z1
541010 -           ---------------                           --      --
541012 -  ..
541013 - Today, this is changed to commands for running OTS in DOS specified in
541014 - chapter 3. ref OF 19 IB4F
541015 -
541016 -
541017 -           +- command for otsort.exe
541018 -           |                          +- Output filename
541019 -            Input filename      |
541020 -           |   |                      |     Control statement file
541021 -           | ----------------------- ----- ---
541022 -    DoSe/c o d:\sd\08\UUUUU\TT\YY\__ 1Y___ 1z1 >nul:
541023 -
541024 -
541025 -
541026 - Line 1470, ref OF 10 WS6K, -label contA 60 lines below, trying to call
541027 - macro 061122 for configuring date selection op.  This provides
541028 - standardized code, and reduces maintenance.
541030 -  ..
541031 - Changed to control file 1z instead of 1z1, which 06113 has been
541032 - calling.
541034 -  ..
541035 - Primary Control Field flags are listed in 06113 under -label wrpt,
541036 - about line 210. ref OF 10 AQ6N
541037 -
541038 -
541039 -     167 = 0 & 6 Received Pending Response
541040 -
541041 -     167 = 1     Received all
541043 -      ..
541044 -     167 = 2     Issued Pending Response
541046 -      ..
541047 -     167 = 3     Issued all
541049 -      ..
541050 -     167 = 4     Issued and Received
541052 -      ..
541053 -     167 = 5     Publications
541054 -
541056 -  ..
541057 - Line 1520, ref OF 10 8M9K, -label proc
541058 -
541059 -    Revise method of processing output 1y0** files for selecting fields
541060 -    for doc log reports.
541061 -
541062 -    Changed to DOS copy command called in a batch file created each
541063 -    pass for merging all of the initial output files, 1y0*, into 1yout
541064 -    for ots to sorted using key specs based on User entered criteria
541065 -    for the order of the report. ref OF 10 0588
541067 -     ..
541068 -    1yout is then rearranged with another ots operation to place fields
541069 -    in original SDS pointer files into positions for Doc Log report,
541070 -    and placed in a file 1yin. ref OF 10 6R7N
541072 -     ..
541073 -    Publications have one additional sort to eliminate duplicate keys.
541074 -    ref OF 10 ZR9G
541075 -
541077 -  ..
541078 - Line 1580, ref OF 10 0588, -label proc about 80 lines below.
541079 -
541080 -    Sort specs for different report types based on couner 167, per
541081 -    above. ref SDS 0 4O6G
541082 -
541084 -  ..
541085 - Line 1630, ref OF 10 HI4O, -label proc
541087 -     ..
541088 -    Control file to re-arrange fields using merge and outrec, per
541089 -    explanation above. ref SDS 0 XR5J
541091 -     ..
541092 -    Merge is explained in the manual. ref OF 19 4Q5L
541093 -
541095 -  ..
541096 - Line 1990, ref OF 10 KG6D, -label scOpe
541097 -
541098 -    Format spec using OTS command, "outr", explained in the manual.
541099 -    ref OF 19 DW8L
541100 -
541102 -  ..
541103 -
541104 -    Consolidated report formats....
541105 -
541106 -       We are not using fields in far right margin for....
541107 -
541108 -                Response Doc
541109 -                Type   Date
541110 -
541112 -  ..
541113 -
541114 -       Cross Reference Field Abandoned
541115 -
541116 -       The original idea was to cross-reference to show documents that
541117 -       respond to other documents.  This has proven a littel
541118 -       judgemental, and time consuming, and so has not been used.
541120 -        ..
541121 -       On 981101 eliminated code that uses this feature. ref SDS 31
541122 -       5437 and ref SDS 31 4E4F, but did not revise the report headers.
541124 -        ..
541125 -       I have been keeping it around because conceptually it is
541126 -       helpful, but have not been able to develop a practical
541127 -       implementation.  For one thing it is labor intensive, because it
541128 -       requires more time to consider what responds to what, and even
541129 -       though the tools make it fast and easy to create cross
541130 -       references, doing this all day takes valuable time, relative to
541131 -       the fact that SDS records themselves show a much broader and
541132 -       more accurate history of cross references, including responses.
541134 -        ..
541135 -       Therefore, I abandoned this field today.
541137 -        ..
541138 -       This makes it possible to expand the From and To fields that
541139 -       currently are truncated.  We could also show dates in 4 year
541140 -       strings instead of 2 year.  One difficulty with this is that a 4
541141 -       year string requires separating the field, as was done for
541142 -       report screens, 06112 and 06113.  This would make the
541143 -       presentation less amenable to pattern recognition by observing a
541144 -       wide range of related fields.
541146 -        ..
541147 -       Instead for now, will expand Contact fields.
541148 -
541149 -
541150 -
5412 -

SUBJECTS
Doc Log Report Fields, Doc ID

5503 -
550401 -        ..
550402 -       Doc ID field reduced and placed in right margin because it not
550403 -       important to have the entire length.
550404 -
550405 -
550406 -
5505 -

SUBJECTS
Report Types
Assemble & Format Code
Date and Number

6405 -
640601 -  ..
640602 - 06113  Doc Log Report Format Revised
640603 -
640604 - Line 1980, ref OF 10 YR9G, -label scOpe
640605 -
640606 -    Standard selection criteria for all reports that enters date and
640607 -    document ID.
640609 -     ..
640610 -    Doc date and number fields are the same for all reports.
640612 -     ..
640613 -    Considered providing 5 extra spaces for the Doc number in order to
640614 -    append a User ID which is 5 positions.  This improves the chances
640615 -    of creating unique documents even though someone else selects the
640616 -    same doc number for a particular date.
640618 -     ..
640619 -    Decided not to make this change to the output report for now,
640620 -    because if we do not append the 5 characters, then the report
640621 -    appears out of balance, similar to what has been the case up until
640622 -    now with the Doc ID field, that was 15 characters and was rarely
640623 -    used.
640625 -     ..
640626 -    Expanded the record selection of Doc # field, so people can append
640627 -    letters to differentiate documents, e.g., a, d, ac, dg, etc, see
640628 -    References for Other Files on 990713. ref SDS 35 0001
640629 -
640631 -  ..
640632 - Line 1990, ref OF 10 JT4O, -label scOpe
640633 -
640634 -    Report types evaluated based on counter 167, per above. ref SDS 0
640635 -    4O6G
640636 -
640638 -  ..
640639 - Line 2020, ref OF 10 4M3I, -label scOpe
640640 -
640641 -    Specify selection for Docs Issued or Received, all activity.
640642 -
640644 -  ..
640645 - Line 2030, ref OF 10 PN4H, -label aSDSs
640646 -
640647 -    Standard blank string to pad selection so the off screen fields
640648 -    for identifying the doc and sds records are positioned correctly
640649 -    to facilitate opening original sources.
640650 -
640651 -
6407 -

SUBJECTS
Doc Spec Off Screen for Opening Original Document
SDS Spec Off Screen for Opening Original Document

6604 -
660501 -  ..
660502 - 06113  Doc and SDS File Specs Positioned to Open Original Sources
660503 -
660504 - Line 2050, ref OF 10 7F6G, -label faSDSs
660505 -
660506 -    Developed standard configuration for off screen file specs in
660507 -    column 117 to open the original document by double clicking or
660508 -    pressing enter on the Doc Date/# fields.
660510 -     ..
660511 -    Similarly SDS spec is in column 171, which is the same location
660512 -    used in SDS records, and so provides a common design standard
660514 -     ..
660515 -    These two fields are separated by spaces, and the exact
660516 -    configuration is the same for all reports, including publications.
660517 -    ..
660518 -    Standard end for all reports enters....
660519 -
660520 -        1.  Doc ID standard string, so the doc can be opened from the
660521 -            report.
660522 -
660523 -        2.  25 spaces to position SDS records for convenient
660524 -            processing
660526 -             ..
660527 -        3.  SDS Record string in standard format, so record where doc
660528 -            was created or received, can be opened from Doc Log.
660529 -  ..
660530 -
660531 -    Tried following format, but OTS crashes when a field is blank,
660532 -    which in some cases occurs.
660533 -            ..
660534 -        4.  Doc ID standard string, so the doc can be opened from
660535 -            the report.
660537 -             ..
660538 -        5.  From Contact, so contact record can be opened from the Doc
660539 -            Log report
660541 -             ..
660542 -            Experimenting showed today that if this field is blank,
660543 -            then OTS puts the next field on the next line in column 10
660544 -            or so, rather than simply putting the blanks out there.
660546 -             ..
660547 -            This may be occurring because if the file is saved with
660548 -            the field blank, then OTS doesn't know there is anything
660549 -            out there.
660551 -             ..
660552 -        6.  SDS Record string in standard format, so record where doc
660553 -            was created or received, can be opened from Doc Log.
660554 -            ..
660555 -        7.  To Contact, so this can also be opened.  It is the
660556 -            Respond field in reports for Documents issued pending
660557 -            response.
660558 -
660560 -  ..
660561 - Line 2080, ref OF 10 KS9M, -label pndgR
660562 -
660563 -    Stantard selection for Issued, Received Pending Response.
660564 -
660565 -
660566 -
660567 -
6606 -

SUBJECTS
Report Headers for Report Format

6703 -
670401 -  ..
670402 - 06113  Report Headers Modified to New Layout
670403 -
670404 - Line 2120, ref OF 10 S24G, -label pub01
670405 -
670406 -    Modified report headers to conform with new layout, per above.
670407 -    ref SDS 0 GY4D
670409 -     ..
670410 -    Main changes are extending organization fields, so the names can
670411 -    be more readily recognized.
670413 -     ..
670414 -    Moved Doc ID field to right of description for all activity
670415 -    reports.  This makes more of the description visible in the
670416 -    initial screen, without having to scroll the screen.
670417 -    ..
670418 -    Eliminated Description for publications, since the title is
670419 -    enough with the availabilty of the SDS records to amplify on the
670420 -    title, per above. ref SDS 0 RA8H
670421 -
670422 -
670423 -
670424 -
670425 -
670426 -
670427 -
670428 -
6705 -

SUBJECTS
25.bat Global Pointers Archive SDS Records
Summary pointers, 910304
25.bat Archive Pointers Using OTS for Sort, Select

7005 -
700601 -  ..
700602 - 25.bat  Global Pointers OTS Replaces Supersort.
700603 -
700604 - Follow up ref SDS 45 VW7H.
700605 -
700606 - On 010205 modified 25.bat by adding sort operation so global pointers
700607 - are in order to improve speed of reports that use the global pointer
700608 - files.
700610 -  ..
700611 - Today changed the code to replace Supersort with OTS because evidently
700612 - Supersort is slower on faster computers, reported above. ref SDS 0
700613 - M45I
700615 -  ..
700616 - 25.bat calls....
700617 -
700618 -
700619 -              c:\sd\01\e dirx c:\sd\03\0011
700620 -
700621 -
700622 - ....as shown. ref OF 12 C54J
700623 -
700625 -  ..
700626 - 0011  Select and Sort DocLog and Publication Pointers
700627 -
700628 - Line 130, ref OF 2 NH4I, -label lpaS
700629 -
700630 -    Replaced Supersort with OTS to select "R" and "I" records.
700631 -
700633 -  ..
700634 - Line 140, ref OF 2 5L5O, -label lpaS about 40 lines below
700635 -
700636 -    Replaced Supersort to select publications....
700637 -
700638 -
700639 -       or,(25,11,c,eq,"02 14 01 60",and,270,1,c,ne," "))
700640 -
700642 -     ..
700643 -    This gets publications with an entry in column 270, because that
700644 -    means it is the original entry, rather than a subsequent reference.
700646 -     ..
700647 -    Had same problem with this specification that occurred with 061122
700648 -    that does the report operation, per above. ref SDS 0 BQ4K For some
700649 -    reason OTS does not seem to support selecting records based on not
700650 -    encountering a blank.
700652 -     ..
700653 -    Actually, for a day or so, had another problem of having hit the
700654 -    wrong key and entered the start position as 25 instead of 35.
700655 -    Finally got following to work....
700657 -     ..
700658 -    Tried....
700659 -
700660 -       or,(35,11,c,eq,"02 14 01 60",and,270,1,c,ge,"0",
700661 -       and,270,1,c,le,"z"))/
700662 -
700663 -
700664 -
700665 -
700666 -
700667 -
700668 -
700669 -
700670 -
700671 -
7007 -
Distribution. . . . See "CONTACTS"