Administrative Information Services: Computer Services

ADMINISTRATIVE INFORMATION SERVICES : USC COMPUTER SERVICES

DIVISION OF IT

OFFICE OF IT

GET CONNECTED

UTS HOME


	POPULAR LINKS
	DEPARTMENTS
	SERVICES & SUPPORT
	NEWS & INFORMATION
	A-Z INDEX

AIS HOME

CONTACTS

AIS LIBRARY

MAINFRAME STANDARDS MANUAL RETURN TO INDEX

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.01.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: GENERAL INFORMATION

THE FOLLOWING NUMBERING SYSTEM HAS BEEN DEVISED TO FACILITATE THE IDENTIFICATION OF JOBS, PROGRAMS, DB2 OBJECTS, AND FILES TO BE USED BY THE STANDARDS DEPARTMENT.

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.02.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: PROGRAM IDENTIFICATION

ALL PROGRAMS THAT WILL BE RUN IN THE PRODUCTION ENVIRONMENT MUST HAVE A UNIQUE PROGRAM IDENTIFICATION NUMBER ASSIGNED IN THE FOLLOWING SEQUENCE:

DIVISION APPLICATION PROGRAM PROGRAM APPROXIMATE

NUMBER TYPE FREQUENCY

D AA NNN T F

DIVISION (REFER TO 2.2.01.01)

APPLICATION (REFER TO 2.2.02.01)

PROGRAM NUMBER - THREE NUMERIC CHARACTERS. THE FIRST PROGRAM IN AN APPLICATION IS TO BE NUMBERED 005. SUBSEQUENT PROGRAMS ARE TO BE NUMBERED IN SEQUENCE AND INCREMENTED BY 5 TO PERMIT FUTURE INSERTIONS OF NEW PROGRAMS. INSERTIONS SHOULD BE PLACED EQUALLY BETWEEN EXISTING NUMBERS TO PERMIT FUTURE INSERTIONS. IF THE NUMBER OF PROGRAMS IN AN APPLICATION DOES NOT PERMIT NUMBERING BY 5, A SMALLER NUMBER MAY BE USED.

PROGRAM TYPE (REFER TO 2.2.04.01)

APPROXIMATE FREQUENCY (REFER TO 2.2.05.01)

PROGRAM IDENTIFICATION EXAMPLE

F55030CW

F - DIVISION, FINANCIAL

55 - APPLICATION, PAYROLL

030 - PROGRAM NUMBER, 30 IN THE PAYROLL APPLICATION SERIES

C - PROGRAM TYPE, WRITTEN IN COBOL

W - APPROXIMATE FREQUENCY, RUN WEEKLY

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.03.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED: 08/04/86

SUBJECT: JOB IDENTIFICATION

ALL JOBS THAT WILL BE RUN IN A PRODUCTION ENVIRONMENT MUST HAVE A UNIQUE JOB IDENTIFICATION NUMBER ASSIGNED IN THE FOLLOWING SEQUENCE:

DIVISION APPLICATION JOB TYPE APPROXIMATE

NUMBER FREQUENCY

D AA NNN T F

DIVISION (REFER TO 2.2.01.01)

APPLICATION (REFER TO 2.2.02.01)

JOB NUMBER - THREE NUMERIC CHARACTERS. THE FIRST JOB IN AN APPLICATION AND JOB TYPE IS TO BE NUMBERED 001. SUBSEQUENT JOBS ARE TO BE NUMBERED IN SEQUENCE AND INCREMENTED BY 1

AN EXCEPTION TO THE ASSIGNMENT OF JOB NUMBERS EXISTS FOR THE MULTIPLE AGENCY ACCOUNTING SYSTEM (MASS). WHEN DEFINING JOB NUMBERS FOR THE MASS SYSTEM THE JOB NUMBERS ARE ASSIGNED BY GROUPS RATHER THAN SEQUENTIALLY. THE ALLOWABLE GROUPS ARE AS FOLLOWS:

400-499 - S. C. AERONAUTICS COMMISSION

500-599 - S. C. WATER RESOURCES

600-699 - S. C. DEPARTMENT OF LABOR

700-799 - S. C. DEPARTMENT OF YOUTH SERVICES

800-899 - S. C. COMMISSION ON AGING

900-999 - S. C. PAROLE AND COMMUNITY CORRECTIONS

JOB TYPE (REFER TO 2.2.07.01)

APPROXIMATE FREQUENCY (REFER TO 2.2.05.01)

JOB IDENTIFICATION EXAMPLE

E300064A

E - DIVISION, EDUCATION

30 - APPLICATION, GRADES

006 - PROGRAM NUMBER, 006 IN THE GRADES APPLICATION SERIES

4 - JOB TYPE, COMPUTER RUN

A - APPROXIMATE FREQUENCY, AS NEEDED

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.04.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: DATA BASE NAMES

ALL DATA BASE NAMES WILL CONSIST OF 5 ALPHA NUMERIC CHARACTERS IN THE FOLLOWING SEQUENCE:

DIVISION DATA BASE DATA BASE

NUMBER INDICATOR

D NN II

DIVISION (REFER TO 2.2.01.01)

DATA BASE NUMBER - TWO NUMERIC CHARACTERS. THE FIRST DATA BASE IN A DIVISION IS TO BE NUMBERED 01. SUBSEQUENT DATA BASES ARE TO NUMBERED IN SEQUENCE AND INCREMENTED BY 1.

DATA BASE INDICATOR (REFER TO 2.2.03.01)

DATA BASE NAME EXAMPLE

E03DB

E - DIVISION, EDUCATION

03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES

DB - INDICATOR, PRODUCTION DATA BASE

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.05.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: DATA BASE DATA SET NAMES

ALL DATA BASE DATA SET NAMES WILL CONSIST OF EIGHT ALPHANUMERIC CHARACTERS IN THE FOLLOWING SEQUENCE;

DATA BASE DATA BASE DATA BASE DATA BASE DSN DATA BASE DSN

PREFIX QUALIFIER NAME INDICATOR NUMBER

IMSVS DNNII XX N

DATA BASE PREFIX - THE DATA BASE PREFIX IS ALWAYS IMSVS. THIS IS THE USER GROUP THAT OWNS THE DATA BASE.

DATA BASE QUALIFIER - THE DATA BASE QUALIFIER IS ALWAYS A '.'.

DATA BASE NAME (REFER TO 2.3.04.01)

DSN INDICATOR - THIS INDICATOR WILL ALWAYS CONTAIN 'DS'.

DSN NUMBER - ONE NUMERIC CHARACTER. THE FIRST DATA SET FOR A PARTICULAR DATA BASE WILL BE LABELED 1. SUBSEQUENT DATA SETS FOR A GIVEN DATA BASE WILL BE NUMBERED IN SEQUENCE AND INCREMENTED BY 1.

DATA BASE DATASET NAME MSVS.E03DBDS1 IMSVS - THE OWNER OF THE DATA BASE - THE DATA BASE QUALIFIER

E - DIVISION, EDUCATION

03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES

DB - INDICATOR, PRODUCTION DATA BASE

DS - DATA BASE DATASET NAME INDICATOR, 'DS' IS USED FOR PRODUCTION AND TEST DATA BASES

1 - DATA BASE DATASET NUMBER, THE FIRST DATA SET IN THIS DATA BASE

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.06.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: DATA BASE DATA DEFINITION (DD) NAMES

DATA BASE DD NAMES CONSIST OF EIGHT CHARACTERS IN THE FOLLOWING SEQUENCE:

DATA BASE DATA BASE DATA BASE

NAME INDICATOR DD NUMBER

DNNII DD N

DATA BASE NAME (REFER TO 2.3.04.01)

DATA BASE INDICATOR - THE CHARACTERS 'DD' WILL TAKE UP THE SIXTH AND SEVENTH POSITIONS TO INDICATE A DD STATEMENT.

DATA BASE DD NUMBER - THE FIRST DD NAME FOR A PARTICULAR DATA BASE WILL BE LABELED 1. SUBSEQUENT DD NAMES FOR A GIVEN DATA BASE WILL BE NUMBERED IN SEQUENCE.

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.07.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: MESSAGE FORMAT SERVICES FORMAT NAMES

MESSAGE OUTPUT DESCRIPTOR AND MESSAGE INPUT DESCRIPTOR NUMBERS ARE EIGHT CHARACTERS IN LENGTH AND WILL BE COMPOSED OF THE FIRST SIX CHARACTERS OF THE PROGRAM IDENTIFICATION NUMBER IN THE LEFT MOST POSITIONS. THE SEVENTH POSITION WILL CONTAIN THE CHARACTER 'I' FOR INPUT DESCRIPTORS AND THE CHARACTER 'O' (OH, NOT ZERO) FOR OUTPUT DESCRIPTORS. THE EIGHTH POSITION WILL CONTAIN A SEQUENCE NUMBER, BEGINNING WITH ONE. ADDITIONAL DESCRIPTORS WILL HAVE THE SEQUENCE NUMBER INCREMENTED BY ONE.

DEVICE INPUT FORMATS AND DEVICE OUTPUT FORMATS ARE SIX CHARACTERS IN LENGTH. IF A PROGRAM REQUIRES ONLY A SINGLE FORMAT (DIF/DOF) IT WILL USE AS IDENTIFICATION THE FIRST SIX CHARACTERS OF THE PROGRAM IDENTIFICATION NUMBER.

JOBS HAVING MORE THAN ONE FORMAT WILL REQUIRE A SPECIAL NUMBER FOR ADDITIONAL FORMATS. FORMAT NUMBERS WILL BE ASSIGNED AND LOGGED BY THE STANDARDS DEPARTMENT ACCORDING TO THE FOLLOWING: DIGITS ONE THROUGH THREE OF THE FORMAT NUMBER WILL BE COMPOSED OF THE FIRST THREE DIGITS OF THE PROGRAM NUMBER. DIGIT FOUR WILL CONTAIN THE CHARACTER 'F' TO DISTINGUISH THE FORMAT NUMBER FROM ANOTHER PROGRAM NUMBER. THE LAST TWO DIGITS WILL CONTAIN A SEQUENCE NUMBER.

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.07.02

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED: 07/13/88

SUBJECT: MESSAGE FORMAT SERVICES FORMAT NAMES

THERE ARE FOUR TYPES OF MFS CONTROL BLOCKS NEEDED FOR FORMATTING INPUT AND OUTPUT MESSAGES THAT NEED TO BE CONSIDERED WHEN ESTABLISHING FORMAT NAMES.

2. DEVICE OUTPUT FORMATS (DOF) - DESCRIBES HOW MFS WILL FORMAT MESSAGES FOR EACH DEVICE TYPE THAT THE PROGRAM WILL COMMUNICATE WITH.

3. DEVICE INPUT FORMATS (DIF) - DESCRIBES THE FORMAT OF MESSAGES MFS RECEIVES FROM EACH OF THE DEVICES A PROGRAM COMMUNICATES WITH.

4. MESSAGE INPUT DESCRIPTOR (MID) - DESCRIBES THE FORMAT OF A MESSAGE MFS SENDS TO AN APPLICATION PROGRAM.

A PROGRAM NORMALLY REQUIRES A SINGLE FORMAT FOR BOTH INPUT AND OUTPUT. THIS FORMAT CAN THEN BE USED AS BOTH THE DIF AND DOF AND WILL BE REFERRED TO AS A DIF/DOF. THE DIF/DOF WILL USE AS IDENTIFICATION THE FIRST SIX CHARACTERS OF THE PROGRAM NAME AND WILL BE IN THE FORM DAANNN (REFER TO 2.3.02.01).

PROGRAMS HAVING MORE THAN ONE FORMAT WILL REQUIRE A SPECIAL NUMBER FOR ADDITIONAL FORMATS. FORMAT NUMBERS WILL BE ASSIGNED AND LOGGED BY THE STANDARDS DEPARTMENT ACCORDING TO THE FOLLOWING: DIGITS ONE THROUGH THREE OF THE FORMAT NUMBER WILL BE COMPOSED OF THE FIRST THREE DIGITS OF THE PROGRAM NUMBER. DIGIT FOUR WILL CONTAIN THE CHARACTER 'F' TO DISTINGUISH THE FORMAT NUMBER FROM ANOTHER PROGRAM NUMBER. THE LAST TWO DIGITS WILL CONTAIN A SEQUENCE NUMBER.

ALTHOUGH THERE ARE A NUMBER OF PROGRAMS THAT HAVE MULTIPLE FORMATS THE POSSIBILITY EXISTS FOR DUPLICATION OF NUMBERS IF THE INSTRUCTIONS IN THE PREVIOUS PARAGRAPH ARE NOT FOLLOWED. THE DATA BASE ADMINISTRATION GROUP HIGHLY RECOMMENDS THE USE OF THE OPERATOR LOGICAL PAGING FEATURE OF MFS ALONG WITH THE USE OF MULTIPLE LPAGES AND DPAGES.

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.07.03

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED: 07/13/88

MESSAGE OUTPUT DESCRIPTORS AND MESSAGE INPUT DESCRIPTORS WILL BE NUMBERED IN THE FOLLOWING MANNER;

PROGRAM NUMBER DESCRIPTOR TYPE SEQUENCE

DAANNN I OR O N

PROGRAM NUMBER - THE FIRST SIX CHARACTERS OF THE PROGRAM IDENTIFICATION NUMBER (REFER TO 2.2.02.01)

DESCRIPTOR TYPE - ONE ALPHABETIC CHARACTER THAT DESCRIBES THIS FORMAT AS A MESSAGE OUTPUT DESCRIPTOR OR A MESSAGE INPUT DESCRIPTOR. THE ALLOWABLE CHARACTERS ARE:

O - MESSAGE OUTPUT DESCRIPTOR

SEQUENCE - ONE NUMERIC CHARACTER. THE FIRST MID OR MOD IN A FORMAT IS TO BE NUMBERED 1. SUBSEQUENT MIDS OR MODS ARE TO NUMBERED IN SEQUENCE AND INCREMENTED BY 1. DEVICE INPUT FORMATS (DIF) AND DEVICE OUTPUT FORMATS (DOF) ARE NUMBERED IN THE FOLLOWING MANNER;

FIRST DIF/DOF		SUBSEQUENT DIF	/DOF
	PROGRAM NUMBER	TYPE	SEQUENCE
DAANNN	DAA	F	NN

FIRST DIF/DOF - THE DIF/DOF NUMBER WILL ALWAYS BE THE FIRST SIX CHARACTERS OF THE PROGRAM IDENTIFICATION NUMBER. REFER TO 2.3.02.01.

SUBSEQUENT DIF/DOF PROGRAM NUMBER - SUBSEQUENT DIF/DOFS WILL CONTAIN THE FIRST THREE CHARACTERS OF THE PROGRAM IDENTIFICATION NUMBER. REFER TO 2.3.02.01.

TYPE - THE TYPE WILL ALWAYS CONTAIN THE CHARACTER 'F' FOR EACH ADDITIONAL FORMAT AFTER THE FIRST.

SEQUENCE - TWO NUMERIC CHARACTERS. THE FIRST FORMAT IN A SERIES WILL BEGIN WITH 01. SUBSEQUENT FORMATS WILL BE INCREMENTED BY 1.

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.08.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: DATA BASE SEGMENT NAMES

EACH SEGMENT WITHIN A DATA BASE WILL CONSIST OF 8 ALPHA NUMERIC CHARACTERS IN THE FOLLOWING SEQUENCE:

DIVISION DATA BASE DATA BASE DATA BASE

NUMBER SEGMENT NUMBER FIELD NUMBER

D NN SS OR II 000

THE FORM FOR A HIDAM, HDAM, OR OTHER DATABASE WILL BE 'DNNSS000'. THE FORM FOR A PRIMARY INDEX, A SECONDARY INDEX OR A GSAM DATA BASE WILL BE 'DNNII000.

DIVISION ()REFER TO 2.2.01.01

DATA BASE NUMBER (REFER TO 2.3.04.01)

DATA BASE SEGMENT NUMBER - THE DATA BASE SEGMENT NUMBER CONSIST OF TWO ALPHANUMERIC CHARACTERS INDICATING THE HIERARCHICAL POSITION OF THE SEGMENT IN THE DATA BASE. THE FIRST SEGMENT (ROOT SEGMENT) WILL CONTAIN '00' AND SUCCEEDING SEGMENTS WILL BE NUMBERED IN INCREMENTS OF 5 TO ALLOW FOR FUTURE INSERTION OF SEGMENTS. IF THE NUMBER OF SEGMENTS IS SO LARGE AS TO MAKE NUMBERING BY 5 IMPRACTICAL, A LESSER INCREMENT MAY BE USED.

THE ROOT SEGMENT OF A PRIMARY INDEX FOR A HIDAM DATA BASE WILL USE 'DX' FOR THE DATA BASE SEGMENT NUMBER, AS SPECIFIED IN THE PRODUCTION LISTING OF THE DATA BASE TYPE INDICATOR (2.2.03.01).

THE ROOT SEGMENT FOR A SECONDARY DATA BASE OR GSAM DATA BASE WILL USE THE SAME TWO CHARACTERS AS SPECIFIED IN THE PRODUCTION LISTING OF THE DATA BASE TYPE INDICATOR (2.2.03.01). THE DATA BASE TYPE INDICATORS IN THE TEST COLUMN MAY NOT BE USED IN ANY DATA BASE SEGMENT NUMBERS.

DATA BASE FIELD NUMBER - THE NUMERIC CHARACTERS '000' (ZERO ZERO ZERO) WILL ALWAYS BE USED IN POSITIONS SIX THRU EIGHT WHEN DEFINING DATA BASE SEGMENT NAMES.

DATA BASE SEGMENT NAME EXAMPLES 1. E0300000 - ROOT SEGMENT

E - DIVISION, EDUCATION 03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES 00 - DATA BASE SEGMENT NUMBER, '00' INDICATES THAT THIS IS A ROOT SEGMENT 000 - DATA BASE FIELD NUMBER, ALWAYS '000'

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.08.02

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

2. E0305000 - CHILD SEGMENT

E - DIVISION, EDUCATION

03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES

05 - DATA BASE SEGMENT NUMBER, '05' INDICATES THAT THIS IS NOT

A ROOT SEGMENT BUT IS A CHILD IN THE DATA BASE STRUCTURE.

000 - DATA BASE FIELD NUMBER, ALWAYS '000'

3. E03DX000 - ROOT SEGMENT IN A PRIMARY INDEX

E - DIVISION, EDUCATION

03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES

DX - DATA BASE SEGMENT NUMBER, 'DX' INDICATES THAT THIS IS A

ROOT SEGMENT IN A PRIMARY INDEX FOR A HIDAM DATA BASE.

000 - DATA BASE FIELD NUMBER, ALWAYS '000'

4. E03D1000 - ROOT SEGMENT IN A SECONDARY INDEX

E - DIVISION, EDUCATION

03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES

D1 - DATA BASE SEGMENT NUMBER, 'D1' INDICATES THAT THIS IS A

ROOT SEGMENT IN THE FIRST SECONDARY INDEX OF A DATA BASE.

000 - DATA BASE FIELD NUMBER, ALWAYS '000'

5. E03GS000 - ROOT SEGMENT IN A GSAM DATA BASE

E - DIVISION, EDUCATION

03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES

GS - DATA BASE SEGMENT NUMBER, 'GS' INDICATES THAT THIS IS A

ROOT SEGMENT IN A GSAM DATA BASE

000 - DATA BASE FIELD NUMBER, ALWAYS '000'

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.09.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED: 02/22/96

SUBJECT: DATA BASE FIELD NAMES

A DATA BASE FIELD NAME MUST BE ASSOCIATED WITH EVERY COBOL ITEM THAT IS EITHER A GROUP ITEM, AN ELEMENTARY ITEM THAT IS NOT PART OF A GROUP ITEM, AND ANY ITEM THAT MAKES UP A SEGMENT'S KEY. THIS IS A MINIMUM REQUIREMENT FOR CONSTRUCTING THE PANVALET "INCLUDE" THAT WILL DESCRIBE THE SEGMENT. SEE PAGE STDS 4.3.02.01 FOR AN EXPLANATION OF A SEGMENT "INCLUDE". A UNIQUE SEQUENCE FIELD MUST BE DEFINED FOR THE ROOT SEGMENT OF A HISAM, HIDAM AND THE PRIMARY INDEX OF A HIDAM DATA BASE. ANY FIELDS USED BY AN APPLICATION PROGRAM IN A DL/I CALL SEGMENT SEARCH ARGUMENT MUST ALSO BE DEFINED IN THE DATA BASE DEFINITION.

EACH FIELD WITHIN A SEGMENT WILL CONSIST OF 8 ALPHA NUMERIC CHARACTERS IN THE FOLLOWING SEQUENCE:

DIVISION DATA BASE DATA BASE DATA BASE

NUMBER SEGMENT NUMBER FIELD NUMBER

D NN SS OR II FFF

THE FORM FOR A FIELD IN A HIDAM, HDAM, OR OTHER DATABASE WILL BE 'DNNSSFFF'. THE FORM FOR A FIELD IN A PRIMARY INDEX, A SECONDARY INDEX OR A GSAM DATA BASE WILL BE 'DNNIIFFF.

DIVISION (REFER TO 2.2.01.01)

DATA BASE NUMBER (REFER TO 2.3.04.01)

DATA BASE SEGMENT NUMBER (REFER TO 2.3.08.01)

DATA BASE FIELD NUMBER

1. FIELDS WITHIN A SEGMENT
THE FIRST FIELD WITHIN A SEGMENT WILL BEGIN NUMBERING WITH '010'
AND SUCCEEDING FIELDS WILL BE INCREMENTED BY 5.

2. KEY/SEQUENCE FIELDS
KEY/SEQUENCE FIELDS ARE ASSIGNED BY THE DATA BASE ADMINISTRATION
GROUP AT THE TIME THE DATA BASE DEFINITION IS PERFORMED. THIS
FIELD WILL CONTAIN 'SEQ'

3. INDEXED DATA FIELD OF A SECONDARY INDEX
THE INDEXED DATA FIELD SPECIFIES THE NAME OF THE SEARCH FIELDS OF
AN INDEX SOURCE SEGMENT AND IS REPRESENTED IN THE INDEX TARGET
SEGMENT. THIS FIELD MAY BE USED TO QUALIFY SSAS OF CALLS WHEN THE
SECONDARY PROCESSING SEQUENCE IS SPECIFIED IN A PCB. THIS FIELD
WILL CONTAIN 'X01' FOR THE FIRST INDEXED DATA FIELD DEFINED IN A
SEGMENT AND SUBSEQUENT FIELDS WILL BE INCREMENTED BY ONE ('X02',
'X03').

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.09.02

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

DATA BASE FIELD NAME EXAMPLES:

1. E0300010 - THE FIRST FIELD DEFINED IN ROOT SEGMENT E0300000

E - DIVISION, EDUCATION

03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES

00 - DATA BASE SEGMENT NUMBER, '00' INDICATES THAT THIS IS A ROOT SEGMENT

010 - DATA BASE FIELD NUMBER

2. E0305010 - THE FIRST FIELD DEFINED IN THE E0305000 SEGMENT

E - DIVISION, EDUCATION

03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES

00 - DATA BASE SEGMENT NUMBER, '05' INDICATES THAT THIS IS NOT A ROOT SEGMENT BUT IS A CHILD IN A DATA BASE.

010 - DATA BASE FIELD NUMBER

3. E0300SEQ - THE KEY SEQUENCE FIELD IN ROOT SEGMENT E0300000

E - DIVISION, EDUCATION

03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES

00 - DATA BASE SEGMENT NUMBER, '00' INDICATES THAT THIS IS A ROOT SEGMENT

SEQ - DATA BASE FIELD NUMBER, THE 'SEQ' INDICATES THAT THIS FIELD IS A SEQUENCE FIELD AND MAY INCLUDE ONE OR MORE FIELDS

4. E0300X01 - AN INDEXED DATA FIELD DEFINED IN ROOT SEGMENT

E0300000

E - DIVISION, EDUCATION

03 - DATA BASE NUMBER, 03 IN THE EDUCATION SERIES

00 - DATA BASE SEGMENT NUMBER, '00' INDICATES THAT THIS IS A ROOT SEGMENT

X01 - DATA BASE FIELD NUMBER, THE 'X01' INDICATES THAT THIS FIELD IS THE FIRST INDEXED DATA FIELD DEFINED IN THE

E0300000 ROOT SEGMENT

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.10.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED: 04/05/90

SUBJECT: FILE IDENTIFICATION

FILE IDENTIFICATION IS ACCOMPLISHED BY AFFIXING ADDITIONAL CHARACTERS TO THE BEGINNING AND/OR END OF THE PROGRAM IDENTIFICATION NUMBER OR THE JOB IDENTIFICATION NUMBER, THUS PROVIDING UNIQUE IDENTIFICATION FOR FILES OUTPUTED FROM A COMPUTER RUN. THERE ARE FOUR TYPES OF FILES THAT CAN BE DEFINED USING THIS SECTION. THE FOLLOWING 3 SUFFIXES SHOULD NEVER BE USED: .LINK, .LINKLIST, .OUTLIST.

1. FILES PRODUCED BY KEYING OR EAM OPERATIONS (INCLUDING OPTICAL SCANNING FILES): THESE FILES WILL BE IDENTIFIED BY HAVING ADDITIONAL CHARACTERS APPENDED ONLY TO THE END OF THE JOB IDENTIFICATION NUMBER AND WILL BE IN THE FORM AS LISTED BELOW.

JOB SEP FILE FILE SEP OPTIONAL

ID TYPE NUMBER ID

DAANNNTF T NN NNNNNNNN

2. TEMPORARY FILES AND TEMPORARY VSAM FILES. THESE FILES ARE CREATED AND DELETED IN THE SAME JOB STREAM AND WILL BE IDENTIFIED BY HAVING ADDITIONAL CHARACTERS APPENDED TO THE BEGINNING AND TO THE END OF THE PROGRAM IDENTIFICATION NUMBER. THE FILES WILL BE IN THE FORM AS LISTED BELOW.

Group Sep Program Sep File File Sep Option

ID ID Type Number ID

GGGGG DAANNNTF T NN NNNNNNNN

3. PERMANENT FILES (EXCEPT VSAM). THESE FILES ARE CREATED IN A JOB STEP AND RETAINED FOR USE BY OTHER JOBS OR AS ARCHIVAL INFORMATION. ADDITIONAL CHARACTERS ARE APPENDED TO THE BEGINNING AND TO THE END OF THE PROGRAM IDENTIFICATION NUMBER. THE FILES WILL BE IN THE FORM AS LISTED BELOW.

Group Sep Program Sep File File Sep Option GDC

ID ID Type Number ID ID

GGGGG DAANNNTF T NN NNNNNNNN XXXX

4. PERMANENT VSAM FILES. THESE FILES ARE CREATED IN A JOB STEP AND RETAINED FOR USE BY OTHER JOBS OR AS ARCHIVAL INFORMATION. THE SPECIFIC VOLUME ON WHICH THE DATASET IS TO BE PLACED MUST BE OBTAINED FROM THE SYSTEMS PROGRAMMING GROUP, AND IS RECORDED IN THE IDCAMS STATEMENT DEFINING THE DATASET. ADDITIONAL CHARACTERS ARE APPENDED TO THE BEGINNING AND TO THE END OF THE PROGRAM IDENTIFICATION NUMBER. THE FILES WILL BE IN THE FORM AS LISTED BELOW.

Group Sep Program Sep File File Sep Option Sep Vsam

ID ID Type Number ID ID

GGGGG DAANNNTF T NN NNNNNNNN YYYY

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.10.02

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED: 04/05/90

SUBJECT: FILE IDENTIFICATION

JOB ID (REFER TO 2.3.03.01)

PROGRAM ID (REFER TO 2.3.02.01)

GROUP ID (REFER TO 2.2.06.01)

OPTIONAL ID - THIS IS AN OPTIONAL FOURTH LEVEL QUALIFIER CONSISTING OF UP TO EIGHT BYTES OF USER DEFINED INFORMATION, THAT CAN BE USED TO FURTHER ENHANCE THE DEFINITION OF A DATASET NAME. E.G. FY8889, SCANMBR

SEP -THE SEPARATOR IS ALWAYS A '.'.

FILE TYPE - ONE ALPHA CHARACTER WHICH REPRESENTS THE OUTPUT MEDIUM USED BY THE FILE.

'D' DISK (SYSDA/HSMDA/DASD) *

'T' TAPE (NON-VSAM) *

'M' SYSTEM STORAGE (PERMANENT DATA SET EXCEPT FOR TAPE) *

* - REFER TO 5.1.04.01 FOR UNIT= SPECIFICATIONS

FILE NUMBER - TWO NUMERIC CHARACTERS ASSIGNED SEQUENTIALLY TO THOSE FILES PRODUCED BY A PROGRAM OR JOB. THE FIRST FILE BEGINS WITH '01' AND SUBSEQUENT FILES ARE INCREMENTED BY ONE. GDG/NON-GDG ID

GDG (GENERATION DATA GROUP) IS THE METHOD WHICH COMPUTER SERVICES EMPLOYS TO MAINTAIN MULTIPLE GENERATIONS (LEVELS) OF A DATA SET. REFER TO 5.4.12.01 FOR AN EXPLANATION OF USING IDCAMS TO CREATE THE BASE RECORD NEEDED FOR A GDG. ALSO REFER TO 5.1.04.03 FOR INFORMATION IN REGARD TO DCB PARAMETER NEEDED FOR GDG'S.

1) (+01) - ADDED TO THE END OF THE DATA SET NAME AFTER THE FILE TYPE AND THE FILE NUMBER TO DESIGNATE CREATION OF A GDG. IT IS NOT SEPARATED BY A QUALIFIER. IT WILL REMAIN (+01) WHENEVER THE DATA SET IS REFERENCED BY ANOTHER STEP IN THE SAME JOB THAT CREATED THE DATA SET.

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.10.03

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED: 04/05/90

SUBJECT: FILE IDENTIFICATION

2) (+00) OR (-XX) - ADDED TO THE END OF THE DATA SET NAME AFTER THE FILE TYPE AND THE FILE NUMBER TO DESIGNATE THAT THE DATA SET BEING REFERENCED IS A GDG. (+00) REFERS TO THE MOST CURRENT VERSION, WHILE ANY (-XX) REFERS TO PREVIOUS CREATIONS. 'XX' IS A NUMERIC VALUE STARTING AT 01 AND CAN BE INCREASED BY ONE UNTIL THE LIMIT OF THE GDG IS MET.

3) NGDG - THESE CHARACTERS ARE ADDED TO THE END OF THE DATA SET NAME, PRECEDED BY A SEPARATOR, TO DESIGNATE THAT THE DATA SET IS A NON-GDG. VSAM ID THE VSAM ID IS USED TO IDENTIFY THE VARIOUS COMPONENTS OF VSAM DATA SETS. THE VALID QUALIFIERS ARE AS FOLLOWS:

1) VSAM - THESE CHARACTERS ARE APPENDED TO THE END OF THE DATA SET NAME TO IDENTIFY THE CLUSTER PORTION OF THE VSAM DATA SET.

2) DATA - THESE CHARACTERS ARE APPENDED TO THE END OF THE DATA SET NAME TO IDENTIFY THE INDEX PORTION OF THE VSAM DATA SET.

3) INDEX - THESE CHARACTERS ARE APPENDED TO THE END OF THE DATA SET NAME TO IDENTIFY THE INDEX PORTION OF THE VSAM DATA SET.

4) AIXN - THESE CHARACTERS ARE APPENDED TO THE END OF THE DATA SET NAME TO IDENTIFY THE ALTERNATE INDEX PORTION OF THE VSAM DATA SET. THE 'N' SPECIFIES THE NUMBER OF THE ALTERNATE INDEX, STARTING AT 1 AND INCREMENTED BY ONE FOR EACH SUCCESSIVE INDEX.

EXAMPLES:

FOR REFERENCING A DATA SET IN THE JOB WHERE IT WAS CREATED:

1) GDG

CPROD.C60990CA.M01(+01)

2) NON-GDG

CPROD.C60990CA.M01.NGDG

3) VSAM

CPROD.C60990CA.M01.VSAM

FOR REFERENCING THAT DATA SET IN SUBSEQUENT JOBS OR AFTER IT HAS

BEEN CYCLED (ASSUMING THE MOST CURRENT VERSION IS DESIRED):

1) GDG

CPROD.C60990CA.M01(+00)

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.10.04

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED: 04/05/90

SUBJECT: FILE IDENTIFICATION

2) NON-GDG

CPROD.C60990CA.M01.NGDG

3) VSAM

CPROD.C60990CA.M01.VSAM

FOR REFERENCING A DATA SET THAT CONTAINS A FOURTH LEVEL OPTIONAL ID

QUALIFIER.

1) GDG

CPROD.C60990CA.M01.SPECDATA(+01)

2) NON-GDG

CPROD.C60990CA.M01.SPECDATA.NGDG

3) VSAM

CPROD.C60990CA.M01.SPECDATA.VSAM

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.11.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: STORAGE AREAS

PROGRAM SAVE AREAS (INCLUDING PCB'S, WORK AREAS, AND FDS) THAT WILL BE STORED ON TEST OR PRODUCTION PANVALET LIBRARIES AND WILL BE INCLUDED IN ONE OR MORE PROGRAMS, THRU THE USE OF THE PANVALET COMMAND '++INCLUDE' WILL BE NAMED ACCORDING TO THE FOLLOWING FORMAT:

DIVISION APPLICATION INDICATOR SEQUENCE

NUMBER

D AA SA NNN

DIVISION (REFER TO 2.2.01.01)

APPLICATION (REFER TO 2.2.02.01)

INDICATOR - THIS INDICATOR WILL ALWAYS CONTAIN 'SA'.

SEQUENCE NUMBER - THREE NUMERIC CHARACTERS. THE FIRST PANVALET STORAGE AREA WITHIN A PARTICULAR DIVISION AND APPLICATION WILL BE LABELED 001 (ZERO ZERO ONE). SUBSEQUENT STORAGE AREAS, WITHIN THE SAME DIVISION AND APPLICATION, WILL BE NUMBERED IN SEQUENCE AND WILL BE INCREMENTED BY ONE.

STORAGE AREA EXAMPLE:

F55SA001

F - DIVISION, FINANCIAL

55 - APPLICATION, PAYROLL

SA - INDICATOR, THIS IS A PANVALET STORAGE AREA

001 - SEQUENCE NUMBER, THIS IS THE FIRST STORAGE AREA

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.12.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: PROCEDURE ROUTINES

PROCEDURE ROUTINES ARE PRE-WRITTEN SOURCE CODE MODULES THAT WILL BE STORED ON TEST OR PRODUCTION PANVALET LIBRARIES AND WILL BE INCLUDED IN ONE OR MORE PROGRAMS, THRU THE USE OF THE PANVALET COMMAND '++INCLUDE', WILL BE NAMED ACCORDING TO THE FOLLOWING FORMAT:

DIVISION APPLICATION INDICATOR SEQUENCE

NUMBER

D AA RN NNN

DIVISION (REFER TO 2.2.01.01)

APPLICATION (REFER TO 2.2.02.01)

INDICATOR - THIS INDICATOR WILL ALWAYS CONTAIN 'RN'.

SEQUENCE NUMBER THREE NUMERIC CHARACTERS. THE FIRST PANVALET PROCEDURE ROUTINE WITHIN A PARTICULAR DIVISION AND APPLICATION WILL BE LABELED 001 (ZERO ZERO ONE). SUBSEQUENT PROCEDURE ROUTINES, WITHIN THE SAME DIVISION AND APPLICATION, WILL BE NUMBERED IN SEQUENCE AND WILL BE INCREMENTED BY ONE.

PROCEDURE ROUTINES EXAMPLE:

F55RN001

F - DIVISION, FINANCIAL

55 - APPLICATION, PAYROLL

RN - INDICATOR, THIS IS A PANVALET PROCEDURE ROUTINE

001 - SEQUENCE NUMBER, THIS IS THE FIRST PROCEDURE ROUTINE

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.13.01

DATE: 11/06/85

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: PANVALET NUMBERING REQUIREMENTS

DATA SETS PLACED ON EITHER THE TEST OR PRODUCTION PANVALET LIBRARIES WILL BE REFERENCED BY NAMES ASSIGNED ACCORDING TO THE FOLLOWING NAMING CONVENTION. 1. PROGRAMS: THE EIGHT DIGIT PROGRAM NUMBER ASSIGNED BY THE STANDARDS DEPARTMENT. (SEE SECTION 2.3.02.01)

EXAMPLE: C60890CA

E40540CA

2. MESSAGE FORMATS: THE NAME OF THE FIRST MESSAGE OUTPUT DESCRIPTOR WILL APPLY TO ALL INPUT DESCRIPTORS, OUTPUT DESCRIPTORS, AND FORMATS IN A SINGLE JOB. (SEE SECTION 2.3.07.01)

EXAMPLE: F5542001

E4054001

3. DATA BASE SEGMENT LAYOUTS: USE THE 8 CHARACTER SEGMENT NAME ASSIGNED DURING DATA BASE DEFINITION FOR THE FIRST DEFINITION OF A SEGMENT (SEE SECTION 2.3.08.01). ADDITIONAL DEFINITIONS OF A SEGMENT WILL USE THE FIRST 5 CHARACTERS OF THE SEGMENT NAME PLUS A THREE CHARACTER ALPHABETIC IDENTIFIER TO BE ASSIGNED BY STANDARDS.

EXAMPLE: E0200000

E0200RTE

4. STORAGE AREAS (INCLUDING PCB'S AND FD'S): USE THE EIGHT CHARACTER NAME ASSIGNED BY THE STANDARDS DEPARTMENT FOR STORAGE AREAS (SEE SECTION 2.3.11.01).

EXAMPLES: E30SA001

E20SA025

5. PROCEDURE ROUTINES (TO BE INCLUDED AS SOURCE OF ANOTHER PROGRAM): THESE NUMBERS WILL BE ASSIGNED BY STANDARDS (SEE SECTION 2.3.12.01).

EXAMPLES: P30RN001

E20RN025

6. DB2 STORAGE AREAS (TABLES AND VIEWS) SEE PAGES 2.3.17.01 FOR TABLES AND PAGE 2.3.19.01 FOR VIEWS.

EXAMPLES: E61TB001

E61VW001

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.14.01

DATE: 06/19/86

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: REPORT DISTRIBUTION

EACH REPORT THAT IS PRODUCED IN A PROGRAM MUST BE ASSIGNED A REPORT DISTRIBUTION NUMBER. THIS NUMBER IS TO BE ENTERED ON THE REPORT DISTRIBUTION SPECIFICATION FORM (7.2.01.01) IN ORDER FOR OPERATIONS DISTRIBUTION TO OBTAIN THE CORRECT INFORMATION FOR BURSTING, TRIMMING, DECOLLATION, AND THE DESTINATION OF EACH COPY OF THE REPORT.

ALL REPORTS THAT WILL BE PRODUCED IN A PRODUCTION ENVIRONMENT MUST HAVE A UNIQUE REPORT DISTRIBUTION NUMBER ASSIGNED IN THE FOLLOWING SEQUENCE:

DIVISION APPLICATION JOB TYPE APPROXIMATE

NUMBER FREQUENCY

D AA NNN T F

DIVISION (REFER TO 2.2.01.01)

APPLICATION (REFER TO 2.2.02.01)

REPORT NUMBER - THREE NUMERIC CHARACTERS. THE FIRST REPORT IN A DIVISION, APPLICATION AND JOB TYPE IS TO BE NUMBERED 001. SUBSEQUENT REPORTS ARE TO BE NUMBERED IN SEQUENCE AND INCREMENTED BY 1.

TYPE (REFER TO 2.2.07.01)

APPROXIMATE FREQUENCY (REFER TO 2.2.05.01)

REPORT DISTRIBUTION NUMBER EXAMPLE

E300068A

E - DIVISION, EDUCATION

30 - APPLICATION, GRADES

006 - REPORT NUMBER 006 IN THE GRADES APPLICATION SERIES

8 - JOB TYPE, REPORT DISTRIBUTION

A - APPROXIMATE FREQUENCY, AS NEEDED

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.15.01

DATE: 1/31/95

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: DB2 DATABASE

DB2 DATABASES WILL BE NAMED ACCORDING TO THE FOLLOWING FORMAT:

DIVISION APPLICATION DB2 OBJECT SEQUENCE

INDICATOR NUMBER

D AA DB NNN

THIS IS THE NAME THAT WILL BE USED IN THE CREATE DATABASE STATEMENT.

DIVISION (REFER TO 2.2.01.01)

APPLICATION (REFER TO 2.2.02.01)

INDICATOR - THIS INDICATOR WILL ALWAYS BE A 'DB'.

SEQUENCE NUMBER - THREE NUMERIC CHARACTERS. THE FIRST DB2 DATABASE NAME WITHIN A PARTICULAR DIVISION AND APPLICATION WILL BE LABELED 001 (ZERO ZERO ONE). SUBSEQUENT DB2 DATABASES, WITHIN THE SAME DIVISION AND APPLICATION, WILL BE NUMBERED IN SEQUENCE AND WILL BE INCREMENTED BY ONE.

DB2 DATABASE EXAMPLE: F55DB001

F - DIVISION, FINANCIAL

55 - APPLICATION, PAYROLL

DB - INDICATOR, THIS IS A DB2 DATABASE

001 - SEQUENCE NUMBER

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.16.01

DATE: 1/31/95

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: DB2 TABLESPACES

DB2 TABLESPACES WILL BE NAMED ACCORDING TO THE FOLLOWING FORMAT:

DIVISION APPLICATION DB2 OBJECT SEQUENCE

INDICATOR NUMBER

D AA TS NNN

THIS IS THE NAME THAT WILL BE USED IN THE CREATE TABLESPACE
STATEMENT.

DIVISION (REFER TO 2.2.01.01)

APPLICATION (REFER TO 2.2.02.01)

INDICATOR - THIS INDICATOR WILL ALWAYS BE A 'TS'.

SEQUENCE NUMBER - THREE NUMERIC CHARACTERS. THE FIRST DB2 TABLESPACE NAME WITHIN A PARTICULAR DIVISION AND APPLICATION WILL BE LABELED 001 (ZERO ZERO ONE). SUBSEQUENT DB2 TABLESPACES, WITHIN THE SAME DIVISION AND APPLICATION, WILL BE NUMBERED IN SEQUENCE AND WILL BE INCREMENTED BY ONE.

DB2 TABLESPACE EXAMPLE: F55TS001

F - DIVISION, FINANCIAL

55 - APPLICATION, PAYROLL

TS - INDICATOR, THIS IS A DB2 TABLESPACE

001 - SEQUENCE NUMBER

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.17.01

DATE: 1/31/95

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: DB2 TABLES

DB2 TABLES WILL BE STORED ON TEST OR PRODUCTION PANVALET LIBRARIES AND WILL BE INCLUDED IN ONE OR MORE PROGRAMS, THROUGH THE USE OF THE PANVALET COMMAND '++INCLUDE'. DB2 TABLES WILL BE NAMED ACCORDING TO THE FOLLOWING FORMAT:

DIVISION APPLICATION DB2 OBJECT SEQUENCE

INDICATOR NUMBER

D AA TB NNN

THIS IS ALSO THE NAME USED IN THE CREATE TABLE STATEMENT.

DIVISION (REFER TO 2.2.01.01)

APPLICATION (REFER TO 2.2.02.01)

INDICATOR - THIS INDICATOR WILL ALWAYS BE A 'TB'.

SEQUENCE NUMBER - THREE NUMERIC CHARACTERS. THE FIRST DB2 TABLE NAME WITHIN A PARTICULAR DIVISION AND APPLICATION WILL BE LABELED 001 (ZERO ZERO ONE). SUBSEQUENT DB2 TABLES, WITHIN THE SAME DIVISION AND APPLICATION, WILL BE NUMBERED IN SEQUENCE AND WILL BE INCREMENTED BY ONE.

DB2 TABLE EXAMPLE:

F55TB001

F - DIVISION, FINANCIAL

55 - APPLICATION, PAYROLL

TB - INDICATOR, THIS IS A PANVALET DB2 TABLE

001 - SEQUENCE NUMBER

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.18.01

DATE: 1/31/95

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: DB2 INDEXES

DB2 INDEXES WILL BE NAMED ACCORDING TO THE FOLLOWING FORMAT:

DIVISION APPLICATION DB2 OBJECT SEQUENCE

INDICATOR NUMBER

D AA IX NNN

THIS IS THE NAME THAT WILL BE USED IN THE CREATE INDEX STATEMENT.

DIVISION (REFER TO 2.2.01.01)

APPLICATION (REFER TO 2.2.02.01)

INDICATOR - THIS INDICATOR WILL ALWAYS BE AN 'IX'.

SEQUENCE NUMBER THREE NUMERIC CHARACTERS. THE FIRST DB2 INDEX NAME WITHIN A PARTICULAR DIVISION AND APPLICATION WILL BE LABELED 001 (ZERO ZERO ONE). SUBSEQUENT DB2 INDEXES, WITHIN THE SAME DIVISION AND APPLICATION, WILL BE NUMBERED IN SEQUENCE AND WILL BE INCREMENTED BY ONE.

DB2 INDEX EXAMPLE: F55IX001

F - DIVISION, FINANCIAL

55 - APPLICATION, PAYROLL

IX - INDICATOR, THIS IS A DB2 INDEX

001 - SEQUENCE NUMBER

CHAPTER: NAMING CONVENTIONS NUMBER: 2.3.19.01

DATE: 1/31/95

SECTION: RESOURCE NAMING SCHEMES REVISED:

SUBJECT: DB2 VIEWS

DB2 VIEWS WILL BE STORED ON TEST OR PRODUCTION PANVALET LIBRARIES AND WILL BE INCLUDED IN ONE OR MORE PROGRAMS, THROUGH THE USE OF THE PANVALET COMMAND '++INCLUDE'. DB2 VIEWS WILL BE NAMED ACCORDING TO THE FOLLOWING FORMAT:

DIVISION APPLICATION DB2 OBJECT SEQUENCE

INDICATOR NUMBER

D AA VW NNN

THIS IS ALSO THE NAME USED IN THE CREATE VIEW STATEMENT.

DIVISION (REFER TO 2.2.01.01)

APPLICATION (REFER TO 2.2.02.01)

INDICATOR - THIS INDICATOR WILL ALWAYS BE A 'VW'.

SEQUENCE NUMBER - THREE NUMERIC CHARACTERS. THE FIRST DB2 VIEW NAME WITHIN A PARTICULAR DIVISION AND APPLICATION WILL BE LABELED 001 (ZERO ZERO ONE). SUBSEQUENT DB2 VIEWS, WITHIN THE SAME DIVISION AND APPLICATION, WILL BE NUMBERED IN SEQUENCE AND WILL BE INCREMENTED BY ONE.

DB2 VIEW EXAMPLE:

F55VW001

F - DIVISION, FINANCIAL

55 - APPLICATION, PAYROLL

VW - INDICATOR, THIS IS A PANVALET DB2 VIEW.

001 - SEQUENCE NUMBER

RETURN TO TOP

USC LINKS: