Objective
This report lists all employee name, ID, start date, and job title information stored in the Personnel database. Any employee having more than one job title in the course of employment is listed each time the job title changes. Numeric fields are not edited.
Parameters
DATABASE specifies the database parameter. If used, it must always be the first parameter.
DICTNAME=DOCUDICT specifies DOCUDICT as the dictionary used for the report.
DB specifies a database as the data source.
SS=EMPSS01 specifies EMPSS01 as the subschema used.
PATH specifies the PATH parameter.
AA names the path.
EMPLOYEE EMPOSITION JOB specifies the related database records used as a path through the database.
0151*010 EMP-NAME-0415 0151*020 EMP-ID-0415 0151*030 START-DATE-0420 0151*040 TITLE-0440
The field names are the same as those used in the database.
Complete Code
col. 2 ▼ DATABASE DICTNAME=DOCUDICT IN DB SS=EMPSS01 PATHAA EMPLOYEE EMPOSITION JOB 01OUT 80 D 013 EMPLOYEE LISTING 0151*010 EMP-NAME-0415 HH ' ' 'EMPLOYEE' 'NAME' 0151*020 EMP-ID-0415 HH 'EMPLOYEE' 'ID' 0151*030 START-DATE-0420 HH 'START' 'DATE' 0151*040 TITLE-0440 HH 'JOB' 'TITLE'
Result
REPORT NO. 01 EMPLOYEE LISTING mm/dd/yy PAGE 1 EMPLOYEE EMPLOYEE START JOB NAME ID DATE TITLE KATHERINE O'HEARN 23 790505 PROGRAMMER/ANALYST KATHERINE O'HEARN 23 780504 PROGRAMMER TRAINEE ROBBY WILDER 472 790716 DIR CORP CONFUSION BURT LANCHESTER 301 800203 RAINMAKER BURT LANCHESTER 301 770203 RAINMAKER BURT LANCHESTER 301 750203 RAINMAKER VLADIMIR HEAROWITZ 27 810909 PROGRAMMER/ANALYST THEMIS PAPAZEUS 471 820101 DIR WEATHER THEMIS PAPAZEUS 471 780907 MGR BRAINSTORMING MONTE BANK 7 780430 MGR PUBLIC RELATIONS CAROLYN CROW 334 790617 RAINDANCE CONSULTANT CAROL MCDOUGALL 127 800607 PASTE-UP ARTIST JULIE JENSEN 19 820929 PROGRAMMER/ANALYST
|
Copyright © 2014 CA.
All rights reserved.
|
|