Support : DialogLink : Online Help : MAP : Items Option

MAP (continued)

Items Option

The Items option allows you to MAP certain records within a set. You can specify a single record (e.g., MAP RN /6), a range of records (e.g., MAP RN /1-3), or a non-sequential group of records (e.g., MAP RN S3/1-2,5,9-10). Separate each item or range with a comma. If you do not specify a set number, the items indicated are MAPped from the last set created.

In the following example, a search is run in D&B — Dun’s Market Identifiers^® to identify branch establishments for a specific group of corporate headquarters. Headquarters located in Alaska are SELECTed and SORTed by sales (SA,D) in descending order.

The MAP DN command is used to create a SearchSave of the D-U-N-S^® Numbers (unique company identifiers) of the 10 top companies. Items 1 to 10 are specified using the item range option. The Field Prefix option is used to change the prefix DN= to DH= to pull together all the branches for each headquarters location using the Headquarters D-U-N-S^® Number (DH=). The STEPS option creates a separate SELECT command for each headquarters and its branches.

• To use the Items option:

?b 516

File 516:D & B - DUNS MARKET IDENTIFIERS 2007/Feb
       (c) 2008 D&B
 
      Set  Items  Description
      ---  -----  -----------
?select st=ak and sf=headquarters
           27860  ST=AK
          484718  SF=HEADQUARTERS
      S1    1214  ST=AK AND SF=HEADQUARTERS
?sort s1/all/sa,d
S2    1214  Sort S1/ALL/SA,D
?map dn steps /dh=/1-10
 
11 Select Statement(s), 10 Search Term(s)
Serial#SD003
 
?exs sd003
      S3       3  DH=00-790-1317
      S4      26  DH=01-019-2953
      S5      17  DH=02-132-1500
      S6       0  DH=04-156-7595
      S7       7  DH=04-842-2034
      S8      46  DH=04-867-9567
      S9       1  DH=07-663-7073
     S10       1  DH=10-287-4161
     S11      55  DH=15-040-4523
     S12       2  DH=15-146-2066
     S13     158  S3:S12
?t s13/3

 13/3/1
File 516:D & B - DUNS MARKET IDENTIFIERS 2007/Feb
       (c) 2008 D&B

11166579
B P Exploration (alaska), Inc
1095 Sanduri St
Fairbanks, AK  99701-7457

TELEPHONE: 907-456-6891

BUSINESS: Crude Petroleum/Natural Gas Production

PRIMARY SIC:
 1311       Crude petroleum and natural gas, nsk
  13110100   Crude petroleum and natural gas production

DUNS NUMBER:           96-915-1026
HEADQUARTER DUNS:      15-146-2066  B P Exploration Alaska
CORPORATE FAMILY DUNS: 03-959-6507  BP America Inc

REGIONAL-AREA MANAGEMENT:    Bunch, Lynn   /Branch Manager

NUMBER OF EXECUTIVES: 1
LATEST UPDATE TO RECORD:    04/07/97

(Limits of the MAP Command) 

top