HP OpenVMS Systems Documentation

ÅúÁ¿×÷ÒµÊǶÀÁ¢ÓÚµ±Ç°¶Ô»°ÆÚ¶øÔËÐеijÌÐò»ò DCL ÃüÁî¹ý³Ì¡£Èç¹ûÒªÅÅÐò´óÎļþ£¬ÄÇô¿¼ÂÇ°Ñ Sort ²Ù×÷ÌύΪһ¸öÅúÁ¿×÷Òµ£¬ÒòΪÅÅÐò½«ÐèҪһЩʱ¼ä¡£ÓйØÅúÁ¿×÷ÒµºÍÃüÁî¹ý³ÌµÄÏêÇ飬Çë²ÎÔÄ µÚ 16 Õ ¡¢µÚ 13 ÕÂºÍµÚ 14 Õ¡£

9.4.1 ÃüÁî¹ý³Ì

ÔÚÃüÁî¹ý³ÌÖÐÖ¸¶¨ SORT ÃüÁ¾ÍÏóÔÚÆÁÄ»ÉÏдÈëËü¡£Èç¹ûĬÈÏĿ¼²»°üº¬ÒªÅÅÐòµÄÎļþ£¬¾ÍÃ÷È·µØÔÚÃüÁî¹ý³ÌÖÐÉèÖÃĬÈÏĿ¼£¬»òÕßÔÚÃüÁîÎļþ˵Ã÷ÖаüÀ¨Õâ¸öĿ¼¡£

ÒÔÏÂÀý×ÓÌá½» DCL ÃüÁî¹ý³Ì SORTJOB.COM Ϊһ¸öÅúÁ¿×÷Òµ¡£ÔÚÃüÁîÐкó£¬Õ¹Ê¾ÃüÁî¹ý³ÌµÄÎı¾:

$ SUBMIT SORTJOB

! SORTJOB.COM
!
$ SET DEFAULT [USER.PER]   ! Set default to location of input
$ SORT/KEY=(POSITION:10,SIZE:15) EMPLOYEE.LST BYNAME.LST
$ TYPE BYNAME.LST
$ EXIT

ÔÚÅúÁ¿×÷ÒµÖпÉÒÔ°üÀ¨ÊäÈë¼Ç¼£¬°ÑËüÃÇ·ÅÔÚ SORT ÃüÁîÖ®ºó£¬Ã¿ÐÐÒ»¸ö¼Ç¼¡£¸ö±ðÅÅÐò¼Ç¼¿ÉÒÔ±ÈÒ»Ðг¤¡£

ÈçͬʹÓÃÖÕ¶ËÊäÈë¼Ç¼£¬Ö¸¶¨ÊäÈëÎļþ²ÎÊýΪ SYS$INPUT¡£Ê¹Óà /FORMAT ÏÞ¶¨´ÊÖ¸¶¨ÒÔ×Ö½ÚΪµ¥Î»µÄ¼Ç¼´óСºÍÒÔ¿éΪµ¥Î»µÄ½üËÆÎļþ´óС¡£´óÔ¼ 6 ¸ö 80 ¸ö×Ö·ûÐеÈÓÚÒ»¿é¡£

ÒÔÏÂÀý×Óʾ·¶ÔÚÃüÁî¹ý³ÌÖаüÀ¨ÊäÈë¼Ç¼:

$ SUBMIT SORTJOB

! SORTJOB.COM
!
$ SET DEFAULT [USER.PER]
$ SORT/KEY=(POSITION:10,SIZE:15) -
SYS$INPUT-
/FORMAT=(RECORD_SIZE:24,FILE_SIZE:10) -
BYNAME.LST
$ DECK
BST 7828 MCMAHON JANE
ADM 7933 ROSENBERG HARRY
COM 8102 KNIGHT MARTHA
ANS 8042 BENTLEY PETER
BIO 7951 LOWELL FRANK
$ EOD

MERGE ÃüÁî°Ñ¶à´ï 10 ¸ö (¸ßÐÔÄÜ Sort/Merge ¹«ÓóÌÐòÖ§³Ö¶à´ï 12 ¸ö) ÅÅÐòµÄÎļþ×éºÏ³ÉÒ»¸öÅÅÐòµÄÊä³öÎļþ¡£¿ÉÒԺϲ¢¾ßÓÐͬÑù¸ñʽºÍͨ¹ýͬÑù¼ü×Ö¶ÎÅÅÐòµÄÊäÈëÎļþ¡£

°´ÕÕĬÈÏ£¬Merge ¼ì²éÊäÈëÎļþÖмǼµÄ˳Ðò£¬ÒÔÈ·ÐÅËüÃÇÊÇÒÑÅÅÐòµÄ¡£Èç¹û²»Òª Merge ¼ì²é´ÎÐò£¬¾ÍÖ¸¶¨ /NOCHECK_SEQUENCE ÏÞ¶¨´Ê¡£Èç¹ûÖ¸¶¨ /CHECK_SEQUENCE ÏÞ¶¨´Ê¶øÒ»¸ö¼Ç¼´ÎÐòµßµ¹ (ÀýÈ磬Èç¹ûûÓÐÅÅÐòÒ»¸öÊäÈëÎļþ)£¬Merge ¾Í±¨¸æÒÔϳö´í:

%SORT-W-BAD_ORDER, merge input is out of order

¡¡

ʹÓà MERGE ÃüÁîʱ¿ÉÒÔ´øÓë SORT ÃüÁîͬÑùµÄÏÞ¶¨´Ê£¬µ«ÓÐÁ½¸öÀýÍâ:

• ²»ÄÜΪ Merge ²Ù×÷Ö¸¶¨Ò»¸ö½ø³Ì (/PROCESS)¡£
• /CHECK_SEQUENCE ÏÞ¶¨´ÊÖ»ÓÃÓںϲ¢²Ù×÷¡£

ÔÚÒÔÏÂÀý×ÓÖУ¬Îļþ BYNAME1.LST ºÍ BYNAME2.LST ÒѾ­°´¹ÍÔ±ÃûÉýÐòÅÅÐò¡£Õ¹Ê¾µÄÃüÁËüÃǺϲ¢:

$ MERGE BYNAME1.LST,BYNAME2.LST BYNAME3.LST

Êä³öÎļþ BYNAME3.LST °üº¬À´×ÔÕâÁ½¸öÎļþ (¼´£¬BYNAME1.LST ºÍ BYNAME2.LST) µÄËùÓмǼ£¬ÈçÏÂͼËùʾ:

ÒªºÏ²¢Ê¹ÓÃÌض¨¼üÅÅÐòµÄÎļþ£¬±ØÐëÔÚ MERGE ÃüÁîÐÐÉÏ¶Ô /KEY ÏÞ¶¨´ÊÖ¸¶¨Í¬ÑùµÄ¼ü¡£

Èç¹û²»Ö¸¶¨Ò»¸ö¼ü£¬Merge ʹÓà 9.2 ½ÚÃèÊöµÄĬÈϼü¡£

ÔÚÒÔÏÂÀý×ÓÖУ¬Îļþ BILLING1.LST ºÍ BILLING4.LST °´ÕʺÅÅÅÐò (/KEY=POSITION:5,SIZE:4,DECIMAL)¡£Òª°ÑÕâЩÎļþºÏ²¢µ½Êä³öÎļþ MAILING.LST£¬ÊäÈëÒÔÏÂÃüÁîÐÐ:

$ MERGE/KEY=(POSITION:5,SIZE:4,DECIMAL) -
_$ BILLING1.LST,BILLING4.LST MAILING.LST

ºÏ²¢½á¹ûÈçÏÂËùʾ:

Èç¹ûÏëÒªÒÔÅÅÐòµÄ´ÎÐòºÏ²¢Îļþ£¬ÄÇôָ¶¨ /NOCHECK_SEQUENCE ÏÞ¶¨´Ê¿ÉÒÔ×èֹ˳Ðò¼ì²é¡£

9.5.2 ͬÑùµÄ¼ü×Ö¶Î

Èçͬ Sort ²Ù×÷£¬µ±ÊäÈëÎļþ°üº¬Í¬¼üµÄ×ֶμǼʱ£¬Merge ²»±Øά³Ö¼Ç¼ÔÚÊäÈëÎļþÖеÄͬÑù´ÎÐò¡£ÒªÎ¬³Öͬ¼ü¼Ç¼µÄÊäÈë´ÎÐò£¬ÔÚ MERGE ÃüÁîÐÐÉÏÖ¸¶¨ /STABLE ÏÞ¶¨´Ê¡£Ö»Òª±£Áôͬ¼ü¼Ç¼µÄÒ»¸ö¸±±¾£¬Ö¸¶¨ /NODUPLICATES ÏÞ¶¨´Ê¡£

9.6 ´ÓÖÕ¶ËÊäÈë¼Ç¼

ÏëÒªÅÅÐò»òºÏ²¢µÄ¼Ç¼²»Ò»¶¨À´×ÔÒ»¸öÎļþ¡£µ±ÊäÈë SORT »ò MERGE ÃüÁîʱ£¬¿ÉÒÔÖ±½Ó´ÓÖÕ¶ËÊäÈë¼Ç¼¡£ÒÔϱí¸ñÃèÊöÕâ¸ö¹ý³Ì:

ÒÔÏÂÀý×Óʾ·¶Ò»¸ö Sort ²Ù×÷£¬ËüÅÅÐòµÄÊäÈë¼Ç¼ֱ½Ó´ÓÖÕ¶ËÊäÈë:

$ SORT/KEY=(POSITION:8,SIZE:15) -
_$ SYS$INPUT/FORMAT=(RECORD_SIZE:24,FILE_SIZE:10) BYNAME.LST
BST 7828 MCMAHON JANE
ADM 7933 ROSENBERG HARRY
COM 8102 KNIGHT MARTHA
ANS 8042 BENTLEY PETER
BIO 7951 LOWELL FRANK

Õâ´®ÃüÁÁ¢°üº¬ÅÅÐò¼Ç¼µÄÊä³öÎļþ BYNAME.LST¡£

9.7 ʹÓà Sort/Merge ˵Ã÷Îļþ

Sort/Merge ÔÊÐíÄúÔÚ˵Ã÷ÎļþÖÐά»¤ÅÅÐò¶¨Ò壬²¢Ö¸¶¨¸ü¸´ÔÓµÄÅÅÐò×¼Ôò¡£(¸ßÐÔÄÜ Sort/Merge ¹«ÓóÌÐò²»Ö§³Ö˵Ã÷Îļþ¡£¶ÔÕâ¸öÌØÐÔµÄʵÏÖÁô´ý½«À´µÄ OpenVMS Alpha ·¢Ðа汾¡£) ¿ÉÒÔʹÓÃÈκαê×¼±à¼­³ÌÐò£¬»ò DCL CREATE ÃüÁÁ¢Ò»¸ö˵Ã÷Îļþ¡£

Sort/Merge ˵Ã÷ÎļþÔÊÐíÄú:

• Ñ¡Ôñ Sort/Merge ²Ù×÷°üÀ¨µÄ¼Ç¼
• ÖØиñʽ»¯Êä³öÎļþµÄ¼Ç¼
• ʹÓÃÌõ¼þ¼ü»òÊý¾Ý
• Ö¸¶¨¶à¸ö¼Ç¼¸ñʽ
• ½¨Á¢»òÐÞ¸ÄÒ»¸ö±È½Ï˳Ðò
• ÖØÐÂÖ¸Åɹ¤×÷Îļþ
• ´æ´¢Æµ·±Ê¹ÓÃµÄ Sort/Merge ²Ù×÷

ÔÚÍê³É˵Ã÷Îļþºó£¬Ê¹Óà /SPECIFICATION ÏÞ¶¨´ÊÖ¸¶¨ÎļþÃû¡£ËµÃ÷ÎļþµÄĬÈÏÎļþÀàÐÍÊÇ .SRT¡£

˵Ã÷ÎļþµÄÿ¸öÃüÁîÓ¦¸ÃÒÔÒ»¸öб¸Ü (/) ¿ªÊ¼¡£Èç¹ûÒ»¸öÃüÁî¿çÔ½Ò»ÐÐÒÔÉÏ£¬²»ÐèÒªÁ¬Ðø×Ö·û¡£

ÔÚÃüÁîÐÐÖÐÖ¸¶¨µÄÈκΠDCL ÃüÁîÏÞ¶¨´ÊÈ¡´úÔÚ˵Ã÷ÎļþÖеÄÏàÓ¦ÌõÄ¿¡£ÀýÈ磬Èç¹ûÔÚ DCL ÃüÁîÐÐÖÐÖ¸¶¨ /KEY ÏÞ¶¨´Ê£¬Sort/Merge ¾ÍºöÂÔÔÚ˵Ã÷ÎļþÖÐµÄ /KEY ×Ӿ䡣

Ò»°ã£¬ÔÚ˵Ã÷ÎļþÖÐÖ¸¶¨ÏÞ¶¨´Êʱ£¬¶Ô´ÎÐòûÓÐÌØÊâµÄÒªÇó¡£È»¶ø£¬ÔÚÒÔÏÂÇé¿öÏ´ÎÐòÊÇÖØÒªµÄ:

• °´Ò»¸öÒÔÉϼü×Ö¶ÎÅÅÐò£¬Èç¹ûûÓÐÖ¸¶¨ NUMBER:n ¼üÔªËØ
• ÃèÊöÊä³ö¸ñʽ
• ¶¨Òå¶à¸ö¼Ç¼ÀàÐÍ

¶Ô /COLLATING_SEQUENCE ÏÞ¶¨´ÊÖ¸¶¨ FOLD¡¢MODIFICATION ºÍ IGNORE ¹Ø¼ü×Öʱ£¬Ó¦¸ÃÔÚÈκΠFOLD ×Ó¾ä֮ǰָ¶¨ËùÓÐ MODIFICATION ºÍ IGNORE ×Ӿ䡣ÓÐ¹Ø /COLLATING_SEQUENCE ÏÞ¶¨´ÊµÄÏêÇ飬Çë²ÎÔÄ 9.9.3 ½Ú¡£

ÔÚ˵Ã÷ÎļþÖпÉÒÔ°üÀ¨×¢ÊÍ£¬Ã¿¸ö×¢ÊÍÐÐÓÉÒ»¸ö¸Ð̾ºÅ (!) ¿ªÊ¼¡£Óë DCL ÃüÁîÐв»Í¬£¬ËµÃ÷Îļþ²»ÐèÒªÁ¬×ֺŠ(-) ÐøÐС£

Àý×Ó

1. ÕâÊÇÒ»¸ö˵Ã÷ÎļþµÄÀý×Ó£¬¿ÉÒÔÓÃÀ´°´ÉýÐòÅÅÐò¸ºÊýºÍÕýÊýÊý¾Ý:

   ! °´ÉýÐòÅÅÐò¸ºÊýºÍÕýÊýÊý¾Ý ! µÄ˵Ã÷Îļþ ! /FIELD=(NAME=SIGN,POS:1,SIZ:1) (1) /FIELD=(NAME=AMT,POS:2,SIZ:4) (2) /CONDITION=(NAME=CHECK1, (3) TEST=(SIGN EQ "-")) /CONDITION=(NAME=CHECK2, (4) TEST=(SIGN EQ " ")) /INCLUDE=(CONDITION=CHECK1, (5) KEY=(AMT,DESCENDING), DATA=SIGN, DATA=AMT) /INCLUDE=(CONDITION=CHECK2, (6) KEY=(AMT,ASCENDING), DATA=SIGN, DATA=AMT)

   
   ¼ì²é˵Ã÷Îļþʱ£¬×¢ÒâÒÔϼ¸µã:
   1. Õâ¸öÃüÁîÐж¨ÒåÒ»¸ö¿ªÊ¼ÓڼǼµÄµÚ 1 ×Ö½Ú²¢ÇÒÊÇ 1 ×Ö½Ú³¤µÄ×ֶΡ£ËüΪÕâ¸ö×Ö¶ÎÖ¸ÅÉÃû³Æ SIGN¡£
   2. Õâ¸öÃüÁîÐж¨ÒåÒ»¸ö¿ªÊ¼ÓڼǼµÄµÚ 2 ×Ö½Ú²¢ÇÒÊÇ 4 ×Ö½Ú³¤µÄ×ֶΡ£ËüΪÕâ¸ö×Ö¶ÎÖ¸ÅÉÃû³Æ AMT¡£
   3. ÕâÊÇÒ»¸öÌõ¼þÓï¾ä¡£Èç¹ûÔÚ SIGN ×Ö½ÚÖÐÓÐÒ»¸ö¸ººÅ ( - )£¬Âú×ã CHECK1 Ìõ¼þ¡£
   4. ÕâÊÇ Ò»¸öÌõ¼þÓï¾ä¡£Èç¹û SIGN ×Ö½ÚÊÇ¿Õ°×£¬Âú×ã CHECK2 Ìõ¼þ¡£
   5. Èç¹ûÂú×ãÌõ¼þ CHECK1£¬¼Ç¼°´½µÐòÅÅÐò¡£
   6. Èç¹ûÂú×ãÌõ¼þ CHECK2£¬Ôò¼Ç¼°´ÉýÐòÅÅÐò¡£
   
   ͼ 9-8 չʾÔÚÊäÈëÎļþ BALANCES.LIS ÉÏʹÓÃ˵Ã÷ÎļþµÄ½á¹û¡£

   ͼ 9-8 ʹÓÃ˵Ã÷ÎļþµÄÊä³ö

   ---

   

2. ¡¡

   /FIELD=(NAME=RECORD_TYPE,POS:1,SIZ:1) ! ¼Ç¼ÀàÐÍ£¬1 ×Ö½Ú /FIELD=(NAME=PRICE,POS:2,SIZ:8) ! ¼Û¸ñ£¬Á½¸öÎļþ /FIELD=(NAME=TAXES,POS:10,SIZ:5) ! Ë°£¬Á½¸öÎļþ /FIELD=(NAME=STYLE_A,POS:15,SIZ:10) ! Ñùʽ£¬¸ñʽ»¯ A Îļþ /FIELD=(NAME=STYLE_B,POS:20,SIZ:10) ! Ñùʽ£¬¸ñʽ»¯ B Îļþ /FIELD=(NAME=ZIP_A,POS:25,SIZ:5) ! ÓÊÕþ±àÂ룬¸ñʽ»¯ A Îļþ /FIELD=(NAME=ZIP_B,POS:15,SIZ:5) ! ÓÊÕþ±àÂ룬¸ñʽ»¯ B Îļþ /CONDITION=(NAME=FORMAT_A, ! Ìõ¼þ²âÊÔ£¬¸ñʽ»¯ A TEST=(RECORD_TYPE EQ "A")) /CONDITION=(NAME=FORMAT_B, ! Ìõ¼þ²âÊÔ£¬¸ñʽ»¯ B TEST=(RECORD_TYPE EQ "B")) /INCLUDE=(CONDITION=FORMAT_A, ! Êä³ö¸ñʽ£¬ÀàÐÍ A KEY=ZIP_A, DATA=PRICE, DATA=TAXES, DATA=STYLE_A, DATA=ZIP_A) /INCLUDE=(CONDITION=FORMAT_B, ! Êä³ö¸ñʽ£¬ÀàÐÍ B KEY=ZIP_B, DATA=PRICE, DATA=TAXES, DATA=STYLE_B, DATA=ZIP_B)

   
   ÔÚÕâ¸öÀý×ÓÖУ¬¸ù¾Ý˵Ã÷ÎļþÖ¸¶¨µÄÖ¸ÁÅÅÐòÀ´×ÔÒ»¸öµØ²ú´úÀíµÄÁ½¸ö·Ö¹«Ë¾µÄÁ½¸öÊäÈëÎļþ¡£ÔÚµÚÒ»¸öÎļþÖеÚÒ»¸öλÖÿªÊ¼ÓÚ A µÄ¼Ç¼ÓÐÕâ¸ö¸ñʽ:

   |A|PRICE|TAXES|STYLE|ZIP| 1 2 10 15 25

   
   ÔÚµÚ¶þ¸öÎļþÖеÚÒ»¸öλÖÿªÊ¼ÓÚ B µÄ¼Ç¼ÓÐλÖõ÷תµÄÑùʽºÍÓÊÕþ±àÂë×ֶΣ¬ÈçÏÂËùʾ:

   |B|PRICE|TAXES|ZIP|STYLE| 1 2 10 15 20

   
   Òª°´¼Ç¼ A µÄ¸ñʽÒÔÓÊÕþ±àÂë×Ö¶ÎÅÅÐòÕâÁ½¸öÎļþ£¬Ê×ÏÈÓà /FIELD ÏÞ¶¨´Ê¶¨ÒåÕâÁ½¸ö¼Ç¼µÄ×ֶΡ£È»ºó£¬Óà /CONDITION ÏÞ¶¨´ÊÖ¸¶¨Ò»¸ö²âÊÔÇø±ðÕâÁ½Àà¼Ç¼¡£×îºó£¬/INCLUDE ÏÞ¶¨´ÊÔÚÊä³öʱ°ÑÀàÐÍ B µÄ¼Ç¼¸ñʽ¸ü¸ÄΪÀàÐÍ A µÄ¼Ç¼¸ñʽ¡£
   ×¢Ò⣬Èç¹ûÔÚ /INCLUDE ÏÞ¶¨´ÊÖÐÖ¸¶¨¼ü»òÊý¾Ý×ֶΣ¬±ØÐëÔÚ /INCLUDE ÏÞ¶¨´ÊÖÐΪ Sort ²Ù×÷Ã÷È·µØÖ¸¶¨ËùÓмüºÍÊý¾Ý×ֶΡ£
   ҲҪעÒ⣬ÅÅÐòʱ»áÊ¡ÂÔ²»ÊÇÀàÐÍ A Ò²²»ÊÇÀàÐÍ B µÄ¼Ç¼¡£

3. ¡¡

   /COLLATING_SEQUENCE=(SEQUENCE= ("AN","EB","AR","PR","AY","UN","UL", "UG","EP","CT","OV","EC","0"-"9"), MODIFICATION=("'"="19"), FOLD)

   
   Õâ¸ö /COLLATING_SEQUENCE ÏÞ¶¨´ÊÖ¸¶¨Ò»¸öÓû§×Ô¶¨Òå˳Ðò£¬°´Äê´ú˳ÐòΪÿ¸öÔ¸ø³öÒ»¸öΨһֵ¡£ÀýÈ磬Èç¹ûÏëÒª¸ù¾ÝÈÕÆÚÅÅÐòÎļþ SEMINAR.DAT£¬ÄÇôÎļþ SEMINAR.DAT ½«±»ÉèÖÃÈçÏÂ:

   16 NOV 1983 Communication Skills 05 APR 1984 Coping with Alcoholism 11 Jan '84 How to Be Assertive 12 OCT 1983 Improving Productivity 15 MAR 1984 Living with Your Teenager 08 FEB 1984 Single Parenting 07 Dec '83 Stress --- Causes and Cures 14 SEP 1983 Time Management

   
   Ö÷¼üÊÇÄê×ֶΣ»¸¨Öú¼üÊÇÔÂ×ֶΡ£ÒòΪÔÂ×ֶβ»ÊÇÊý×Ö£¬¶øÏëÒª°´Äê´ú˳ÐòÅÅÐòÔ·ݣ¬Òò´Ë±ØÐ붨Òå×Ô¼ºµÄ±È½Ï˳Ðò¡£¿ÉÒÔÕâÑù×ö£¬¼´°´Äê´ú˳ÐòÅÅÐòÿ¸öÔ·ݵĺóÁ½¸ö×Öĸ£¬¼´ÎªÃ¿¸öÔ·ݸø³öΨһ¼üÖµ¡£
   MODIFICATION ÈÎÑ¡ÏîÖ¸¶¨Ê¡ÂԺŠ(') µÈͬÓÚ 19£¬´Ó¶øÔÊÐí±È½Ï '83 ºÍ 1984¡£FOLD ÈÎÑ¡ÏîÖ¸¶¨´óд×ÖĸºÍСд×ÖĸÊÓΪÏàͬ¡£
   Õâ¸ö Sort ²Ù×÷µÄÊä³öÈçÏÂËùʾ:

   14 SEP 1983 Time Management 12 OCT 1983 Improving Productivity 16 NOV 1983 Communication Skills 07 Dec '83 Stress --- Causes and Cures 11 Jan '84 How to Be Assertive 08 FEB 1984 Single Parenting 15 MAR 1984 Living with Your Teenager 05 APR 1984 Coping with Alcoholism

   
   Óйؽ¨Á¢Óû§×Ô¶¨Òå±È½Ï˳ÐòµÄÆäËûÀý×Ó£¬Çë²ÎÔÄ 9.3 ½Ú¡£

4. ¡¡

   /FIELD=(NAME=AGENT,POSITION:20,SIZE:15) /CONDITION=(NAME=AGENCY, TEST=(AGENT EQ "Real-T Trust" OR AGENT EQ "Realty Trust")) /DATA=(IF AGENCY THEN "Realty Trust" ELSE AGENT)

   
   ÔÚÕâ¸öÀý×ÓÖУ¬Á½¸öµØ²úÎļþ±»ÅÅÐò¡£Ò»¸öÎļþ³ÆÒ»¸ö´úÀíΪ Real-T Trust£»ÁíÒ»¸öÎļþ³Æͬһ´úÀíΪ Realty Trust¡£/CONDITION ºÍ /DATA ÏÞ¶¨´Êָʾ Sort °ÑÔÚÅÅÐòµÄÊä³öÎļþÖÐµÄ AGENT ×Ö¶ÎÁÐΪ Realty Trust¡£

5. ¡¡

   /FIELD=(NAME=ZIP,POSITION:60,SIZE:6) /CONDITION=(NAME=LOCATION, TEST=(ZIP EQ "01863")) /KEY=(IF LOCATION THEN 1 ELSE 2)

   
   ÔÚÕâ¸öÀý×ÓÖУ¬ËùÓдøÓÊÕþ±àÂë 01863 µÄ¼Ç¼½«³öÏÖÔÚÅÅÐòµÄÊä³öÎļþµÄ¿ªÊ¼¡£Ìõ¼þ²âÊÔÊÇÔÚÓà /FIELD ÏÞ¶¨´Ê¶¨ÒåµÄ ZIP ×ֶΣ»Ìõ¼þ±»ÃüÃûΪ LOCATION¡£ÔÚÕâ¸ö /KEY ÏÞ¶¨´ÊµÄÖµ 1 ºÍ 2 ±íʾÄÇЩÂú×ãºÍ²»Âú×ãÌõ¼þ¼Ç¼µÄÏà¶Ô´ÎÐò¡£

6. ¡¡

   /FIELD=(NAME=ZIP,POSITION:60,SIZE:6) /CONDITION=(NAME=LOCATION, TEST=(ZIP EQ "01863")) /DATA=(IF LOCATION THEN "NORTH CHELMSFORD" ELSE "Outside district")

   
   ÔÚÕâ¸öÀý×ÓÖУ¬/CONDITION ÏÞ¶¨´Ê²âÊÔ 01863 ÓÊÕþ±àÂë¡£/DATA ÏÞ¶¨´ÊÖ¸¶¨³ÇÕò×Ö¶ÎÃû³Æ½«Ìí¼Óµ½Êä³ö¼Ç¼£¬ÊÓ²âÊÔ½á¹û¶ø¶¨¡£

7. ¡¡

   /FIELD=(NAME=FFLOAT,POS:1,SIZ:0,F_FLOATING) /CONDITION=(NAME=CFFLOAT,TEST=(FFLOAT GE 100)) /OMIT=(CONDITION=CFFLOAT)

   
   ÔÚÕâ¸öÀý×ÓÖУ¬Õâ¸öÊý 100 ±»ÈÏΪÊÇÒ»¸ö F_FLOATING Êý¾ÝÀàÐÍ£¬ÒòΪÔÚ /FIELD ÏÞ¶¨´ÊÖÐ×ֶΠFFLOAT ±»¶¨ÒåΪ F_FLOATING£¬¡£

8. ¡¡

   /FIELD=(NAME=AGENT,POSITION:1,SIZE:5) /FIELD=(NAME=ZIP,POSITION:6,SIZE:3) /FIELD=(NAME=STYLE,POSITION:10,SIZE:5) /FIELD=(NAME=CONDITION,POSITION:16,SIZE:9) /FIELD=(NAME=PRICE,POSITION:26,SIZE:5) /FIELD=(NAME=TAXES,POSITION:32,SIZE:5) /DATA=PRICE /DATA=" " /DATA=TAXES /DATA=" " /DATA=STYLE /DATA=" " /DATA=ZIP /DATA=" " /DATA=AGENT

   
   /FIELD ÏÞ¶¨´Ê¶¨ÒåÊäÈëÎļþ¼Ç¼µÄ×Ö¶ÎÓÐÒÔϸñʽ:

   AGENT ZIP STYLE CONDITION PRICE TAXES

   
   /DATA ÏÞ¶¨´Ê£¬Ê¹Óà /FIELD ÏÞ¶¨´Ê¶¨ÒåµÄ field-names£¬ÖØиñʽ»¯¼Ç¼À´½¨Á¢¾ßÓÐÒÔϸñʽµÄÊä³ö¼Ç¼:

   PRICE TAXES STYLE ZIP AGENT

¸ù¾ÝÅÅÐò»·¾³£¬Óм¸ÖÖ·½·¨¿ÉÒÔÌá¸ß Sort »ò Merge ²Ù×÷µÄЧÂÊ¡£ÔÚ SORT »ò MERGE ÃüÁîÖÐʹÓà /STATISTICS ÏÞ¶¨´Ê¿É»ñµÃÓйØÅÅÐò»·¾³ÖбäÁ¿µÄÐÅÏ¢¡£

ÔÚ¼ì²éͳ¼ÆÏÔʾºó£¬¿¼ÂÇÒÔϼ¸½ÚÌá³öµÄÈκÎÓÅ»¯ÈÎÑ¡Ïî¡£

µ±ÊäÈë SORT »ò MERGE ÃüÁîʹÓà /STATISTICS ÏÞ¶¨´Êʱ£¬¿É¿´µ½ÀàËÆÒÔϵÄÊä³ö:

$ SORT/STATISTICS PAGEANT.LIS DOCUMENT.LIS
                  OpenVMS Sort/Merge Statistics

Records read:           3 (1)     Input record length:       26
Records sorted:         3        Internal length:           28
Records output:         3        Output record length:      26
Working set extent: 16384 (2)     Sort tree size:            42
Virtual memory:       392        Number of initial runs:     0
Direct I/O:            10        Maximum merge order:        0
Buffered I/O:          11        Number of merge passes:     0
Page faults:          158 (3)     Work file allocation:       0 (4)
Elapsed time: 00:00:00.54        Elapsed CPU:      00:00:00.03 (5)

µ±¼ì²éÕâЩ×Ö¶Îʱ£¬×¢ÒâÒÔϼ¸µã:

1. ¶ÁÈ¡¼Ç¼
   ÁгöÔÚ Sort ²Ù×÷ÆÚ¼ä¶ÁÈ¡µÄ¼Ç¼Êý¡£ÓйØÑ¡ÔñÐÔµØ´Ó Sort ²Ù×÷Ê¡ÂԼǼµÄÏêÇ飬Çë²ÎÔÄ 9.8.2 ½Ú¡£
2. ¹¤×÷Çø·¶Î§
   չʾ±£Áô¶àÉÙ¿é´æ´¢Æ÷Ö´ÐÐÅÅÐò²Ù×÷¡£ÓйØÀ©´ó¹¤×÷ÇøµÄÏêÇ飬Çë²ÎÔÄ 9.8.4 ½Ú¡£
3. Ò³¹ÊÕÏ
   չʾ²Ù×÷ϵͳ¶àÉٴΰѲ¿·Ö½ø³Ì´ÓÎïÀíÄÚ´æ´«Êäµ½·ÖÒ³É豸¡£ÓйØ×èÖ¹·ÖÒ³µÄÏêÇ飬Çë²ÎÔÄ 9.8.4 ½Ú¡£
4. ¹¤×÷Îļþ·ÖÅä
   չʾΪ¹¤×÷Îļþ±£Áô¶àÉÙ´ÅÅ̿ռ䡣Óйع¤×÷ÎļþµÄÏêÇ飬Çë²ÎÔÄ 9.8.3 ½Ú¡£
5. CPU ʹÓÃʱ¼ä
   չʾ²Ù×÷ϵͳʹÓöàÉÙ CPU ʱ¼ä´¦ÀíÅÅÐò²Ù×÷¡£ÓйØͨ¹ýÌôÑ¡²»Í¬ÅÅÐò·½·¨½Úʡʱ¼äµÄÏêÇ飬Çë²ÎÔÄ 9.8.1 ½Ú¡£

ÄÚ²¿ÅÅÐòÊý¾Ýʱ Sort ¶¨ÒåÒÔÏÂËĸö½ø³Ì: ¼Ç¼¡¢±êÇ©¡¢µØÖ·»òË÷Òý¡£(¸ßÐÔÄÜ Sort/Merge ¹«ÓóÌÐòÖ»Ö§³Ö¼Ç¼½ø³Ì¡£¶Ô±êÇ©¡¢µØÖ·ºÍË÷Òý½ø³ÌµÄʵÏÖÁô´ý½«À´µÄ OpenVMS Alpha ·¢Ðа汾¡£) RECORD ÊÇĬÈϽø³Ì¡£ÌôÑ¡½ø³ÌµÄÀàÐÍÓ°Ïì Sort ²Ù×÷ÐÔÄܺʹ洢ÐèÇó¡£Óйز»Í¬ÅÅÐò½ø³ÌµÄÏêÇ飬Çë²ÎÔÄ 9.2.6 ½Ú¡£

ÔÚÑ¡ÔñÅÅÐò½ø³Ì֮ǰ£¬¿¼ÂÇÒÔϼ¸µã:

• ÈçºÎʹÓÃÊä³öÎļþ
  • ÒòΪ¼Ç¼ºÍ±êÇ©ÅÅÐò²úÉú°üº¬Õû¸öÅÅÐò¼Ç¼µÄÎļþ£¬Òò´ËÕâЩÖØÐÂÅÅÐòµÄÎļþ¾ÍÐ÷´ýÓá£
  • µØÖ·ºÍË÷ÒýÅÅÐòµÄÊä³öÎļþ¿ÉÒÔ±»ÓÃÒ»ÖÖ³ÌÐòÉè¼ÆÓïÑÔÀýÈç Pascal¡¢Fortran¡¢MACRO »ò C ±àдµÄ³ÌÐò´¦Àí¡£
  • µØÖ·ÅÅÐò½¨Á¢Ò»¸ö°üº¬Ö¸ÕëµÄÊä³öÎļþ£¬Ã¿¸öÖ¸ÕëÖ¸ÏòÊäÈëÎļþµÄ¼Ç¼¡£µ±ÅÅÐò¶à¸öÊäÈëÎļþʱ£¬Õâ¸öÁбí°üÀ¨¶þ½øÖÆµÄ RFA ºÍÒ»¸öÎļþºÅ¡£³ÌÐòʹÓÃÖ¸Õë´æÈ¡¼Ç¼¡£
  • µ±ÅÅÐò¶à¸öÎļþʱ£¬Ë÷ÒýÅÅÐò½¨Á¢Ò»¸ö°üº¬ RFA¡¢¼ü×ֶκÍÒ»¸öÎļþºÅµÄÊä³öÎļþ¡£ÕâЩ¼ü×ֶεĸñʽÓëÊäÈëÎļþÒ»Ñù¡£Èç¹û³ÌÐò½«À´´¦ÀíʱÐèÒª¼ü×ֶεÄÄÚÈÝ£¬ÄÇôѡÔñË÷ÒýÅÅÐò£¬¶ø²»Ê¹ÓõØÖ·ÅÅÐò¡£
  
  Èç¹ûÕë¶Ô²»Í¬ÓÃ;ÐèÒªÓü¸ÖÖ·½·¨´ÓÒ»¸öÎļþÖØÐÂÅÅÐòÎļþ¼Ç¼£¬ÄÇô´æ´¢À´×ÔµØÖ·»òË÷ÒýÅÅÐòµÄ¼¸¸öÊä³öÎļþ¡£°´ÏëÒªµÄÅÅÐò´ÎÐò£¬Ê¹ÓÃÊä³öÎļþ´æÈ¡Ö÷ÎļþµÄ¼Ç¼¡£
• ¿ÉÓÃÓÚÅÅÐòµÄÁÙʱ´æ´¢¿Õ¼ä
  ±êÇ©ÅÅÐò±È¼Ç¼ÅÅÐòʹÓýÏÉÙµÄÁÙʱ´æ´¢¿Õ¼ä¡£ÒòΪ ¼Ç¼ÅÅÐòÔÚÅÅÐòʱ±£³Ö¼Ç¼ԭÑù£¬Òò´Ëµ±Îļþ±È½Ï´óʱ£¬ËüʹÓúܶ๤×÷¿Õ¼ä¡£µØÖ·ºÍË÷ÒýÅÅÐòʹÓúÜÉÙµÄÁÙʱ´æ´¢¿Õ¼ä¡£
• ʹÓõÄÊäÈëºÍÊä³öÉ豸ÀàÐÍ
  ¼Ç¼ÅÅÐò½ø³ÌÖ»¿ÉÒÔ½ÓÊܶÁ¿¨»ú¡¢´Å´øºÍ´ÅÅ̵ÄÊäÈë¡£±êÇ©ºÍ¼Ç¼ÅÅÐòµÄÊä³ö¿ÉÒÔдÈëÈκÎÊä³öÉ豸¡£µØÖ·ºÍË÷ÒýÅÅÐòµÄÊä³ö±ØÐëдÈëÄܹ»½ÓÊܶþ½øÖÆÊý¾ÝµÄÉ豸¡£
• ËٶȲî±ð
  Èç¹ûÔÚ²Ù×÷Öмƻ®¼ìË÷ÅÅÐòµÄ¼Ç¼£¬ÄÇô¼Ç¼ÅÅÐòͨ³£ÊÇ×î¿ìµÄ½ø³Ì¡£·ñÔò£¬µØÖ·ºÍË÷ÒýÅÅÐòÊÇ×î¿ìµÄ½ø³Ì¡£