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

SUBJECTS
Opt Tech Sort, 010222
Purchase
Sort/Select utility, 910306

1105 -
1105 -    ..
1106 - Summary/Objective
1107 -
110701 - Follow up ref SDS 49 0000, ref SDS 48 0000.
110702 -
110703 - In the late afternoon received DOS version of Opt Tech Sort program,
110704 - ref SDS 0 J38O, after solving delivery problems using email.
110705 -
110706 -     [On 010301 solved problem. ref SDS 50 0001
110707 -
110708 -
110710 -  ..
1108 -
1109 -
1110 - Progress
111101 -  ..
111102 - Opt Tech Program 3 MB, Too Big for Email
111103 -
111104 -
111105 - I talked to the ISP last night.  Our AT&T mail box has only 3 MB, so
111106 - this could have caused the problem, although it sounded like Paige was
111107 - only sending about 1.5 MB.
111109 -  ..
111110 - Sent a letter to Paige with link to this record showing following two
111111 - ideas that emerged from the discussion.......
111112 -
111113 -
111114 -    1.  Use the email address for pacbell....
111116 -                       ..
111117 -                      rodwelch@pacbell.net
111118 -
111119 -
111120 -        This account has 5 MB and we never use it, so it should be
111121 -        empty.
111123 -         ..
111124 -    2.  FTP the files to....
111125 -
111126 -            http://www.welchco.com/10
111127 -
111128 -            Host name:  ftp.welchco.com
111129 -
111130 -            Host type:  unix standard or automatic
111132 -             ..
111133 -            user ID:    welchco
111135 -             ..
111136 -            passsword:  poims
111137 -
111139 -  ..
111140 - Let's first try sending email, since that seems simplest.
111142 -  ..
111143 - In the early afternoon, Paige submitted the program again using
111144 - email.
111146 -  ..
111147 - Configured Netscape for Pac Bell, but got error message saying could
111148 - not retrieve.
111150 -  ..
111151 - In another record, Pac Bell assisted in setting up configuration, but
111152 - still could not receive the letter from Opt Tech Sort, with the new
111153 - program.
111155 -  ..
111156 - We had a compound problem.  The spelling of user ID for incoming
111157 - server was misspelled, and the characters in the Netscape configurtion
111158 - program are so small that the error was not apparent.
111160 -  ..
111161 - Later got a message saying we cannot download anything that is over 2
111162 - MB.  Since we have a 3.2 MB file.
111164 -  ..
111165 - As a result, I called Paige at Opt Tech Sort and asked her to send
111166 - our purchase of Opt Tech Sort in smaller sections.
111167 -
111168 -
111169 -
111171 -  ..
1112 -
1113 -
1114 - 1425 received letter
1115 -
111501 - Finally received the DOS version of opt tech sort and some
111502 - documentation.
111504 -    ..
111505 -   [On 010402 sent letter thanking OTS, and requesting rest of program.
111506 -   ref SDS 51 0001
111508 -  ..
111509 - Install on......
111510 -
111511 -
111512 -                             h: 00 20
111513 -
111515 -  ..
111516 - Files in config.nt needs to set to 40+, ref OF 3 XE8J
111518 -  ..
111520 -  ..
111521 - Need help rendering this Supersort spec in Opt Tech Sort....
111522 -
111523 -
111524 -     PRI 6
111525 -     i 360 cr
111526 -     no-r
111527 -     s e:\sd\08\00000\06\00001
111528 -     o c:\09\1Y001 k-out
111529 -     work f
111530 -     no-o
111531 -     se (fi 1 6 bt "990106","991231" or fi 1 6 bt "000101","010205") &
111532 -     and fi 75 88 ="03 00050 01 02" &
111533 -      and fi 15 19 = "00101"
111534 -     k=1 19 220 225 23 24
111535 -     go
111536 -
111538 -  ..
111539 - How to do above Supersort with opt tech sort, where the program name
111540 - is "ot"
111541 -
111542 -     ot
111543 -     e:\sd\08\00000\06\00001
111544 -     c:\09\1Y001
111545 -     /s(1,18,c,a, 220,5,c,a, 23,1,c,a   ?????
111546 -
111548 -  ..
111549 - Help on converting the following is also needed.......
111550 -
111551 -     se fi 1 6 bt "010129","010228" and fi 24 24="3" &
111552 -     and (((fi 62 62="I" or fi 62 62="R") and (fi 63 63="0" or fi 63 63="1") &
111553 -     and (fi 64 64=" " or fi 64 64=" ") and (fi 65 65=" " or fi 65 65=" ")))
111554 -     k 1 28;g
111555 -
111557 -    ..
111558 -   [Next day sent letter requesting guidance on how to complete this
111559 -   command file.
111561 -    ..
111562 -   [On 010301 got help from OTS, experimentation seems to show this
111563 -   solves prior problem. ref SDS 50 0001
111565 -    ..
111566 -   [On 010402 sent letter thanking OTS, and requesting rest of program.
111567 -   ref SDS 51 0001
111568 -
111570 -       ..
111571 -      Include and Omit Specification
111572 -
111573 -      The maximum length of the literal field in the Include/Omit
111574 -      parameter is 30 characters.   The maximum number of fields that
111575 -      can be used is 30. ref OF 1 Y66J
111576 -
111577 -           The maximum length of the literal field in the Include/Omit
111578 -           parameter is 30 characters.   The maximum number of fields
111579 -           that can be used is 30.
111581 -            ..
111582 -           Example: To select only those customers from Texas as
111583 -           designated by a 2 byte Character field in position 61, you
111584 -           could specify the following Include statement:
111585 -
111586 -             Include(61,2,C,EQ,"TX")
111588 -            ..
111589 -           Example: To OMit all customers from TeXas with a credit flag
111590 -           value of blank, you could specify the following OMit
111591 -           statement:
111592 -
111593 -             OM(61,2,C,EQ,"TX",AND,20,1,C,EQ," ")
111595 -            ..
111596 -           Example - Nested Conditions: To include customers from TeXas
111597 -           with a credit flag equal to blank or a credit flag equal to
111598 -           "X" you could use the following statement.
111599 -
111600 -             INC(61,2,C,EQ,"TX",AND,(20,1,C,EQ," ",OR,20,1,C,EQ,"X"))
111601 -
111603 -  ..
111604 - Instructions for starting ot from DOS and in a batch file are in
111605 - chapter 3. ref OF 1 IB4F
111606 -
111607 -      ot filename filename filename
111608 -
111609 - ...where
111610 -
111611 -      ot       =  Opt Tech Sort program
111613 -       ..
111614 -      filename =  input file, which can be multiple files by adding
111615 -                  a plus (+) between filenames
111617 -       ..
111618 -      filename =  output file
111620 -       ..
111621 -      filename =  control statements
111622 -
111624 -  ..
111625 - There is a general list of commands in Opt Tech Sort's manual.
111626 - ref OF 1 1Y3K
111628 -  ..
111629 - Sort command is on page 87. ref OF 1 GQ4N
111630 -
111631 -
111632 -      ot
111633 -
111634 -      Example: To select only those customers from TeXas as designated
111635 -      by a 2 byte Character field in position 61, you could specify the
111636 -      following Include statement:
111638 -         ..
111639 -        Include(61,2,C,EQ,"TX")
111641 -       ..
111642 -      OM(61,2,C,EQ,"TX",AND,20,1,C,EQ," "), ref OF 1 L53L
111644 -       ..
111645 -      Example - Nested Conditions: To include customers from TeXas with
111646 -      a credit flag equal to blank or a credit flag equal to "X" you
111647 -      could use the following statement. ref OF 1 744K
111648 -
111649 -        INC(61,2,C,EQ,"TX",AND,
111650 -           (20,1,C,EQ," ",OR,20,1,C,EQ,"X"))
111651 -
111652 -
111653 -
111654 -
111655 -
111656 -
111657 -
111658 -
111659 -
111660 -
111661 -
111662 -
111663 -
111664 -
111665 -