Creating Sample Data Sources

Create sample data sources on your user ID by executing the procedures specified below. These FOCEXECs are supplied with FOCUS. If they are not available to you or if they produce error messages, contact your systems administrator or Information Builders Customer Support Services.

To create these files, first make sure you have read access to the Master Files.

Data Source

Load Procedure Name

EMPLOYEE, EDUCFILE, and JOBFILE

EX EMPTSO

These FOCEXECs also test the data sources by generating sample reports. If you are using Hot Screen, remember to press either Enter or the PF3 key after each report. If the EMPLOYEE, EDUCFILE, and JOBFILE data sources already exist on your user ID, the FOCEXEC replaces them with new copies. This FOCEXEC assumes that the high-level qualifier for the FOCUS data sources is the same as the high-level qualifier for the MASTER PDS that was unloaded from the tape.

SALES

PROD

EX SALES
EX PROD

CAR

None (created automatically during installation).

LEDGER

FINANCE

REGION

COURSES

EXPERSON

EX LEDGER
EX FINANCE
EX REGION
EX COURSES
EX EXPERSON

EMPDATA

TRAINING

COURSE

JOBHIST

JOBLIST

LOCATOR

PERSINFO

SALHIST

EX LOADPERS

PAYHIST

None (PAYHIST DATA is a sequential data source and is allocated during the installation process).

COMASTER

None (COMASTER is used for debugging other Master Files).

VIDEOTRK and MOVIES

EX LOADVTRK

VIDEOTR2

EX LOADVID2

Gotham Grinds

EX DBLGG

Century Corp:

CENTCOMP

CENTFIN

CENTHR

CENTINV

CENTORD

CENTQA

CENTGL

CENTSYSF

CENTSTMT

 
EX LOADCOM
EX LOADFIN
EX LOADHR
EX LOADINV
EX LOADORD
EX LOADCQA
EX LDCENTGL
EX LDCENTSY
EX LDSTMT

Information Builders