[Robelle-l] Warning: Not all sort fields were extracted
Catherine Litten
catherine.litten@valleypres.org
Wed, 16 Oct 2002 17:53:33 -0700
Just a quick little question on Suprtool - if you look at the following
piece of code you will see that I am sorting on PAT-ACCT-NBR and SERV-DATE
and I am extracting both of these fields but Suprtool gives me "Warning:
Not all sort fields were extracted" and "Sort information will not be
written to the output link-file" when I look at the subfile I am creating it
looks just fine and it is sorted just fine but I don't understand this
message, unless it means I have not extract all the fields I am selecting
this data on - what do you think?
BA DBCM1.DATA,5
>
Get CHARGES
>
Warning: Field is being redefined
>
set date cutoff 25
>
item TRAN-DATE,date,yymmdd
>
define SERV-DATE,1,4,double
>
item SERV-DATE,date,ccyymmdd
>
table ENC-TABLE,E-PAT-ACCT-NBR,file,RCS922A.VPHD
There are 15799 entries in ENC-TABLE
>
if $lookup(ENC-TABLE,E-PAT-ACCT-NBR) and &
>
SERV-ITEM-TYPE = "R"
>
ext PAT-ACCT-NBR
>
ext SERV-QTY
>
ext SERV-DEPT
>
ext SERV-DATE = $stddate(TRAN-DATE)
>
sort PAT-ACCT-NBR
>
sort SERV-DATE
>
output RCS922C.VPHD,temp,link
>
xeq
Warning: Not all sort fields were extracted
Sort information will not be written to the output link-file
Starting input phase.
5% In=920854 Delta-Min=1:27. Wall-Min=1:27.
Cpu-Sec=42.
*****************************
Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital
15107 Vanowen Street, Van Nuys, CA 91405 (818)782.6600 x 2140
catherine.litten@valleypres.org
********************************
The thoughts, comments, and opinions expressed herein are mine. They do not
reflect those of my employer, nor anyone else.
********************************
This E-mail is covered by the Electronic Communications Privacy Act, 18
U.S.C. §§ 2510-2521 and is legally privileged. This information is
confidential information and is intended only for the use of the individual
or entity named above. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received
this transmission in error, please notify the sender immediately by return
electronic transmission and then immediately delete this transmission.