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

codetypenamefieldssubfields
MTCINDMatch035



DRA
SYSINDSystem NumberSYSID
BARINDBarcodez30-barcode
010INDLCCN010az
ISBNINDISBN020az
ISSNINDISSN022ayz
SICIINDSICI Code024de
ISMNINDISMN (Music)024bc
028INDMusic Publ. Number262ce
035INDUtility Number035az



019a
STIDNINDStandard Identifiers010az



019a



020az



022ayz



024az



035az



027az



262ce
BVLINDBVL (for print_09)999
IIIINDIII Bib. No.IIIa
IIOINDIII Order No.IIOa
IICINDIII Checkin No.IICa
DRAINDDRA DBCNDRAa
SCLIDINDRBMSCL Accession IDR01a
901INDAcq Vendor Matching No.901
909INDMarcive Temp No.019a



909a

 Browse Indexes

codetypenamefieldssubfields
TITACCTitles

TRTACCTitles/Related Title

AUTACCAuthors

AWTACCAuthors+Titles

SRS1ACCTraced Series

SRS2ACCNon traced Series

SUBACCGeneral Subjects

SULACCLC Subjects

SUMACCMeSH Subjects

SGNACCGenre Subjects

SUSACCLocal Subjects

PLAACCPlace

PUBACCPublisher

SUDACCGov't Doc. No.

SHLACCShelf List All

SLCACCShelf List LC

SLDACCShelf List Dewey

SLMACCShelf List NLM

SLPACCShelf List Per.

SLGACCShelf List SuDocs

SLAACCSL Accession No.

SLSACCShelf List RBMSCL

URLACCURL

XYZACCSubjects -vxyz

SULXACCLC Subjects -vxyz

SUMXACCMedical Subjects -vxyz

TIJRACCJournal Titles

TISEACCSerial Titles

MPNACCMusic Publisher No.

HPNACCHierch. Place Name

TIIACCTitles, III alternate

AUIACCAuthors, III alternate

LCIACCLC Call numbers

LDCACCDDC Call Number

MSHACCNLM Call Number

GVDACCGov. Doc. Number

GPOACCGPO Item Number

CNLACCAccession Call Nos.

PERACCTextual Call Numbers

CNSACCCall Nos. Spec.Coll.

CNAACCCall Nos. All

NWDACCNew to Duke

NWIACCNew to Independent Library

NWSACCNew to Sublib

 Word Indexes

codetypenamefieldssubfields
WRDW-001Keywords

WTIW-002Title Keywords

WRTW-003W-Related Titles

WAUW-004Authors Keywords

WSUW-005Subjects Keywords

WUTW-006W-Unif .Titles

WSMW-007W-MeSH Subj.

WNOW-008W-Notes

WNCW-009W-Contents Notes

WPUW-011W-publishers

WYRW-012W-year

WFMW-013W-format

WSTW-014W-status

WSLW-016W-Sublibrary

WCLW-017W-Collections

WLNW-018W-language code

WPLW-019W-place of publ.

WGAW-020W-geo area

WURW-021W-URL

WS1W-023W-Series1

WS2W-024W-Series2

WQSW-025Journals/Serials KWD

WQRW-026W-Recordings

WCFW-031Conferences Keywords

WTPW-032W-Type

WJRW-033W-Journal Title

WEJW-034W-E-Journals

WDBW-035W-Research Databases

WTHW-036W-Duke Theses

WQJW-037W-Journal Title

WITW-038W-Item Material Type

WTAW-039W-Titles, III alternate

WAIW-040W-Authors, III alternate

TXTW-041Full Text

BASEW-042Base

WIDW-043Cataloger IDCID
WSAW-046SerSol MARC Type

WSDW-047SerSol Database915
WSRW-048SerSol Provider916

CJK Indexes

codetypenamefieldssubfields
TITCACCTitles Chinese

TITJACCTitles Japanese

TITKACCTitles Korean

AUTCACCAuthors Chinese

AUTJACCAuthors Japanese

AUTKACCAuthors Korean

TRTCACCTitles/Related Title CHI

TRTJACCTitles/Related Title JPN

TRTKACCTitles/Related Title KOR

SRS1CACCTraced Series CHI

SRS1JACCTraced Series JPN

SRS1KACCTraced Series KOR

SRS2CACCNon traced Series CHI

SRS2JACCNon traces Series JPN

SRS2KACCNon 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


codetypenamefieldsubfield
SYSINDSystem NumberSYS
LKRINDBib System NumberLKRb
DRAINDDRA MFHDDRAa
CONINDDRA DBCNCONa
XPRINDExport RecordXPR

Browse indexes


codetypenamefieldsubfield
HSLACCSL LC852 0#bchi
HSDACCSL Dewey852 1#bchi
HSMACCSL NLM852 2#bchi
HSGACCSL SuDocs852 3#bchi
HSNACCSL Accession No.852 4#bchi
HSPACCSL Cuttered Pers.852 5#bchi
HSSACCSL RBMSCL852 8#bchi
HSAACCSL All852 ##bchi
HLCACCLC Call Numbers852 0#hi
HDCACCDewey Call Numbers852 1#hi
HNLACCNLM Call Numbers852 2#hi
HGVACCSuDocs Numbers852 3#hi
HACACCAccession Numbers852 4#hi
HPRACCCuttered Per. Nos.852 5#hi
HSCACCRBMSCL Call Numbers852 8#hi
HCAACCCall Numbers All852 ##hi
FDNACCFormer Dewey NumberDEW ##hi

 

Keyword indexes

codetypenamefieldsubfield
WHTW-001W-Hol. Record TypeLDR/06
WHAW-002W-Acq. Status008/06
WHMW-003W-Acq. Method008/07
WHGW-004W-Gen. Retention008/12
WHRW-005W-Specific Retention008/13-15
WHLW-006W-No. of Copies008/17-19
WHSW-007W-Sublibrary852 ##b
WHCW-008W-Collection852 ##c
WHNW-009W-Holding Notes852 ##xze



863 ##xz



856 ##uxyz3



866 ##axz
WSTW-010W-StatusSTAa

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