Database Fields

Review the follow database field information.
view122
Review the follow database field information.
Contents
Database Fields for Report Control Record
The following table describes the database fields for the report control record:
Field Name
Description
Length
Type
ACCTFLD
Accounting field
20
C
ADDRESS
n
View
address line for the SYSOUT, where
n
can range from 1-4
60
C
ARCHDATE
Archival date of report
4
D
ARCHTIME
Archival time of report
4
T
BUILDING
Building identification
60
C
BURST
Burst indicator for 3800 printing
1
C
CHARS
n
Character arrangement table name for 3800 printing, where
n
can range from 1 - 4
4
C
CHGDATE
Indicates if the SYSOUT archive date and time were modified by the ARCHCHG feature
N - No
Y - Yes
1
C
CKPTLINE
Maximum lines in a logical page used by JES to determine when to checkpoint data
2
B
CKPTPAGE
Number of logical pages before JES checkpoint data
2
B
CKPTSEC
Number of seconds to elapse before JES checkpoint data
2
B
CLASS
SYSOUT class of the report
1
C
COLORMAP
Color translation resource object name
8
C
COMPACT
Compaction table name for sending SYSOUT to SNA terminal
8
C
COMSETUP
Microfiche setup resource name
8
C
CONTROL
Line spacing for SYSOUT
blank - Output parameter not specified
D - Double
P - Program
S - Single
T - Triple
1
C
COPIES
Copies count for SYSOUT
1
B
COPYG
n
Set of copy groups for 3800 printing, where
n
can range from 1-8
1
B
DATACK
How printer errors are handled
blank - Output parameter not specified
B - BLOCK
C - BLKCHAR
P - BLKPOS
U - UNBLOCK
1
C
DCOPY
Relative copy being retained on disk by ERO DCOPIES parameter
4
B
DEPT
Department identification for the SYSOUT
60
C
DEST
Print destination for the report
17
C
DGENS
Number of generations SYSOUT is retained on database disk
4
B
DISK
Indicator as to whether SYSOUT is on database disk
N - SYSOUT is not on disk
T - SYSOUT is temporarily loaded to disk
Y - SYSOUT is on disk
1
C
DISKBLKS
Number of blocks SYSOUT occupies on disk
4
B
DLVRID
Deliver
report name associated with the report
32
C
DPAGELBL
Indicates whether a security label is output
blank - Output parameter not specified
N - No
Y - Yes
1
C
DRETPD
Number of days SYSOUT is retained on database disk
4
B
DRPOS
File number on DR tape where SYSOUT was backed up
4
B
DRSEQ
DR tape sequence number
4
B
DRTAPE
Indicator as to whether the SYSOUT is on disaster recovery tape
N - SYSOUT is not on disaster recovery tape
Y - SYSOUT is on disaster recovery tape
1
C
DSK2
Indicator as to whether the SYSOUT is on secondary disk
N - SYSOUT is not on secondary disk
Y - SYSOUT is on secondary disk
1
C
DSK2DAYS
Number of days before SYSOUT is moved to secondary disk
4
B
DUPLEX
Indicator as to whether data is printed on both sides of paper
blank - Output parameter not specified
N - No
T - Tumble
Y - Normal
1
C
EROID
ERO table entry that defines retention criteria for SYSOUT
32
C
EXECEDAT
Ending execution date of job that created SYSOUT
4
D
EXECETIM
Ending execution time of job that created SYSOUT
4
T
EXECSDAT
Starting execution date of job that created SYSOUT
4
D
EXECSTIM
Starting execution time of job that created SYSOUT
4
T
FCB
Form control image name
4
C
FLASH
Forms flash overlay name for IBM 3800 printing
4
C
FLASHCT
Forms flash count for IBM 3800 printing
1
B
FORMDEF
Form definition for IBM 3800 printing
6
C
FORMLEN
Length and unit of measurement of the form
10
C
FORMS
Special forms name
8
C
FSSDATA
Functional subsystem data
127
C
FTPARM
Foreign tape parameter identification data
127
C
GEN
SYSOUT generation number
4
B
ID
SYSOUT/Report identifier name
32
C
INTRAY
Printer input tray
1
B
IPDEST
TCP/IP routing designation
127
C
JOBID
Job identifier number
8
C
JOBNAME
Job name
8
C
LASTACC
Date SYSOUT was last accessed
4
D
LINECT
Maximum number of lines to print on each output page
Note:
LINECT=0 is represented by a value of 255.
1
B
LINES
Number of SYSOUT lines or size of binary file
4
B
LOC
Location of the SYSOUT
4
C
MODIFY
Copy modification module name
4
C
NOTIFY
n
Print notification message designation, where
n
can range from 1-4
17
C
OFFSETXB
X offset of logical page origin for the back side of paper
8
C
OFFSETXF
X offset of logical page origin for the front side of paper
8
C
OFFSETYB
Y offset of logical page origin for the back side of paper
8
C
OFFSETYF
Y offset of logical page origin for the front side of paper
8
C
OPTCDJ
OPTCD=J indicator for IBM 3800 printing
N - OPTCD=J not specified
Y - OPTCD=J specified
1
C
ORIGIN
Origin of SYSOUT
EXP - Report created by
Deliver
SAR - SYSOUT collected by
View
XTD - SYSOUT replicated by SARXTD
4
C
OUTBIN
Output bin ID
2
B
OUTDISP
Normal output disposition
blank - Output parameter not specified
H - Hold
K - Keep
L - Leave
P - Purge
W - Write
1
C
OUTDISPA
Abnormal output disposition
blank - Output parameter not specified
H - Hold
K - Keep
L - Leave
P - Purge
W - Write
1
C
OVERLAYB
Medium overlay for the back side of paper
8
C
OVERLAYF
Medium overlay for the front side of paper
8
C
OWNER
User ID that created the report
8
C
PAGEDEF
Page definition for an IBM 3800 printer
6
C
PAGES
Number of SYSOUT pages
4
B
PERM
Indicator as to whether SYSOUT is in permanent retention status
M - SYSOUT marked for permanent evaluation
N - SYSOUT is not in permanent retention status
Y - SYSOUT is in permanent retention status
1
C
PGMRNAME
Programmer name from job card
20
C
PIMSG
Indicates whether messages from a functional subsystem are printed
blank - Output parameter not specified
N - Messages are not printed
Y - Messages are printed
1
C
PIMSGC
Message threshold at which the functional subsystem is to cancel printing
4
B
PORTNO
TCP port number at which FSS connects to the printer
4
B
PRMODE
Process mode required to print a SYSOUT data set
8
C
PRTDATE
Date SYSOUT was last printed
4
D
PRTERROR
Action for print errors
blank - Output parameter not specified
D - Default
H - Hold
Q - Quit
1
C
PRTOPTNS
Named entity of print options for FSS
16
C
PRTQUEUE
Target print queue for FSS
127
C
PRTTIME
Time SYSOUT was last printed
4
T
PRTY
Output priority at which a SYSOUT data set enters the output queue
1
B
RDRDATE
Job reader date
4
D
RDRTIME
Job reader time
4
T
RESFMT
Resolution that formats the print
blank - Output parameter not specified
2 - 240 pels per inch resolution
3 - 300 pels per inch resolution
1
C
RETAINF
Failed transmission retain time
10
C
RETAINS
Successful transmission retain time
10
C
RETRYL
Maximum number of transmission retries
2
B
RETRYT
Length of time to wait between retries
10
C
ROOM
Room identification
60
C
SEQ
SYSOUT sequence number
4
B
SYSAREA
Indicates whether the system is to reserve a system area on each page of output
blank - Output parameter not specified
N - No
Y - Yes
1
C
SYSID
System that created report
8
C
TAPE
Indicator as to whether SYSOUT is on tape
N - SYSOUT is not on tape
Y - SYSOUT is on tape
F - SYSOUT is on a foreign tape
1
C
TAPEBLKS
Number of blocks SYSOUT occupies on tape
4
B
TAPEPOS
File number on tape where SYSOUT was backed up
4
B
TAPESEQ
Tape sequence number to which SYSOUT was backed up
4
B
TCOPY
Relative copy being retained in
View
by ERO COPIES parameter
4
B
TGENS
Number of generations SYSOUT is retained
4
B
TITLE
Title identification
60
C
TRC
Copy modification table reference character for printing on an IBM 3800 printer
1
B
TRETPD
Number of days SYSOUT is retained
4
B
TYPE
Type of report
A - ACIF report
B - Distributed file (extension in WRITER field)
P - PDF report
T - Text report
X - DVS/PPS report
1
C
UCS
Universal character set
4
C
USERDATA
n
User data for the SYSOUT, where
n
can range from 1-16
60
C
USERFLD
User comment field
40
C
USERIF
SMF user field
8
C
USERLIB
n
User libraries contains AFP resources, where
n
can range from 1-8
44
C
WRITER
External writer name
8
C
XCODE
Exception code
6
C
Database Fields for Tape Control Record
The following table describes the database fields for the tape control record:
Field Name
Description
Length
Type
TAPEBLKS
Number of blocks on tape
4
B
TAPECAT
Indicator as to whether tape is cataloged
N - Tape is not cataloged
Y - Tape is cataloged
1
C
TAPECDAT
Date tape was initially created
4
D
TAPEDSN
Tape data set name
44
C
TAPEHGEN
Highest SYSOUT generation number on tape
4
B
TAPELBID
Block ID of end of tape
4
B
TAPELGEN
Lowest SYSOUT generation number on tape
4
B
TAPELTM
Last file number on tape
4
B
TAPENSEQ
Next tape sequence number that contains continuation data from this tape
4
B
TAPEPSEQ
Previous tape sequence whose data continues onto this tape
4
B
TAPESEQ
Tape sequence number
4
B
TAPETYPE
Type of tape
D - Duplex backup tape
P - Primary backup tape
R - Disaster record type
1
C
TAPEUNIT
Tape unit name
8
C
TAPEVOL
Tape volume serial number
8
C
Database Fields for Job Control Record
The following table describes the database fields for the job control record:
Field Name
Description
Length
Type
JOBCLASS
Job SYSOUT class
1
C
JOBCMNT
Job user comments
40
C
JOBDCLS
Class of SYSOUT of a job
1
C
JOBDDNAM
DD name of SYSOUT of a job
8
C
JOBDLINES
Line count of SYSOUT of a job
4
B
JOBDPAGES
Page count of SYSOUT of a job
4
B
JOBDSID
Data set ID of SYSOUT of a job
4
C
JOBEXEDT
Date the job stopped
4
D
JOBEXETM
Time the job stopped
4
T
JOBEXSDT
Date the job started
4
D
JOBEXSTM
Time the job started
4
T
JOBID
Job number
8
C
JOBLINES
Job line count
4
B
JOBNAME
Job name
8
C
JOBNDS
Job number of SYSOUT of a job
8
C
JOBOWNER
User ID of the job owner
8
C
JOBPAGES
Job page count
4
B
JOBPROC
Proc step name of SYSOUT of a job
8
C
JOBRGEN
Generation number of SYSOUT of a job
2
B
JOBRID
SYSOUT ID of SYSOUT of a job 
32
C
JOBRSEQ
Sequence number of SYSOUT of a job 
2
B
JOBSTEP
Step name of SYSOUT of a job
8
C
JOBSUBDT
Date when the job was submitted
4
D
JOBSUBTM
Time when the job was submitted
4
T
JOBSYSID
ID of the system on which the job ran
8
C
JOBUSER
Job user ID for follow up
8
C
JOBXCODE
Job exception code
6
C
 
Reserved Fields
The following table describes the reserved fields:
Field Name
Description
Length
Type
CDATE
The current date
4
D
CGEN
The current generation
4
B
COL
The current column number of the printed report being processed
4
B
CTIME
The current time
4
T
DATABASE
Database high-level name
17
C
LINECNT
Printable line per report page that has been processed
4
B
LINESIZE
Width of the report in characters
4
B
OUTFILE
DD statement name of the output file
8
C
PRTFILE
DD statement name of the print file
8
C