Descriptions of the sample data sets

The fields in the records of the sample data sets SORT.SAMPIN, SORT.SAMPADD and SORT.BRANCH are described on this page, and the contents of the records are described on the following pages.

Table 1 shows the length and data format of each field in the sample bookstore data set SORT.SAMPIN, and in the additional bookstore data set SORT.SAMPADD. Both of these data sets have fixed-length records (RECFM=FB) that are 173 bytes long (LRECL=133).

Table 1. SORT.SAMPIN and SORT.SAMPADD Field Descriptions
Field	Length	Data Format
Title	75	CH
Author's Last Name	15	CH
Author's First Name	15	CH
Publisher	4	CH
Course Department	5	CH
Course Number	5	CH
Course Name	25	CH
Instructor's Last Name	15	CH
Instructor's Initials	2	CH
Number In Stock	4	BI
Number Sold Y-to-D	4	BI
Price	4	BI

Table 2 shows the length and data format of each field in the sample branch data set SORT.BRANCH. This data set has fixed-length records (RECFM=FB) that are 33 bytes long (LRECL=33).

Table 2. SORT.BRANCH Field Descriptions
Field	Length	Data Format
City	15	CH
State	2	CH
Employees	4	ZD
Revenue	6	PD
Profit	6	PD

The contents of the records in the sample data sets are shown on the following pages. Each horizontal line represents a record, and each column represents a field. Headings show the field names and the starting and ending position of each field. Of course, these headings do not actually appear in the data sets. Numeric fields (BI, ZD, PD) would not actually be readable if displayed, but are shown as their equivalent readable values.

Sample Data Set - SORT.SAMPIN

Book Title	Author's Last Name	Author's First Name	Publisher	Course Department
1 75	76 90	91 105	106 109	110 114
COMPUTER LANGUAGES LIVING WELL ON A SMALL BUDGET SUPPLYING THE DEMAND VIDEO GAME DESIGN INKLINGS: AN ANTHOLOGY OF YOUNG POETS COMPUTERS: AN INTRODUCTION PICK'S POCKET DICTIONARY EDITING SOFTWARE MANUALS NUMBERING SYSTEMS STRATEGIC MARKETING THE INDUSTRIAL REVOLUTION MODERN ANTHOLOGY OF WOMEN POETS INTRODUCTION TO PSYCHOLOGY THE COMPLETE PROOFREADER SYSTEM PROGRAMMING SHORT STORIES AND TALL TALES INTRODUCTION TO BIOLOGY ADVANCED TOPICS IN PSYCHOANALYSIS EIGHTEENTH CENTURY EUROPE CRISES OF THE MIDDLE AGES	MURRAY DEWAN MILLER RASMUSSEN WILDE DINSHAW GUSTLIN OJALVO BAYLESS YAEGER GROSS COWARD DUZET GREEN CAUDILLO AVRIL WU OSTOICH MUNGER BENDER	ROBERT FRANK TOM LORI KAREN JOKII CAROL VICTOR WILLIAM MARK DON PETER LINDA ANN RAUL LILIANA CHIEN DIANNE ALICE GREG	FERN COR COR VALD COR WETH COR VALD FERN VALD WETH COR COR FERN WETH VALD VALD FERN WETH COR	COMP BUSIN COMP ENGL COMP ENGL COMP BUSIN HIST ENGL PSYCH ENGL COMP ENGL BIOL PSYCH HIST HIST

Sample Data Set - SORT.SAMPADD

Book Title	Author's Last Name	Author's First Name	Publisher	Course Department
1 75	76 90	91 105	106 109	110 114
GUNTHER'S GERMAN DICTIONARY COMPLETE SPANISH DICTIONARY ANOTHER ITALIAN DICTIONARY FRENCH TO ENGLISH DICTIONARY GUIDE TO COLLEGE LIFE THE ANIMAL KINGDOM A SMALLER WORLD: MICROBES DNA: BLUEPRINT FOR YOU CELLS AND HOW THEY WORK KNOW YOUR CONSUMER ANTICIPATING THE MARKET ZEN BUSINESS THE ART OF TAKEOVERS THE TOY STORE TEST NOVEL IDEAS POLITICS AND HISTORY CIVILIZATION SINCE ROME FELL REBIRTH FROM ITALY FREUD'S THEORIES MAP OF THE HUMAN BRAIN QUEUE THEORY DESIGNING APPLICATIONS	WILLIS ROBERTS UNDER JONES LAMB YOUNG BEESLY IAVERS JETTS ZANE ALLEN WILLIAMS HUNT LITTLE PETERS TOMPSOM PIERCE FISH GOOLE WINTER FOX STEVENS	GUNTER ANGEL JOAN JACK CHARLENE KEVIN GEORGE ILSE PETER JENNIFER CLYDE KATIE ROBERT MARIE SETH KEN NICOLE JOHN APRIL POLLY THAD NOAH	WETH VALD COR FERN WETH COR FERN FERN VALD COR WETH VALD FERN COR VALD FERN WETH WETH VALD COR FERN COR	BIOL BIOL BIOL BIOL BUSIN BUSIN BUSIN BUSIN COMP ENGL HIST HIST HIST PSYCH PSYCH BUSIN COMP

Sample Data Set - SORT.SAMPIN (continued)

Course Number	Course Name	Instructor's Last Name	Instructor's Initials	Number In Stock	Number Sold Year-to-Date	Price
115 119	120 144	145 159	160 161	162 165	166 169	170 173
00032 70251 00205 10856 00032 10347 00032 70124 50420 10856 30016 10347 00103 10054 80521 30975 50632 50521	INTRO TO COMPUTERS MARKETING VIDEO GAMES MODERN POETRY INTRO TO COMPUTERS TECHNICAL EDITING INTRO TO COMPUTERS ADVANCED MARKETING WORLD HISTORY MODERN POETRY PSYCHOLOGY I TECHINCAL EDITING DATA MANAGEMENT FICTION WRITING BIOLOGY I PSYCHOANALYSIS EUROPEAN HISTORY WORLD HISTORY	CHATTERJEE MAXWELL NEUMANN FRIEDMAN CHATTERJEE MADRID CHATTERJEE LORCH GOODGOLD FRIEDMAN ZABOSKI MADRID SMITH BUCK GREENBERG NAKATSU BISCARDI WILLERTON	CL RF LB KR CL MM AN MH ST KR RL MM DC GR HC FL HR DW	5 14 0 10 2 20 46 13 6 3 15 1 26 7 4 10 6 1 23 14	29 1 32 10 32 26 38 32 27 35 9 26 15 19 23 9 11 12 21 17	2600 9900 1925 2199 595 1899 295 1450 360 2350 795 450 2200 625 3195 1520 2350 2800 1790 1200

Sample Data Set - SORT.SAMPADD (continued)

Sample Data Set - SORT.SAMPIN (continued)

Course Number	Course Name	Instructor's Last Name	Instructor's Initials	Number In Stock	Number Sold Year-to-Date	Price
115 119	120 144	145 159	160 161	162 165	166 169	170 173
80522 80522 80523 80523 70251 70124 70255 70255 00205 10054 50521 50420 50632 30975 30016 70255 00103	BIOLOGY II BIOLOGY II INTRO TO GENETICS INTRO TO GENETICS MARKETING ADVANCED MARKETING BUSINESS THEORY BUSINESS THEORY VIDEO GAMES FICTION WRITING WORLD HISTORY WORLD HISTORY EUROPEAN HISTORY PSYCHOANALYSIS PSYCHOLOGY I BUSINESS THEORY DATA MANAGEMENT	HAROLD HAROLD ABRAHAM ABRAHAM MAXWELL LORCH SCHOFFE SCHOFFE NEUMANN BUCK WILLERTON GOODGOLD BISCARDI NAKATSU ZABOSKI SCHOFFE SMITH	LM LM NG NG RF MH KN KN LB GR DW ST HR FL RL KN DC	3 8 26 7 20 2 9 15 8 16 20 12 17 15 11 3 6 10 12 6 2 7	16 4 6 17 1 30 20 21 46 3 25 12 15 12 25 17 15 20 15 9 20 15	1088 650 925 1100 2000 3000 1955 2195 2495 4500 2000 1200 615 2600 2450 995 1350 2560 1250 895 1500 1435

Sample Data Set - SORT.BRANCH

City	State	Employees	Revenue	Profit
1 15	16 17	18 21	22 27	28 33
Los Angeles San Francisco Fort Collins Sacramento Sunnyvale Denver Boulder Morgan Hill Vail San Jose San Diego Aspen	CA CA CO CA CA CO CO CA CO CA CA CO	32 35 22 29 18 33 32 15 19 21 22 20	22530 42820 12300 42726 16152 31876 33866 18200 23202 27225 32940 25800	-4278 6832 -2863 8276 -978 6288 7351 3271 5027 8264 8275 5200