Searching OCLC and Aleph
Scope: Lists commonly used common command language (CCL) codes for searching bibliographic, holdings, and item metadata in Aleph. Provides sample WorldCat searches via Connexion.
Contact: Natalie Sommerville
Unit: Resource Description
Date last reviewed: April 5, 2023
Date of next review: June 30, 2023
General (including link to OCLC login and export information)
This is not a comprehensive document on searching, which is better demonstrated and learned through practice than written about extensively. It is just a few hints on effective searching.
Information on OCLC login and export is described here
For items already barcoded in Aleph, searching by scanning the Duke barcode is the quickest way to retrieve the record. HOWEVER, be aware of the possibility of duplicate records, especially for items that are part of a set or series
Especially for current imprints the ISBN number is usually the quickest and most accurate initial search. This is especially true now that ISBNs are often printed in barcode form on book covers. These can be scanned into either Aleph or OCLC for very quick searching.
HOWEVER, be aware that records in OCLC and Aleph may lack ISBNs, so if the ISBN search turns up either no results or only unacceptable copy, try another search. Also, be aware that though ISBNs are theoretically unique identifiers, publishers may use them for more than one edition, and sometimes even for more than one title. Always check that the item in hand matches the record found.
In both Aleph and OCLC, there are two types of search, one ("find" or "search") for keywords and unique identifiers and one ("browse") for browsing index screens.
In Aleph, an ISBN may be entered as either a "find" or a "browse" search. Using "find" will take you to the desired record with fewer clicks.
In OCLC, ISBN is not a "browse" option. For more information on searching in OCLC, see the Quick Reference Guide.
Unless the title is very generic, a title browse is usually the most effective second search.
Aleph CCL codes for DUK01
Index codes from the DUK01 for use in CCL searches, and service retrieval. (see DUK01>tab>tab00.eng in Aleph Table Navigator)
Direct Indexes
code | type | name | fields | subfields |
---|---|---|---|---|
MTC | IND | Match | 035 | |
DRA | ||||
SYS | IND | System Number | SYSID | |
BAR | IND | Barcode | z30-barcode | |
010 | IND | LCCN | 010 | az |
ISBN | IND | ISBN | 020 | az |
ISSN | IND | ISSN | 022 | ayz |
SICI | IND | SICI Code | 024 | de |
ISMN | IND | ISMN (Music) | 024 | bc |
028 | IND | Music Publ. Number | 262 | ce |
035 | IND | Utility Number | 035 | az |
019 | a | |||
STIDN | IND | Standard Identifiers | 010 | az |
019 | a | |||
020 | az | |||
022 | ayz | |||
024 | az | |||
035 | az | |||
027 | az | |||
262 | ce | |||
BVL | IND | BVL (for print_09) | 999 | |
III | IND | III Bib. No. | III | a |
IIO | IND | III Order No. | IIO | a |
IIC | IND | III Checkin No. | IIC | a |
DRA | IND | DRA DBCN | DRA | a |
SCLID | IND | RBMSCL Accession ID | R01 | a |
901 | IND | Acq Vendor Matching No. | 901 | |
909 | IND | Marcive Temp No. | 019 | a |
909 | a |
Browse Indexes
code | type | name | fields | subfields |
---|---|---|---|---|
TIT | ACC | Titles | ||
TRT | ACC | Titles/Related Title | ||
AUT | ACC | Authors | ||
AWT | ACC | Authors+Titles | ||
SRS1 | ACC | Traced Series | ||
SRS2 | ACC | Non traced Series | ||
SUB | ACC | General Subjects | ||
SUL | ACC | LC Subjects | ||
SUM | ACC | MeSH Subjects | ||
SGN | ACC | Genre Subjects | ||
SUS | ACC | Local Subjects | ||
PLA | ACC | Place | ||
PUB | ACC | Publisher | ||
SUD | ACC | Gov't Doc. No. | ||
SHL | ACC | Shelf List All | ||
SLC | ACC | Shelf List LC | ||
SLD | ACC | Shelf List Dewey | ||
SLM | ACC | Shelf List NLM | ||
SLP | ACC | Shelf List Per. | ||
SLG | ACC | Shelf List SuDocs | ||
SLA | ACC | SL Accession No. | ||
SLS | ACC | Shelf List RBMSCL | ||
URL | ACC | URL | ||
XYZ | ACC | Subjects -vxyz | ||
SULX | ACC | LC Subjects -vxyz | ||
SUMX | ACC | Medical Subjects -vxyz | ||
TIJR | ACC | Journal Titles | ||
TISE | ACC | Serial Titles | ||
MPN | ACC | Music Publisher No. | ||
HPN | ACC | Hierch. Place Name | ||
TII | ACC | Titles, III alternate | ||
AUI | ACC | Authors, III alternate | ||
LCI | ACC | LC Call numbers | ||
LDC | ACC | DDC Call Number | ||
MSH | ACC | NLM Call Number | ||
GVD | ACC | Gov. Doc. Number | ||
GPO | ACC | GPO Item Number | ||
CNL | ACC | Accession Call Nos. | ||
PER | ACC | Textual Call Numbers | ||
CNS | ACC | Call Nos. Spec.Coll. | ||
CNA | ACC | Call Nos. All | ||
NWD | ACC | New to Duke | ||
NWI | ACC | New to Independent Library | ||
NWS | ACC | New to Sublib |
Word Indexes
code | type | name | fields | subfields |
---|---|---|---|---|
WRD | W-001 | Keywords | ||
WTI | W-002 | Title Keywords | ||
WRT | W-003 | W-Related Titles | ||
WAU | W-004 | Authors Keywords | ||
WSU | W-005 | Subjects Keywords | ||
WUT | W-006 | W-Unif .Titles | ||
WSM | W-007 | W-MeSH Subj. | ||
WNO | W-008 | W-Notes | ||
WNC | W-009 | W-Contents Notes | ||
WPU | W-011 | W-publishers | ||
WYR | W-012 | W-year | ||
WFM | W-013 | W-format | ||
WST | W-014 | W-status | ||
WSL | W-016 | W-Sublibrary | ||
WCL | W-017 | W-Collections | ||
WLN | W-018 | W-language code | ||
WPL | W-019 | W-place of publ. | ||
WGA | W-020 | W-geo area | ||
WUR | W-021 | W-URL | ||
WS1 | W-023 | W-Series1 | ||
WS2 | W-024 | W-Series2 | ||
WQS | W-025 | Journals/Serials KWD | ||
WQR | W-026 | W-Recordings | ||
WCF | W-031 | Conferences Keywords | ||
WTP | W-032 | W-Type | ||
WJR | W-033 | W-Journal Title | ||
WEJ | W-034 | W-E-Journals | ||
WDB | W-035 | W-Research Databases | ||
WTH | W-036 | W-Duke Theses | ||
WQJ | W-037 | W-Journal Title | ||
WIT | W-038 | W-Item Material Type | ||
WTA | W-039 | W-Titles, III alternate | ||
WAI | W-040 | W-Authors, III alternate | ||
TXT | W-041 | Full Text | ||
BASE | W-042 | Base | ||
WID | W-043 | Cataloger ID | CID | |
WSA | W-046 | SerSol MARC Type | ||
WSD | W-047 | SerSol Database | 915 | |
WSR | W-048 | SerSol Provider | 916 |
CJK Indexes
code | type | name | fields | subfields |
---|---|---|---|---|
TITC | ACC | Titles Chinese | ||
TITJ | ACC | Titles Japanese | ||
TITK | ACC | Titles Korean | ||
AUTC | ACC | Authors Chinese | ||
AUTJ | ACC | Authors Japanese | ||
AUTK | ACC | Authors Korean | ||
TRTC | ACC | Titles/Related Title CHI | ||
TRTJ | ACC | Titles/Related Title JPN | ||
TRTK | ACC | Titles/Related Title KOR | ||
SRS1C | ACC | Traced Series CHI | ||
SRS1J | ACC | Traced Series JPN | ||
SRS1K | ACC | Traced Series KOR | ||
SRS2C | ACC | Non traced Series CHI | ||
SRS2J | ACC | Non traces Series JPN | ||
SRS2K | ACC | Non traces Series KOR |
CCL Codes for DUK60
This is the complete list of index codes for CCL searching in the DUK60 Holdings Library.
To search these indexes the DUK60 base must be selected within the GUI. These will retrieve the holding records directly rather than the associated bibliographic records.
If the bibliographic records were what were needed, execute the search with the ret-03 service on the DUK60 and then use the records key conversion (manage-70) service to retrieve the associated bibliographic records.
Direct indexes
code | type | name | field | subfield |
---|---|---|---|---|
SYS | IND | System Number | SYS | |
LKR | IND | Bib System Number | LKR | b |
DRA | IND | DRA MFHD | DRA | a |
CON | IND | DRA DBCN | CON | a |
XPR | IND | Export Record | XPR |
Browse indexes
code | type | name | field | subfield |
---|---|---|---|---|
HSL | ACC | SL LC | 852 0# | bchi |
HSD | ACC | SL Dewey | 852 1# | bchi |
HSM | ACC | SL NLM | 852 2# | bchi |
HSG | ACC | SL SuDocs | 852 3# | bchi |
HSN | ACC | SL Accession No. | 852 4# | bchi |
HSP | ACC | SL Cuttered Pers. | 852 5# | bchi |
HSS | ACC | SL RBMSCL | 852 8# | bchi |
HSA | ACC | SL All | 852 ## | bchi |
HLC | ACC | LC Call Numbers | 852 0# | hi |
HDC | ACC | Dewey Call Numbers | 852 1# | hi |
HNL | ACC | NLM Call Numbers | 852 2# | hi |
HGV | ACC | SuDocs Numbers | 852 3# | hi |
HAC | ACC | Accession Numbers | 852 4# | hi |
HPR | ACC | Cuttered Per. Nos. | 852 5# | hi |
HSC | ACC | RBMSCL Call Numbers | 852 8# | hi |
HCA | ACC | Call Numbers All | 852 ## | hi |
FDN | ACC | Former Dewey Number | DEW ## | hi |
Keyword indexes
code | type | name | field | subfield |
---|---|---|---|---|
WHT | W-001 | W-Hol. Record Type | LDR/06 | |
WHA | W-002 | W-Acq. Status | 008/06 | |
WHM | W-003 | W-Acq. Method | 008/07 | |
WHG | W-004 | W-Gen. Retention | 008/12 | |
WHR | W-005 | W-Specific Retention | 008/13-15 | |
WHL | W-006 | W-No. of Copies | 008/17-19 | |
WHS | W-007 | W-Sublibrary | 852 ## | b |
WHC | W-008 | W-Collection | 852 ## | c |
WHN | W-009 | W-Holding Notes | 852 ## | xze |
863 ## | xz | |||
856 ## | uxyz3 | |||
866 ## | axz | |||
WST | W-010 | W-Status | STA | a |
More detail about OCLC searching
For OCLC's searching documentation see the client help in Connexion, under Cataloging/Search World Cat
A local summary follows:
created by Cheryl Thomas, last revised 10/26/2010
Derived Searching in OCLC Connexion
Title 3,2,2,1
Gone with the Wind gon,wi,th,w
42nd Street 42n,st,,
I am the walrus i,am,th,w
Name/Title 4,4
Mitchell/Gone with the wind mitc,gone
Hershey Foods Corp/The winning spirit hers,winn
Personal name 4,3,1
Mitchell, Margaret mitc,mar,
Tolkien, J. R. R. tolk,j,r
Corporate name =4,3,1
Hershey Foods Corporation =hers,foo,c
National Audubon Society =audu,soc,
Numbered Searches
ISBN 0-85109-130-x 085109130x (Complete number without hyphens)
ISSN 1234-5678 in:1234-5678 (Complete number with hyphen)
LCCN map32-14 ln:32-14
2002-580246 ln:2002-580246 or 2002580246
OCLC number *2
Government document number
A 1.2:R 31/14/984 gn:a12r3114984
NAS 1.2:SP1/46 gn:nas12sp146
Music publisher number mn: followed by the publisher number
CO 1979-AB5-1 mn:co1979ab51
To find this data ... | Enter this search ... |
Mozart, Wolfgang Amadeus | moza,wol,a |
De Groot, Adriaan | degr,adr, |
Kübler-Ross, Elisabeth | kubl,eli, |
American Rock Garden Society | =rock,gar,s |
World Energy Conference | =worl,ene,c |
Bergson, The creative mind | berg,crea |
Clarke, 2001 : a space odyssey | clar,2001 |
Realism in our time | rea,in,ou,t |
Hotel | hot,,, |
Miracle on 34th street | mir,on,34,s |
Qualifiers:
For more precise search results you can qualify most of these searches by date, form, source, and language. Some examples:
bach,bran/1832 (an 1832 imprint of Bach's Brandenburg Concerti)
bach,bran/sco (a score of Bach's Brandenburg Concerti, not a recording)
gre,ex,,/bks (records for monograph editions of Great Expectations, not films, videos, recordings, or microfilm, etc.)
Format qualifiers:
/bks, /map, /vis, /com, /sco, /rec, /ser, /mf, /nm
Date qualifiers:
Single year /1980
Decade /198?
Century /19??
Single year and following: 1980-
Source:
/dlc
Corporate and Conference Name Stopwords | ||
Names of all states in the U.S. and the following: | ||
a | East | Seminar |
A. | for | Senate |
American | France | Society |
an | Great Britain | South |
Association | Gt. Brit. | State |
Australia | Gt.Brit. | Subcommittee |
Bureau | House | Symposium |
Canada | India | the |
Colloquium | Institute | U.N. |
Commission | Institution | U. N. |
Committee | International | United Nations |
Conference | Joint | United States |
Congress | National | University |
Council | North | U. S. |
Department | of | U.S. |
Dept. | on | West |