,A ,N ,NL=lfn ,P ,R
C , S C = l f n : C , I = l f n 3 i : , L = l f n j : , L 0 = o p ] .
Figure 3-45. DDL3 Control Statement Format for COBOL and Query Update Subschemas
The A, N, NL=lfn, P and R parameters along with a default operation select subschema library mainte n a n c e o p e r a t i o n s . O n l y o n e o f t h e o p e r a t i o n s c a n b e p e r f o r m e d i n a s i n g l e e x e c u t i o n o f t h e D D L c o m p i l e r. I f t w o o r m o r e o f t h e s e p a r a m e t e r s a r e s p e c i fi e d , a c o n t r o l s t a t e m e n t e r r o r i s i s s u e d . I f a l i b r a r y m a n i p u l a t i o n f u n c t i o n i s a t t e m p t e d o n a n o n e m p t y fi l e t h a t d o e s n o t c o n t a i n a l i b r a r y, a d i a g n o s t i c i s i s s u e d a n d t h e j o b i s a b o r t e d . T h e
parameters are interpreted as follows:
omitted
omitted
Each subschema source program in the job s t r e a m i s c o m p i l e d a n d a d d e d t o t h e s u b s c h e m a l i b r a r y i d e n t i fi e d b y t h e S B parameter.
A u d i t p a r a m e t e r. A l i s t o f t h e s u b s c h e m a s a n d t h e i r c o r r e s p o n d i n g s c h e m a s , t o g e t h e r with their creation dates, is produced from the subschema library identified by the SB parameter.
Compile parameter. Each subschema source program in the job stream is compiled but not added to the subschema library identi fied by the SB parameter.
NL=lfn
N e w l i b r a r y p a r a m e t e r. T h e s p e c i fi e d l o c a l fi l e n a m e i d e n t i fi e s a n e w s u b s c h e m a l i b r a r y t o w h i c h t h e a c t i v e s u b s c h e m a s i n the subschema library (identified by the SB p a r a m e t e r ) a r e t r a n s f e r e d . I f t h e N L p a r a m e t e r i s s p e c i fi e d w i t h n o fi l e n a m e i n d i c a t e d , l o c a l fi l e n a m e N E W L I B i s assumed.
Purge parameter. A subschema specified in the job stream is purged from the subschema l i b r a r y i d e n t i fi e d b y t h e S B p a r a m e t e r. N o compilation takes place.
Replace parameter. Each subschema source program in the job stream is compiled and r e p l a c e s t h e e x i s t i n g s u b s c h e m a ( i d e n t i fi e d b y t h e T i t l e D i v i s i o n ) i n t h e s u b s c h e m a l i b r a r y . T h e s u b s c h e m a l i b r a r y fi l e i s i d e n t i fi e d b y t h e S B p a r a m e t e r. R e p l a c e m e n t t a k e s p l a c e o n l y i f n o c o m p i l a t i o n
e r r o r s o t h e r t h a n i n f o r m a t i v e d i a g n o s t i c s are encountered.
T h e S C p a r a m e t e r i d e n t i fi e s t h e l o c a l fi l e t h a t c o n t a i n s t h e s c h e m a d i r e c t o r y . A s p e c i fi e d l f n overrides the default file name determined from the T i t l e D i v i s i o n . T h i s p a r a m e t e r i s i n t e r p r e t e d a s f o l l o w s :
T h e fi r s t s e v e n c h a r a c t e r s o f t h e s c h e m a n a m e s p e c i fi e d i n T i t l e D i v i s i o n o f t h e s u b s c h e m a s o u r c e p r o g r a m i s a s s u m e d t o i d e n t i f y t h e l o c a l fi l e t h a t c o n t a i n s t h e schema directory.
SC=lfn
T h e s p e c i fi e d l o c a l fi l e n a m e i d e n t i fi e s the file that contains the schema directory.
T h e I p a r a m e t e r i d e n t i fi e s t h e l o c a l fi l e t h a t c o n t a i n s s o u r c e i n p u t f o r t h e D D L c o m p i l e r. T h i s parameter is interpreted as follows:
omitted
The local file INPUT is assumed to contain the source input for the DDL compiler.
1=1 fn
T h e s p e c i fi e d l o c a l fi l e n a m e i d e n t i fi e s t h e fi l e t h a t c o n t a i n s s o u r c e i n p u t f o r t h e DDL compiler.
T h e L p a r a m e t e r i d e n t i fi e s t h e l o c a l fi l e t h a t r e c e i v e s l i s t i n g s a n d d i a g n o s t i c s g e n e r a t e d b y t h e D D L c o m p i l e r . T h i s p a r a m e t e r i s i n t e r p r e t e d a s f o l l o w s :
omitted
The local file OUTPUT receives the listings a n d d i a g n o s t i c s g e n e r a t e d b y t h e D D L c o m p i l e r.
L=0
T h e l o c a l fi l e O U T P U T r e c e i v e s o n l y t h e diagnostics generated by the DDL compiler.
L = l f n
T h e s p e c i fi e d l o c a l fi l e n a m e i d e n t i fi e s t h e fi l e t h a t r e c e i v e s t h e l i s t i n g s a n d diagnostics generated by the DDL compiler.
T h e L O p a r a m e t e r s e l e c t s t h e l i s t i n g p r o d u c e d b y the DDL compiler. Two listing options (op) can be s p e c i fi e d : a s o u r c e l i s t i n g ( S o p t i o n ) a n d a n o b j e c t l i s t i n g ( 0 o p t i o n ) . S o u r c e a n d o b j e c t l i s t i n g s a r e w r i t t e n t o t h e fi l e s p e c i fi e d b y t h e L p a r a m e t e r . I f L = 0 i s s p e c i fi e d , n o l i s t i n g i s produced except for error messages, regardless of L O s p e c i fi c a t i o n . T h i s p a r a m e t e r i s i n t e r p r e t e d a s f o l l o w s :
omitted
Same as LO-S; a source listing is produced.
LO
S a m e a s L 0 = S ; o n l y a s o u r c e l i s t i n g i s produced.
60485200 A 3-33
L0=op L0=opi/op2
T h e s p e c i fi e d l i s t i n g o p t i o n s e l e c t s t h e l i s t i n g p r o d u c e d . T h e l i s t i n g o p t i o n s a r e
as follows:
S S o u r c e l i s t i n g
0 O b j e c t l i s t i n g ; a l i s t i n g o f t h e c o d e g e n e r a t e d f o r a m a p p i n g c a p s u l e . I f n o m a p p i n g c a p s u l e i s r e q u i r e d f o r t h e s u b s c h e m a , t h e r e i s n o o b j e c t l i s t i n g .
SUBSCHEMA COMPILATION AND LIBRARY MAINTENANCE OPERATIONS
A COBOL or Query Update subschema must be coded a c c o r d i n g t o t h e s p e c i fi c a t i o n s i n t h i s m a n u a l . Subschema source code can be entered through a terminal, processed by a text editor, and stored in a fi l e .
The DDL compiler can be executed from a terminal a n d t h r o u g h a b a t c h j o b i n t h e f o l l o w i n g w a y s . When executed from a terminal, the subschema pro gram must reside on a file whose name is indicated by the I parameter of the DDL3 control statement.
In a batch job, in which the input file for the DDL compiler is assumed to be local file INPUT, the job s t r e a m m u s t b e s t r u c t u r e d s o t h a t t h e c o n t r o l statements precede the subschema source program.
An end-of-record indicator must immediately precede the first line of subschema source code to separate the subschema program from the control statements.
C o n t r o l s t a t e m e n t s i n t h e j o b s t r e a m a n d t h e resulting subschema source program are used by the DDL compiler either to compile the subschema and to store it in the subschema library or to perform a s u b s c h e m a l i b r a r y m a i n t e n a n c e o p e r a t i o n s u c h a s replacing or deleting subschemas, generating a new, compacted subschema library, or producing an audit listing. The parameters in the DDL3 control state m e n t s e l e c t t h e o p e r a t i o n t o b e p e r f o r m e d . O t h e r
c o n t r o l s t a t e m e n t s p r o v i d e i n f o r m a t i o n f o r t h e o p e r a t i n g s y s t e m t o m a k e n e c e s s a r y i n f o r m a t i o n available for the DDL compiler.
T h e f o l l o w i n g p a r a g r a p h s i n d i c a t e t h e p a r a m e t e r s required in the DDL3 control statement to accomplish compilation of COBOL and Query Update subschemas and to perform subschema library maintenance opera tions. Examples of batch jobs that accomplish the operations are shown. The DDL3 control statements u s e d i n t h e e x a m p l e s a l t e r n a t e l y i n d i c a t e Q u e r y Update and COBOL subschemas. Control statements are shown for both the NOS and NOS/BE operating systems*
Compiling a Subschema
The source program for a subschema can be compiled without being stored in the subschema library. The form of the DDL3 control statement (shown with the QC parameter) needed to compile a Query Update
subschema is as follows:
DDL3,QC,SB=lfn,N,SC=lfn.
Either the C5 or QC parameter must be specified: C5 for compilation of a COBOL subschema; QC for com pilation of a Query Update subschema. The compile parameter (N) must also be specified. The SB, SC, I, and L parameters are optional and have default v a l u e s ( r e f e r t o t h e D D L 3 C o n t r o l S t a t e m e n t s u b s e c t i o n ) .
F i g u r e 3 - 4 6 i l l u s t r a t e s a j o b t h a t a c c o m p l i s h e s subschema compilation only. The schema file must be attached.
Creating a Subschema Library
T h e s u b s c h e m a l i b r a r y i s c r e a t e d w h e n t h e fi r s t s u b s c h e m a i s s t o r e d i n i t . T h e f o r m o f t h e D D L 3 c o n t r o l s t a t e m e n t ( s h o w n w i t h t h e C 5 p a r a m e t e r ) needed to create a subschema library and store a compiled subschema in it is as follows:
DDL3,C5,SB=lfn,SC=lfn.
Either the C5 or QC parameter must be specified: C5 f o r c o m p i l a t i o n o f a C O B O L s u b s c h e m a ; Q C f o r compilation of a Query Update subschema. The SB, SC, I, L, and LO parameters are optional and have default values (refer to the DDL3 Control Statement subsection).
F i g u r e 3 - 4 7 i l l u s t r a t e s a j o b t h a t c o m p i l e s a subschema and creates a subschema library. In this example, the schema file SCHPAY is attached. The s u b s c h e m a l i b r a r y i s i d e n t i fi e d b y t h e l o c a l fi l e name SUBSCH. The DEFINE and REQUEST/CATALOG c o n t r o l s t a t e m e n t s s p e c i f y t h e l o c a l fi l e n a m e o f the subschema library and assign it to a permanent file device. A password specified in the DEFINE or CATALOG statement controls subsequent access and use of the subschema library.
I f o n l y o n e s u b s c h e m a i s t o b e s t o r e d i n t h e l i br ar y, t he s ubs c hem a n am e can b e us e d f or t he
subschema library file name.
Query Update-CDCS subschemas (QC option) and COBOL s u b s c h e m a s ( C 5 o p t i o n ) a r e n o t c o m p a t i b l e w i t h Query Update-CRM subschemas (QD option) and there
fore cannot exist on the same library file.
NOS Operating System NOS/BE Operating System
Job statement Job statement
USER control statement ACCOUNT control statement
CHARGE control statement ATTACH,SCHPAY,ID=DDL.
ATTACH,SCHPAY. DDL3,QC,SB=SBTST,N,SC=SCHPAY.
DDL3,C5,SB=SBTST,N,SC=SCHPAY. End-of-record
End-of-record DDL Subschema Source Input
DDL Subschema Source Input E n d - o f - i n f o r m a t i o n E n d - o f - i n f o r m a t i o n
Figure 3-46. Compiling a Subschema
NOS Operating System NOS/BE Operating System
Job statement Job statement
USER control statement ACCOUNT control statement
CHARGE control statement ATTACH,SCHPAY,ID=DDL.
ATTACH,SCHPAY. REQUEST,SUBSCH,PF.
DEFINE,SUBSCH/PW=DDL,CT=PU,M=W. DDL3,C5,SB=SUBSCH,SC=SCHPAY.
DDL3,QC,SB=SUBSCH,SC=SCHPAY. CATALOG,SUBSCH,ID=DDL,MD=DDL,EX=DDL,CN=DDLX.
End-of-record End-of-record
DDL Subschema Source Input DDL Subschema Source Input
E n d - o f - i n f o r m a t i o n E n d - o f - i n f o r m a t i o n
Figure 3-47. Creating a Subschema Library
j 0 ^ \
/^^W~
Compiling Multiple Subschemas
A number of subschemas can be compiled with one control statement call to the DDL compiler. The parameters specified in the control statement apply to ail the subschemas. The subschema library maintenance operations of creating a subschema library, adding (default operation) subschemas to the subschema library, replacing (R parameter) subschemas in the library, or just compiling (N parameter) subschemas can be used with this f a c i l i t y.
For the compilation of several subschemas with one control statement call to the DDL compiler, the subschema source statements must be contiguous, with no intervening of-record indicator or end-of-information indicator. The program source for each subschema must begin with the TITLE DIVISION statement. Each subsequent TITLE DIVISION state ment immediately follows the last source statement of the preceding subschema. Each subschema is compiled in turn until of-information or end-of-record is encountered.
Compiling a Subschema and Adding to a Subschema Library
Once the subschema library has been created and d e s c r i b e d i n t h e s u b s e c t i o n ) , n e w s a v e d o n a p e r m a n e n t fi l e ( a s
C r e a t i n g a S u b s c h e m a L i b r a r y
subschemas can be added to the library. The form of the DDL3 control statement (shown with the QC parameter) needed to add a subschema to an existing subschema library is as follows:
DDL3,QC,SB=lfn,SC=lfn.
Either the C5 or QC parameter must be specified: C5 f o r c o m p i l a t i o n o f a C O B O L s u b s c h e m a ; Q C f o r compilation of a Query Update subschema. The SB, SC, I, L, and LO parameters are optional and have default values (refer to the DDL3 Control Statement s u b s e c t i o n ) .
Figure 3-48 illustrates a job that adds a subschema to the subschema library created by the example in fi g u r e 3 - 4 7 . T h e s c h e m a d i r e c t o r y i s a t t a c h e d . T h e s u b s c h e m a l i b r a r y i s a l s o a t t a c h e d w i t h t h e applicable password and (for NOS only) access mode M=W specified.
Each subschema stored in the library must have a unique name. If the subschema being added to the library has the same name as a subschema already s t o r e d i n t h e l i b r a r y, a d i a g n o s t i c i s i s s u e d a n d the job is aborted.
Replacing a Subschema
A new subschema can replace one that is stored in t h e s u b s c h e m a l i b r a r y . T h e f o r m o f t h e D D L 3 c o n t r o l s t a t e m e n t ( s h o w n w i t h t h e C 5 p a r a m e t e r ) needed to replace a subschema in the subschema l i b r a r y i s a s f o l l o w s :
DDL3,C5,SB=lfn,R,SC=lfn.
Either the C5 or QC parameter must be specified: C5 f o r c o m p i l a t i o n o f a C O B O L s u b s c h e m a ; Q C f o r c o m p i l a t i o n o f a Q u e r y U p d a t e s u b s c h e m a . T h e r e p l a c e m e n t p a r a m e t e r ( R ) m u s t b e s p e c i fi e d . T h e SB, SC, I, L, and LO parameters are optional and h a v e d e f a u l t v a l u e s ( r e f e r t o t h e D D L 3 C o n t r o l
Statement subsection).
NOS Operating System NOS/BE Operating System
Job statement Job statement
USER control statement ACCOUNT control statement
CHARGE control statement ATTACH,SCHPAY,ID=DDL.
ATTACH,SCHPAY. ATTACH,SUBSCH,ID=DDL,PW=DDL.
ATTACH,SUBSCH/PW=DDL,M=W. DDL3,QC,SB=SUBSCH.
DDL3,C5,SB=SUBSCH. End-of-record
End-of-record DDL Subschema Source Input
DDL Subschema Source Input E n d - o f - i n f o r m a t i o n E n d - o f - i n f o r m a t i o n
Figure 3-48. Compiling a Subschema and Adding to a Subschema Library
60485200 A 3-35
F i g u r e 3 - 4 9 i l l u s t r a t e s a j o b t h a t r e p l a c e s a s u b s c h e m a i n t h e s u b s c h e m a l i b r a r y. T h e s c h e m a d i r e c t o r y i s a t t a c h e d . T h e s u b s c h e m a l i b r a r y fi l e is also attached with the applicable password and ( f o r N O S o n l y ) a c c e s s m o d e M = W i s s p e c i fi e d . I f the subschema to be replaced cannot be found in the s u b s c h e m a l i b r a r y, a n i n f o r m a t i v e d i a g n o s t i c i s i s s u e d a n d t h e n e w s u b s c h e m a i s a d d e d t o t h e l i b r a r y .
The contr ol s tat em ent s ar e fol l o w ed by s t ate ment s t h a t s p e c i f y t h e s u b s c h e m a s t o b e d e l e t e d . T h e subschema name is entered anywhere from column 8 through column 72. If more than one subschema name is entered, a space or a comma must follow each subschema name.
No compilation occurs when a subschema is deleted from the subschema library.
Deleting a Subschema
A subschema stored in the subschema library can be d e l e t e d f r o m t h e l i b r a r y. T h e f o r m o f t h e D D L 3 c o n t r o l s t a t e m e n t ( s h o w n w i t h t h e Q C p a r a m e t e r ) needed to purge a subschema from the subschema l i b r a r y i s a s f o l l o w s :
DDL3,QC,SB=lfn,P.
Auditing a Subschema Library
A f t e r a s u b s c h e m a l i b r a r y i s c r e a t e d , i t c a n b e s e a r c h e d a n d a l i s t g e n e r a t e d t h a t i n c l u d e s t h e name of each subschema and the name of the schema i t r e f e r e n c e s , t o g e t h e r w i t h t h e i r c r e a t i o n d a t e s . The form of the DDL3 control statement (shown with t h e C 5 p a r a m e t e r ) n e e d e d t o g e n e r a t e t h e a u d i t l i s t i n g i s a s f o l l o w s :
DDL3,C5,SB=lfn,A.
Either the C5 or QC parameter must be specified.
The purge parameter (P) must be specified. The SB, I, and L parameters are optional and have default v a l u e s ( r e f e r t o t h e D D L 3 C o n t r o l S t a t e m e n t s u b s e c t i o n ) .
Either the C5 or QC parameter must be specified.
The audit parameter (A) must be specified. The SB a n d L p a r a m a t e r s a r e o p t i o n a l a n d h a v e d e f a u l t v a l u e s ( r e f e r t o t h e D D L 3 C o n t r o l S t a t e m e n t s u b section) .
F i g u r e 3 - 5 0 i l l u s t r a t e s a j o b t h a t p u r g e s a s u b schema from the subschema library. The subschema l i b r a r y fi l e i s a t t a c h e d w i t h t h e a p p l i c a b l e password and (for NOS only) access mode M=W is s p e c i fi e d . T h e e n d - o f - r e c o r d i n d i c a t o r d e s i g n a t e s the end of the control statements.
F i g u r e 3 - 5 1 i l l u s t r a t e s a j o b t h a t p r o d u c e s a n a u d i t l i s t i n g o f t h e s u b s c h e m a l i b r a r y . T h e subschema library is attached with the appropriate p a s s w o r d s p e c i fi e d . T h e l i s t i n g p r o d u c e d b y t h e DDL compiler when the audit is performed is shown
i n fi g u r e 3 - 5 2 .
NOS Operating System NOS/BE Operating System
Job statement Job statement
USER control statement ACCOUNT control statement
CHARGE control statement ATTACH,SCHPAY,ID=DDL.
ATTACH,SCHPAY. ATTACH,SUBSCH,ID=DDL,PW=DDL.
ATTACH,SUBSCH/PW=DDL,M=W. DDL3,C5,SB=SUBSCH,R.
DDL3,QC,SB=SUBSCH,R. End-of-record
End-of-record DDL Subschema Source Input
DDL Subschema Source Input End-of-information End-of-information
Figure 3-49. Replacing a Subschema Library
NOS Operating System NOS/BE Operating System
Job statement Job statement
USER control statement ACCOUNT control statement
CHARGE control statement ATTACH,SUBSCH,ID=DDL,PW=DDL.
ATTACH,SUBSCH/PW=DDL,M=W. DDL3,QC,SB=SUBSCH,P.
DDL3,C5,SB=SUBSCH,P. End-of-record
End-of-record PAYROLL
PAYROLL NEWHIRES
NEWHIRES End-of-information
End-of-information
Figure 3-50. Deleting Subschemas From the Library
NOS Operating System Job statement
USER control statement CHARGE control statement ATTACH,SUBSCH/PW=DDL.
DDL3,C5,SB=SUBSCH,A.
E n d - o f - i n f o r m a t i o n
NOS/BE Operating System Job statement
ACCOUNT control statement ATTACH,SUBSCH,ID=DDL,PW=DDL.
DDL3,QC,SB=SUBSCH,A.
E n d - o f - i n f o r m a t i o n
Figure 3-51. Auditing a Subschema Library
* SOURCE LISTING * (82061) DDL 3.2+564. 82/04/05. 09.56.11
BEGIN SUB-SCHEMA FILE MAINTENANCE LIST OF SUB-SCHEMAS IN FILE
SUB-SCHEMA
C5SS-PR0DUCT-PERS0NNEL PAYROLL
PRODUCTS PROJECTS
C5SS-PR0DUCT-MANAGEMENT
CREATION SCHEMA CREATION
DATE TIME
MANUFACTURING-DB
DATE TIME
82087 14.19 82087 14.14
82087 14.19 MANUFACTURING-DB 82087 14.14
82087 14.19 MANUFACTURING-DB 82087 14.14
82087 14.19 MANUFACTURING-DB 82087 14.14
82087 MAINTENAr
14.19 JCE
MANUFACTURING-DB 82087 14.14
DDL COMPLETE.
45300B CM USED. 0 DIAGNOSTICS.
0.022 CP SECS.
Figure 3-52. Audit Listing of the Subschema Library
Compacting a Subschema Library
Subschema library compaction Is an optional facil i t y t h a t g e n e r a t e s a n e w s u b s c h e m a l i b r a r y b y copying only the active subschemas from the speci
fi e d s u b s c h e m a l i b r a r y . W h e n t h i s f a c i l i t y i s executed, the DDL compiler generates a listing that includes the name of each transferred subschema and t h e s c h e m a I t r e f e r e n c e s , t o g e t h e r w i t h t h e i r c r e a t i o n d a t e s . T h e f o r m o f t h e D D L 3 c o n t r o l statement (shown with the C5 parameter) needed to c r e a t e a n e w, c o m p a c t e d s u b s c h e m a l i b r a r y i s a s f o l l o w s :
DDL3,C5,SB=1fn,NL=1fn.
Either the C5 or QC parameter must be specified.
The new library parameter (NL) must be specified.
T h e S B a n d L p a r a m e t e r s a r e o p t i o n a l a n d h a v e default values (refer to the DDL3 Control Statement
s u b s e c t i o n ) .
F i g u r e 3 - 5 3 i l l u s t r a t e s a j o b t h a t c r e a t e s a n e w, compacted subschema library. The subschema library i s a t t a c h e d w i t h t h e a p p r o p r i a t e p a s s w o r d . T h e DEFINE and REQUEST/CATALOG control statements s p e c i f y t h e l o c a l fi l e n a m e o f t h e n e w s u b s c h e m a l i b r a r y a n d a s s i g n i t t o a p e r m a n e n t fi l e d e v i c e . A p a s s w o r d s p e c i fi e d i n t h e D E F I N E o r C ATA L O G statement controls subsequent access and use of the s u b s c h e m a l i b r a r y. T h e D D L 3 c o n t r o l s t a t e m e n t specifies the SB parameter with the local file name of the current subschema library to be compacted, a n d t h e N L p a r a m e t e r w i t h t h e l o c a l fi l e n a m e o f t h e n e w s u b s c h e m a l i b r a r y. T h e P U R G E c o n t r o l s t a t e m e n t d e s t r o y s t h e o l d l i b r a r y fi l e .
NOS Operating System NOS/BE Operating System
Job statement Job statement
USER control statement ACCOUNT control statement
CHARGE control statement ATTACH,SUBSCH,ID=DDL,PW=DDL.
ATTACH,SUBSCH/PW=DDL, M=W. REQUEST,NEWSUB,PF.
DEFINE,NEWSUB/PW=DDL,CT=PU,M=W. DDL3,C5,SB=SUBSCH,NL=NEWSUB.
DDL3,QC,SB=SUBSCH,NL=NEWSUB. CATALOG,NEWSUB,ID=DDL,MD=DDL,EX=DDL,CN=DDLX.
PURGE,SUBSCH. PURGE,SUBSCH,RB=1.
E n d - o f - i n f o r m a t i o n E n d - o f - i n f o r m a t i o n Figure 3-53. Compacting a Subschema Library
60485200 A 3-37
This facility is intended to be used on a subschema library that has had a number of subschemas purged or replaced and, therefore, contains wasted space.
The DDL compiler eliminates the wasted space in the n e w s u b s c h e m a l i b r a r y. A f t e r t h e n e w s u b s c h e m a l i b r a r y i s s t o r e d a s a p e r m a n e n t fi l e , t h e u s e r s h o u l d p u r g e t h e o l d s u b s c h e m a l i b r a r y . T h i s f a c i l i t y d o e s n o t a l l o w f o r c o m p i l a t i o n o f s u b schemas .
COMPILATION OUTPUT
A l i s t i n g o f t h e D D L s o u r c e p r o g r a m I s p r o v i d e d whenever a COBOL or Query Update subschema is c o m p i l e d . E a c h l i n e o f t h e l i s t i n g c o r r e s p o n d s t o one source line in the source program. The format and order of each line of the listing are identical t o t h e f o r m a t a n d o r d e r o f t h e s t a t e m e n t s i n t h e s o u r c e p r o g r a m . F i g u r e 3 - 5 4 i s a s a m p l e s o u r c e listing for a subschema compilation.
T h e D D L c o m p i l e r a s s i g n s a l i n e n u m b e r t o e a c h i n p u t s t a t e m e n t , b e g i n n i n g w i t h 0 0 0 0 1 . T h e l i n e numbers are printed on the source listing, starting in column 16. Diagnostic messages begin in column 3 o f t h e l i s t i n g . A f t e r t h e l a s t i n p u t s t a t e m e n t i s l i s t e d , a c o m p i l a t i o n s u m m a r y i s p r i n t e d . W h e n r e l a t i o n s t a t i s t i c s a r e a p p l i c a b l e , r e l a t i o n n a m e s and their traversed areas are included.
The source listing can be suppressed by specifying L=0 in the DDL3 control statement. Only diagnostic messages and the compilation summary are printed on
t h e l i s t i n g .
W h e n a s u b s c h e m a i s c o m p i l e d , a c r o s s - r e f e r e n c e list and a data map are not printed. When a COBOL a p p l i c a t i o n p r o g r a m s p e c i fi e s t h e s u b s c h e m a , t h e
COBOL compiler produces a cross-reference list and a data map containing the realm, record, and data
item entries defined in the subschema.