Support : DialogLink : Online Help : Limits of the MAP Command

MAP (continued)

Limits of the MAP Command

Length of SELECT Statements

A single SELECT statement generated by the MAP command is restricted to a total of 240 characters. If the search statement exceeds 240 characters, the system will automatically create an additional SELECT statement.

Maximum Number of SELECT Statements

A SearchSave created by a MAP command will create a maximum of 50 SELECT statements. The system automatically creates a final SELECT statement that ORs together the results of the 50 sets in one combined set.

If a MAP command creates more than 50 SELECT statements, the system will automatically generate an additional SearchSave. Each of the SearchSaves must be EXECUTEd separately, and their results either used independently or ORed together. (Using OR to combine the results of separate SearchSaves will eliminate duplicate records from the final set.)

• If more than 50 SELECT statements are created by MAP, Dialog generates additional SearchSaves:

?select migraine?
      S1    1357  MIGRAINE?
?map ic temp
 
51 Select Statement(s), 487 Search Term(s)  
Serial#TD027 
Processing MAP. 

51 Select Statement(s), 513 Search Term(s)  
Serial#TD028 
Processing MAP. 

51 Select Statement(s), 579 Search Term(s)  
Serial#TD029 
Processing MAP. 
 
51 Select Statement(s), 618 Search Term(s)  
Serial#TD030 
Processing MAP. 

51 Select Statement(s), 637 Search Term(s)  
Serial#TD031 
  
16 Select Statement(s), 190 Search Term(s)  
Serial#TD032 
 
5 SearchSaves,  3024 Search Term(s) 

(File 351: Derwent World Patents Index^®)

Maximum Number of SearchSaves

The MAP command creates up to 12 complete SearchSaves. If more than four are needed to MAP a large number of records, or if the STEPS option is used to MAP more than 200 unique search terms, a 13th SearchSave is created to complete MAPping of the last record in the process when the limit was reached. Dialog will display a message warning you that the limit has been exceeded and indicating the item number of the last record to be completely processed. For complete MAPping of a large number of records, you must enter a second MAP command, specifying the item range to be processed.

• If a MAP command creates more than 12 complete SearchSaves, you must enter a second MAP command:

?s migraine and py=2007:2008
            8502  MIGRAINE
         1495008  PY=2007 : PY=2008
      S4    2706  MIGRAINE AND PY=2007:2008

?map ic temp
Processing MAP

Temp SearchSave "TD540" stored
51 Select Statements, 550 Search Term(s) 
SearchSave TD540

Processing MAP

Temp SearchSave "TD541" stored
51 Select Statements, 550 Search Term(s) 
SearchSave TD541

Processing MAP

Temp SearchSave "TD542" stored
51 Select Statements, 551 Search Term(s) 
SearchSave TD542

Processing MAP

Temp SearchSave "TD543" stored
51 Select Statements, 554 Search Term(s) 
SearchSave TD543

Processing MAP

Temp SearchSave "TD544" stored
51 Select Statements, 552 Search Term(s) 
SearchSave TD544

Processing MAP

Temp SearchSave "TD545" stored
51 Select Statements, 558 Search Term(s) 
SearchSave TD545

Processing MAP

Temp SearchSave "TD546" stored
51 Select Statements, 556 Search Term(s) 
SearchSave TD546

Processing MAP

Temp SearchSave "TD547" stored
51 Select Statements, 555 Search Term(s) 
SearchSave TD547

Processing MAP

Temp SearchSave "TD548" stored
51 Select Statements, 558 Search Term(s) 
SearchSave TD548

Processing MAP

Temp SearchSave "TD549" stored
51 Select Statements, 560 Search Term(s) 
SearchSave TD549

Processing MAP

Temp SearchSave "TD550" stored
51 Select Statements, 555 Search Term(s) 
SearchSave TD550

Processing MAP

Temp SearchSave "TD551" stored
51 Select Statements, 555 Search Term(s) 
SearchSave TD551

Limit exceeded after processing item
 1319, of set 4

Temp SearchSave "TD552" stored
1 Select Statement, 7 Search Term(s) 
SearchSave TD552

13 SearchSave(s),  6661 Search Term(s)

?map ic temp s4/1320-2706
Processing MAP

Temp SearchSave "TD553" stored
51 Select Statements, 560 Search Term(s) 
SearchSave TD553

Processing MAP

Temp SearchSave "TD554" stored
51 Select Statements, 564 Search Term(s) 
SearchSave TD554

Processing MAP

Temp SearchSave "TD555" stored
51 Select Statements, 560 Search Term(s) 
SearchSave TD555

Processing MAP

Temp SearchSave "TD556" stored
51 Select Statements, 556 Search Term(s) 
SearchSave TD556

Processing MAP

Temp SearchSave "TD557" stored
51 Select Statements, 565 Search Term(s) 
SearchSave TD557

Processing MAP

Temp SearchSave "TD558" stored
51 Select Statements, 557 Search Term(s) 
SearchSave TD558

Processing MAP

Temp SearchSave "TD559" stored
51 Select Statements, 556 Search Term(s) 
SearchSave TD559

Processing MAP

Temp SearchSave "TD560" stored
51 Select Statements, 561 Search Term(s) 
SearchSave TD560

Processing MAP

Temp SearchSave "TD561" stored
51 Select Statements, 561 Search Term(s) 
SearchSave TD561

Processing MAP

Temp SearchSave "TD562" stored
51 Select Statements, 560 Search Term(s) 
SearchSave TD562

Processing MAP

Temp SearchSave "TD563" stored
51 Select Statements, 561 Search Term(s) 
SearchSave TD563

Processing MAP

Temp SearchSave "TD564" stored
51 Select Statements, 559 Search Term(s) 
SearchSave TD564

Limit exceeded after processing item
 1797, of set 4

Temp SearchSave "TD565" stored
1 Select Statement, 6 Search Term(s) 
SearchSave TD565

13 SearchSave(s),  6726 Search Term(s)

?map ic temp s4/1798-2706
Processing MAP

Temp SearchSave "TD566" stored
51 Select Statements, 561 Search Term(s) 
SearchSave TD566

Processing MAP
Processing MAP
Processing MAP

Temp SearchSave "TD567" stored
51 Select Statements, 563 Search Term(s) 
SearchSave TD567

Processing MAP

Temp SearchSave "TD568" stored
51 Select Statements, 563 Search Term(s) 
SearchSave TD568

Processing MAP

Temp SearchSave "TD569" stored
51 Select Statements, 562 Search Term(s) 
SearchSave TD569

Processing MAP

Temp SearchSave "TD570" stored
51 Select Statements, 568 Search Term(s) 
SearchSave TD570

Processing MAP

Processing MAP
Temp SearchSave "TD571" stored
51 Select Statements, 569 Search Term(s) 
SearchSave TD571

Processing MAP

Temp SearchSave "TD572" stored
51 Select Statements, 570 Search Term(s) 
SearchSave TD572

Processing MAP

Temp SearchSave "TD573" stored
51 Select Statements, 569 Search Term(s) 
SearchSave TD573

Processing MAP

Temp SearchSave "TD574" stored
51 Select Statements, 572 Search Term(s) 
SearchSave TD574

Processing MAP

Temp SearchSave "TD575" stored
51 Select Statements, 566 Search Term(s) 
SearchSave TD575

Processing MAP

Temp SearchSave "TD576" stored
51 Select Statements, 571 Search Term(s) 
SearchSave TD576

Processing MAP

Temp SearchSave "TD577" stored
51 Select Statements, 572 Search Term(s) 
SearchSave TD577

Limit exceeded after processing item
 2102, of set 4

Temp SearchSave "TD578" stored
1 Select Statement, 3 Search Term(s) 
SearchSave TD578

13 SearchSave(s),  6809 Search Term(s)

?map ic temp s1/2103-2706
Processing MAP

Temp SearchSave "TD579" stored
51 Select Statements, 561 Search Term(s) 
SearchSave TD579

Processing MAP

Temp SearchSave "TD580" stored
51 Select Statements, 560 Search Term(s) 
SearchSave TD580

Processing MAP

Processing MAP
Temp SearchSave "TD581" stored
51 Select Statements, 562 Search Term(s) 
SearchSave TD581

Processing MAP

Temp SearchSave "TD582" stored
51 Select Statements, 561 Search Term(s) 
SearchSave TD582

Processing MAP

Temp SearchSave "TD583" stored
51 Select Statements, 564 Search Term(s) 
SearchSave TD583

Processing MAP

Temp SearchSave "TD584" stored
51 Select Statements, 557 Search Term(s) 
SearchSave TD584

Processing MAP

Temp SearchSave "TD585" stored
51 Select Statements, 561 Search Term(s) 
SearchSave TD585

Processing MAP

Temp SearchSave "TD586" stored
51 Select Statements, 560 Search Term(s) 
SearchSave TD586

Processing MAP

Temp SearchSave "TD587" stored
51 Select Statements, 566 Search Term(s) 
SearchSave TD587

Processing MAP

Temp SearchSave "TD588" stored
51 Select Statements, 560 Search Term(s) 
SearchSave TD588

Processing MAP

Temp SearchSave "TD589" stored
51 Select Statements, 558 Search Term(s) 
SearchSave TD589

Processing MAP

Temp SearchSave "TD590" stored
40 Select Statements, 431 Search Term(s) 
SearchSave TD590

12 SearchSave(s),  6601 Search Term(s)

?recall temp
Name                           Modified Size
------------------------------ -------- ----
TD505                          10mar08    51
TD506                          10mar08    51
TD507                          10mar08    51
TD508                          10mar08    51
TD509                          10mar08    51
TD510                          10mar08    51
TD511                          10mar08    51
TD512                          10mar08    51
TD513                          10mar08    51
TD514                          10mar08    51
TD515                          10mar08    51
TD516                          10mar08    51
. . . .
TD578                          10mar08     1
TD579                          10mar08    51
TD580                          10mar08    51
TD581                          10mar08    51
TD582                          10mar08    51
TD583                          10mar08    51
TD584                          10mar08    51
TD585                          10mar08    51
TD586                          10mar08    51
TD587                          10mar08    51
TD588                          10mar08    51
TD589                          10mar08    51
TD590                          10mar08    40

(File 351: Derwent World Patents Index^®)

Note: To extend the preceding examples, EXECUTE the SearchSaves individually, and then use OR to combine the results in a single set. EXECUTE must be used, rather than EXECUTE STEPS, to avoid exceeding the maximum number of sets (999) that can be created in any single search.

(Using MAP through Menus) 

top