Embed Size (px)
Citation preview
882019 2 Setup
httpslidepdfcomreaderfull2-setup 18
Chapter
2Setting Default Options for Your Access Paths
This chapter explains how to set up options for the model values assi ned to theaccess paths that ou build and explains how to chan e compiler overrides
Model Values
Model-specific values control particular features of theinteractive use of S non2E code eneration andimplementation
For more information
on what a model value is refer to Getting Started Chapter 4 ldquoUsin Your DevelopmentEnvironmentrdquo
The model values ou need to be concerned with whenbuildin access paths are
bull YALCVNM
The Allocate Valid Name (YALCVNM) model valuespecifies whether DDS and SQL ob ect names are tobe allocated automaticall b S non2E or b aspecific standard you establish for the Synon2Emodel
bull YOBJPFX
The Ob ect Prefix (YOBJPFX) model value specifies
the prefix to be used when eneratin s stemobjects
bull YFILPFX
The Last Used File Prefix (YFILPFX) model valuecontains the last 2-character identif in mnemonicS non2E used when creatin a new file These two
Building Access Paths BAP 2 ndash 1
882019 2 Setup
httpslidepdfcomreaderfull2-setup 28
882019 2 Setup
httpslidepdfcomreaderfull2-setup 38
For more informationon model values and how to set model valuesrefer to YCHGMDLVAL in Synon2E Command Reference
Changing Values
Use the following information to change the modelvalues for your access paths
AllocatingNames
This topic tells you how to control the names assigned toSynon2E objects by changing the names given to thesource member names when the access paths are built
Allocating a Source Member Name for an Access Path
1 Zoom into the file At the Edit Database Relationpanel type Z next to any relation for the file andpress Enter
The Edit File Details panel displays
2 Zoom into the access path Type Z next to the oneyou want to rename and press Enter
Changing Values
Building Access Paths BAP 2 ndash 3
882019 2 Setup
httpslidepdfcomreaderfull2-setup 48
The Edit Access Path Details panel displays
Op YOU DSP32 63094 134026
EDIT ACCESS PATH DETAILS MYMDL
File name Access path name Unique or duplicate order
Index maintenance option Alternate collating table
Allow selectomit Generation mode Source member name
Source member text
Customer Attribute REF Retrieval index Type RTV
U (U-UniqueF-FIFOL-LIFOC-FCFOrsquo rsquo-Undefined)
I (I-IMMED D-DLY R-RBLD)
(S-Static D-Dynamic -None) M (M-MDLVAL D-DDS S-SQL X-UNX) MYAGREL1
Customer _ Retrieval Index
Format
Seq name1 FAGREAV
GEN
pfxAG
Format text
(Based on file)Customer
Associated
Update access pathUpdate index
SEL Z-Entries R-Relations S-Selectomit A-Associated acps T-Trim V-Virtualize
F3=Exit F8=Rename F20=Narrative
3 Enter the new source member name Type the newsource member name in the source member nameoption field and press Enter
ControllingAuxiliary Names
Synon2E generates default values for the three accesspath auxiliaries created when you define a Query(QRY) access path These three auxiliaries apply toDDS generation Change the name of the auxiliaries byusing the following procedure
1 Zoom into the file At the Edit Database Relationspanel type Z next to the relation for the file and pressEnter
The Edit File Details panel displays
2 Zoom into the QRY access path Type Z next to theselected QRY access path and press Enter
The Edit Access Path Details panel displays with thedetails for the QRY access path
Changing Values
BAP 2 ndash 4 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 58
3 View the QRY auxiliaries Press F7 to view the QRYaccess path auxiliaries
The Edit Access Path Auxiliaries panel displays
4 Type the new source member names and pressEnter
Creating an SQLEnvironment
Using SQL facilitates the portability of generatedapplications and is the only means of database accessacross machines in Distributed Relational DatabaseArchitecture (DRDA)
For more informationon DRDA refer to this module Chapter 4
ldquoModifying Access Pathsrdquo Building DistributedRelational Database Applications topic
Generating and Implementing Applications Chapter 7 ldquoDistributed Relational DatabaseArchitecturerdquo
To create SQL tables and views for your model youneed an SQL library known as a collection Thiscollection contains the SQL objects including thecatalogue a data dictionary a journal and two journal
receivers
When creating an SQL environment use one of thefollowing
bull SQLLIB parameter on the YCRTMDLLIB commandcreates a collection library name with MDL replacedby SQL or a name of your choosing
bull Create SQL Library (YCRTSQLLIB) commandcreates a collection and links it to a model
SpecifyingGeneration Mode
The choice of which generation mode to use iscontrolled by the Database File Generation (YDBFGEN)model value that acts as an implementation flag Thedefault value is DDS You can use the followingprocedure to assign a value to a specific access pathwhen it is built The options you have are DDS SQLand UNX
Changing Values
Building Access Paths BAP 2 ndash 5
882019 2 Setup
httpslidepdfcomreaderfull2-setup 68
Changing theGenerationMode at theAccess PathLevel
To change the generation mode for a specific accesspath at the access path level
1 Zoom into the file At the Edit Database Relationspanel type Z next to the relations for the file and
press Enter
The Edit File Details panel displays
2 Zoom into the access path Type Z next to theaccess path whose generation mode you want tochange and press Enter
The Edit Access Path Details panel displays
3 Change the generation mode Type the character
that represents the new generation model value
Your options are
D for DDS
S for SQL
X for UNIX
M for MDLVAL
Note If an access path specifies M for MDLVAL when itis generated it will use the current value for the
YDBFGEN model value If you want to overridethis value enter D S or X The default is M
4 Press Enter
Changing Values
BAP 2 ndash 6 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 78
Changing Compiler Overrides
Within Synon2E there are various properties of theOS400 database files that you can modify byspecifying compiler overrides The overrides are the
parameters on the compiler commands
Synon2E allows you to prompt for and store theseoverrides that are then automatically applied by thecompile pre-processor when you compile yourprograms
Some of the overrides you can specify are
bull Physical files OS400 Create Physical File(CRTPF) command
bull MAXMBRS SIZE
Note MAXMBRS is a parameter that specifies themaximum number of members the file canhold
bull Logical files OS400 Create Logical File (CRTLF)command
bull MAXMBRS DTAMBRS
Note Some of the compile parameters (MAINTTEXT) are specified by the access pathdetails Override values should not bespecified for these values
For more informationon how to prompt for and store overrides referto this modulersquos Chapter 7 ldquoGenerating andCompilingrdquo Changing Compiler Overrides topic
on the OS400 commands refer to IBM AS400 CL Command Reference
Changing Compiler Overrides
Building Access Paths BAP 2 ndash 7
882019 2 Setup
httpslidepdfcomreaderfull2-setup 88
Changing Compiler Overrides
BAP 2 ndash 8 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 28
882019 2 Setup
httpslidepdfcomreaderfull2-setup 38
For more informationon model values and how to set model valuesrefer to YCHGMDLVAL in Synon2E Command Reference
Changing Values
Use the following information to change the modelvalues for your access paths
AllocatingNames
This topic tells you how to control the names assigned toSynon2E objects by changing the names given to thesource member names when the access paths are built
Allocating a Source Member Name for an Access Path
1 Zoom into the file At the Edit Database Relationpanel type Z next to any relation for the file andpress Enter
The Edit File Details panel displays
2 Zoom into the access path Type Z next to the oneyou want to rename and press Enter
Changing Values
Building Access Paths BAP 2 ndash 3
882019 2 Setup
httpslidepdfcomreaderfull2-setup 48
The Edit Access Path Details panel displays
Op YOU DSP32 63094 134026
EDIT ACCESS PATH DETAILS MYMDL
File name Access path name Unique or duplicate order
Index maintenance option Alternate collating table
Allow selectomit Generation mode Source member name
Source member text
Customer Attribute REF Retrieval index Type RTV
U (U-UniqueF-FIFOL-LIFOC-FCFOrsquo rsquo-Undefined)
I (I-IMMED D-DLY R-RBLD)
(S-Static D-Dynamic -None) M (M-MDLVAL D-DDS S-SQL X-UNX) MYAGREL1
Customer _ Retrieval Index
Format
Seq name1 FAGREAV
GEN
pfxAG
Format text
(Based on file)Customer
Associated
Update access pathUpdate index
SEL Z-Entries R-Relations S-Selectomit A-Associated acps T-Trim V-Virtualize
F3=Exit F8=Rename F20=Narrative
3 Enter the new source member name Type the newsource member name in the source member nameoption field and press Enter
ControllingAuxiliary Names
Synon2E generates default values for the three accesspath auxiliaries created when you define a Query(QRY) access path These three auxiliaries apply toDDS generation Change the name of the auxiliaries byusing the following procedure
1 Zoom into the file At the Edit Database Relationspanel type Z next to the relation for the file and pressEnter
The Edit File Details panel displays
2 Zoom into the QRY access path Type Z next to theselected QRY access path and press Enter
The Edit Access Path Details panel displays with thedetails for the QRY access path
Changing Values
BAP 2 ndash 4 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 58
3 View the QRY auxiliaries Press F7 to view the QRYaccess path auxiliaries
The Edit Access Path Auxiliaries panel displays
4 Type the new source member names and pressEnter
Creating an SQLEnvironment
Using SQL facilitates the portability of generatedapplications and is the only means of database accessacross machines in Distributed Relational DatabaseArchitecture (DRDA)
For more informationon DRDA refer to this module Chapter 4
ldquoModifying Access Pathsrdquo Building DistributedRelational Database Applications topic
Generating and Implementing Applications Chapter 7 ldquoDistributed Relational DatabaseArchitecturerdquo
To create SQL tables and views for your model youneed an SQL library known as a collection Thiscollection contains the SQL objects including thecatalogue a data dictionary a journal and two journal
receivers
When creating an SQL environment use one of thefollowing
bull SQLLIB parameter on the YCRTMDLLIB commandcreates a collection library name with MDL replacedby SQL or a name of your choosing
bull Create SQL Library (YCRTSQLLIB) commandcreates a collection and links it to a model
SpecifyingGeneration Mode
The choice of which generation mode to use iscontrolled by the Database File Generation (YDBFGEN)model value that acts as an implementation flag Thedefault value is DDS You can use the followingprocedure to assign a value to a specific access pathwhen it is built The options you have are DDS SQLand UNX
Changing Values
Building Access Paths BAP 2 ndash 5
882019 2 Setup
httpslidepdfcomreaderfull2-setup 68
Changing theGenerationMode at theAccess PathLevel
To change the generation mode for a specific accesspath at the access path level
1 Zoom into the file At the Edit Database Relationspanel type Z next to the relations for the file and
press Enter
The Edit File Details panel displays
2 Zoom into the access path Type Z next to theaccess path whose generation mode you want tochange and press Enter
The Edit Access Path Details panel displays
3 Change the generation mode Type the character
that represents the new generation model value
Your options are
D for DDS
S for SQL
X for UNIX
M for MDLVAL
Note If an access path specifies M for MDLVAL when itis generated it will use the current value for the
YDBFGEN model value If you want to overridethis value enter D S or X The default is M
4 Press Enter
Changing Values
BAP 2 ndash 6 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 78
Changing Compiler Overrides
Within Synon2E there are various properties of theOS400 database files that you can modify byspecifying compiler overrides The overrides are the
parameters on the compiler commands
Synon2E allows you to prompt for and store theseoverrides that are then automatically applied by thecompile pre-processor when you compile yourprograms
Some of the overrides you can specify are
bull Physical files OS400 Create Physical File(CRTPF) command
bull MAXMBRS SIZE
Note MAXMBRS is a parameter that specifies themaximum number of members the file canhold
bull Logical files OS400 Create Logical File (CRTLF)command
bull MAXMBRS DTAMBRS
Note Some of the compile parameters (MAINTTEXT) are specified by the access pathdetails Override values should not bespecified for these values
For more informationon how to prompt for and store overrides referto this modulersquos Chapter 7 ldquoGenerating andCompilingrdquo Changing Compiler Overrides topic
on the OS400 commands refer to IBM AS400 CL Command Reference
Changing Compiler Overrides
Building Access Paths BAP 2 ndash 7
882019 2 Setup
httpslidepdfcomreaderfull2-setup 88
Changing Compiler Overrides
BAP 2 ndash 8 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 38
For more informationon model values and how to set model valuesrefer to YCHGMDLVAL in Synon2E Command Reference
Changing Values
Use the following information to change the modelvalues for your access paths
AllocatingNames
This topic tells you how to control the names assigned toSynon2E objects by changing the names given to thesource member names when the access paths are built
Allocating a Source Member Name for an Access Path
1 Zoom into the file At the Edit Database Relationpanel type Z next to any relation for the file andpress Enter
The Edit File Details panel displays
2 Zoom into the access path Type Z next to the oneyou want to rename and press Enter
Changing Values
Building Access Paths BAP 2 ndash 3
882019 2 Setup
httpslidepdfcomreaderfull2-setup 48
The Edit Access Path Details panel displays
Op YOU DSP32 63094 134026
EDIT ACCESS PATH DETAILS MYMDL
File name Access path name Unique or duplicate order
Index maintenance option Alternate collating table
Allow selectomit Generation mode Source member name
Source member text
Customer Attribute REF Retrieval index Type RTV
U (U-UniqueF-FIFOL-LIFOC-FCFOrsquo rsquo-Undefined)
I (I-IMMED D-DLY R-RBLD)
(S-Static D-Dynamic -None) M (M-MDLVAL D-DDS S-SQL X-UNX) MYAGREL1
Customer _ Retrieval Index
Format
Seq name1 FAGREAV
GEN
pfxAG
Format text
(Based on file)Customer
Associated
Update access pathUpdate index
SEL Z-Entries R-Relations S-Selectomit A-Associated acps T-Trim V-Virtualize
F3=Exit F8=Rename F20=Narrative
3 Enter the new source member name Type the newsource member name in the source member nameoption field and press Enter
ControllingAuxiliary Names
Synon2E generates default values for the three accesspath auxiliaries created when you define a Query(QRY) access path These three auxiliaries apply toDDS generation Change the name of the auxiliaries byusing the following procedure
1 Zoom into the file At the Edit Database Relationspanel type Z next to the relation for the file and pressEnter
The Edit File Details panel displays
2 Zoom into the QRY access path Type Z next to theselected QRY access path and press Enter
The Edit Access Path Details panel displays with thedetails for the QRY access path
Changing Values
BAP 2 ndash 4 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 58
3 View the QRY auxiliaries Press F7 to view the QRYaccess path auxiliaries
The Edit Access Path Auxiliaries panel displays
4 Type the new source member names and pressEnter
Creating an SQLEnvironment
Using SQL facilitates the portability of generatedapplications and is the only means of database accessacross machines in Distributed Relational DatabaseArchitecture (DRDA)
For more informationon DRDA refer to this module Chapter 4
ldquoModifying Access Pathsrdquo Building DistributedRelational Database Applications topic
Generating and Implementing Applications Chapter 7 ldquoDistributed Relational DatabaseArchitecturerdquo
To create SQL tables and views for your model youneed an SQL library known as a collection Thiscollection contains the SQL objects including thecatalogue a data dictionary a journal and two journal
receivers
When creating an SQL environment use one of thefollowing
bull SQLLIB parameter on the YCRTMDLLIB commandcreates a collection library name with MDL replacedby SQL or a name of your choosing
bull Create SQL Library (YCRTSQLLIB) commandcreates a collection and links it to a model
SpecifyingGeneration Mode
The choice of which generation mode to use iscontrolled by the Database File Generation (YDBFGEN)model value that acts as an implementation flag Thedefault value is DDS You can use the followingprocedure to assign a value to a specific access pathwhen it is built The options you have are DDS SQLand UNX
Changing Values
Building Access Paths BAP 2 ndash 5
882019 2 Setup
httpslidepdfcomreaderfull2-setup 68
Changing theGenerationMode at theAccess PathLevel
To change the generation mode for a specific accesspath at the access path level
1 Zoom into the file At the Edit Database Relationspanel type Z next to the relations for the file and
press Enter
The Edit File Details panel displays
2 Zoom into the access path Type Z next to theaccess path whose generation mode you want tochange and press Enter
The Edit Access Path Details panel displays
3 Change the generation mode Type the character
that represents the new generation model value
Your options are
D for DDS
S for SQL
X for UNIX
M for MDLVAL
Note If an access path specifies M for MDLVAL when itis generated it will use the current value for the
YDBFGEN model value If you want to overridethis value enter D S or X The default is M
4 Press Enter
Changing Values
BAP 2 ndash 6 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 78
Changing Compiler Overrides
Within Synon2E there are various properties of theOS400 database files that you can modify byspecifying compiler overrides The overrides are the
parameters on the compiler commands
Synon2E allows you to prompt for and store theseoverrides that are then automatically applied by thecompile pre-processor when you compile yourprograms
Some of the overrides you can specify are
bull Physical files OS400 Create Physical File(CRTPF) command
bull MAXMBRS SIZE
Note MAXMBRS is a parameter that specifies themaximum number of members the file canhold
bull Logical files OS400 Create Logical File (CRTLF)command
bull MAXMBRS DTAMBRS
Note Some of the compile parameters (MAINTTEXT) are specified by the access pathdetails Override values should not bespecified for these values
For more informationon how to prompt for and store overrides referto this modulersquos Chapter 7 ldquoGenerating andCompilingrdquo Changing Compiler Overrides topic
on the OS400 commands refer to IBM AS400 CL Command Reference
Changing Compiler Overrides
Building Access Paths BAP 2 ndash 7
882019 2 Setup
httpslidepdfcomreaderfull2-setup 88
Changing Compiler Overrides
BAP 2 ndash 8 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 48
The Edit Access Path Details panel displays
Op YOU DSP32 63094 134026
EDIT ACCESS PATH DETAILS MYMDL
File name Access path name Unique or duplicate order
Index maintenance option Alternate collating table
Allow selectomit Generation mode Source member name
Source member text
Customer Attribute REF Retrieval index Type RTV
U (U-UniqueF-FIFOL-LIFOC-FCFOrsquo rsquo-Undefined)
I (I-IMMED D-DLY R-RBLD)
(S-Static D-Dynamic -None) M (M-MDLVAL D-DDS S-SQL X-UNX) MYAGREL1
Customer _ Retrieval Index
Format
Seq name1 FAGREAV
GEN
pfxAG
Format text
(Based on file)Customer
Associated
Update access pathUpdate index
SEL Z-Entries R-Relations S-Selectomit A-Associated acps T-Trim V-Virtualize
F3=Exit F8=Rename F20=Narrative
3 Enter the new source member name Type the newsource member name in the source member nameoption field and press Enter
ControllingAuxiliary Names
Synon2E generates default values for the three accesspath auxiliaries created when you define a Query(QRY) access path These three auxiliaries apply toDDS generation Change the name of the auxiliaries byusing the following procedure
1 Zoom into the file At the Edit Database Relationspanel type Z next to the relation for the file and pressEnter
The Edit File Details panel displays
2 Zoom into the QRY access path Type Z next to theselected QRY access path and press Enter
The Edit Access Path Details panel displays with thedetails for the QRY access path
Changing Values
BAP 2 ndash 4 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 58
3 View the QRY auxiliaries Press F7 to view the QRYaccess path auxiliaries
The Edit Access Path Auxiliaries panel displays
4 Type the new source member names and pressEnter
Creating an SQLEnvironment
Using SQL facilitates the portability of generatedapplications and is the only means of database accessacross machines in Distributed Relational DatabaseArchitecture (DRDA)
For more informationon DRDA refer to this module Chapter 4
ldquoModifying Access Pathsrdquo Building DistributedRelational Database Applications topic
Generating and Implementing Applications Chapter 7 ldquoDistributed Relational DatabaseArchitecturerdquo
To create SQL tables and views for your model youneed an SQL library known as a collection Thiscollection contains the SQL objects including thecatalogue a data dictionary a journal and two journal
receivers
When creating an SQL environment use one of thefollowing
bull SQLLIB parameter on the YCRTMDLLIB commandcreates a collection library name with MDL replacedby SQL or a name of your choosing
bull Create SQL Library (YCRTSQLLIB) commandcreates a collection and links it to a model
SpecifyingGeneration Mode
The choice of which generation mode to use iscontrolled by the Database File Generation (YDBFGEN)model value that acts as an implementation flag Thedefault value is DDS You can use the followingprocedure to assign a value to a specific access pathwhen it is built The options you have are DDS SQLand UNX
Changing Values
Building Access Paths BAP 2 ndash 5
882019 2 Setup
httpslidepdfcomreaderfull2-setup 68
Changing theGenerationMode at theAccess PathLevel
To change the generation mode for a specific accesspath at the access path level
1 Zoom into the file At the Edit Database Relationspanel type Z next to the relations for the file and
press Enter
The Edit File Details panel displays
2 Zoom into the access path Type Z next to theaccess path whose generation mode you want tochange and press Enter
The Edit Access Path Details panel displays
3 Change the generation mode Type the character
that represents the new generation model value
Your options are
D for DDS
S for SQL
X for UNIX
M for MDLVAL
Note If an access path specifies M for MDLVAL when itis generated it will use the current value for the
YDBFGEN model value If you want to overridethis value enter D S or X The default is M
4 Press Enter
Changing Values
BAP 2 ndash 6 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 78
Changing Compiler Overrides
Within Synon2E there are various properties of theOS400 database files that you can modify byspecifying compiler overrides The overrides are the
parameters on the compiler commands
Synon2E allows you to prompt for and store theseoverrides that are then automatically applied by thecompile pre-processor when you compile yourprograms
Some of the overrides you can specify are
bull Physical files OS400 Create Physical File(CRTPF) command
bull MAXMBRS SIZE
Note MAXMBRS is a parameter that specifies themaximum number of members the file canhold
bull Logical files OS400 Create Logical File (CRTLF)command
bull MAXMBRS DTAMBRS
Note Some of the compile parameters (MAINTTEXT) are specified by the access pathdetails Override values should not bespecified for these values
For more informationon how to prompt for and store overrides referto this modulersquos Chapter 7 ldquoGenerating andCompilingrdquo Changing Compiler Overrides topic
on the OS400 commands refer to IBM AS400 CL Command Reference
Changing Compiler Overrides
Building Access Paths BAP 2 ndash 7
882019 2 Setup
httpslidepdfcomreaderfull2-setup 88
Changing Compiler Overrides
BAP 2 ndash 8 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 58
3 View the QRY auxiliaries Press F7 to view the QRYaccess path auxiliaries
The Edit Access Path Auxiliaries panel displays
4 Type the new source member names and pressEnter
Creating an SQLEnvironment
Using SQL facilitates the portability of generatedapplications and is the only means of database accessacross machines in Distributed Relational DatabaseArchitecture (DRDA)
For more informationon DRDA refer to this module Chapter 4
ldquoModifying Access Pathsrdquo Building DistributedRelational Database Applications topic
Generating and Implementing Applications Chapter 7 ldquoDistributed Relational DatabaseArchitecturerdquo
To create SQL tables and views for your model youneed an SQL library known as a collection Thiscollection contains the SQL objects including thecatalogue a data dictionary a journal and two journal
receivers
When creating an SQL environment use one of thefollowing
bull SQLLIB parameter on the YCRTMDLLIB commandcreates a collection library name with MDL replacedby SQL or a name of your choosing
bull Create SQL Library (YCRTSQLLIB) commandcreates a collection and links it to a model
SpecifyingGeneration Mode
The choice of which generation mode to use iscontrolled by the Database File Generation (YDBFGEN)model value that acts as an implementation flag Thedefault value is DDS You can use the followingprocedure to assign a value to a specific access pathwhen it is built The options you have are DDS SQLand UNX
Changing Values
Building Access Paths BAP 2 ndash 5
882019 2 Setup
httpslidepdfcomreaderfull2-setup 68
Changing theGenerationMode at theAccess PathLevel
To change the generation mode for a specific accesspath at the access path level
1 Zoom into the file At the Edit Database Relationspanel type Z next to the relations for the file and
press Enter
The Edit File Details panel displays
2 Zoom into the access path Type Z next to theaccess path whose generation mode you want tochange and press Enter
The Edit Access Path Details panel displays
3 Change the generation mode Type the character
that represents the new generation model value
Your options are
D for DDS
S for SQL
X for UNIX
M for MDLVAL
Note If an access path specifies M for MDLVAL when itis generated it will use the current value for the
YDBFGEN model value If you want to overridethis value enter D S or X The default is M
4 Press Enter
Changing Values
BAP 2 ndash 6 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 78
Changing Compiler Overrides
Within Synon2E there are various properties of theOS400 database files that you can modify byspecifying compiler overrides The overrides are the
parameters on the compiler commands
Synon2E allows you to prompt for and store theseoverrides that are then automatically applied by thecompile pre-processor when you compile yourprograms
Some of the overrides you can specify are
bull Physical files OS400 Create Physical File(CRTPF) command
bull MAXMBRS SIZE
Note MAXMBRS is a parameter that specifies themaximum number of members the file canhold
bull Logical files OS400 Create Logical File (CRTLF)command
bull MAXMBRS DTAMBRS
Note Some of the compile parameters (MAINTTEXT) are specified by the access pathdetails Override values should not bespecified for these values
For more informationon how to prompt for and store overrides referto this modulersquos Chapter 7 ldquoGenerating andCompilingrdquo Changing Compiler Overrides topic
on the OS400 commands refer to IBM AS400 CL Command Reference
Changing Compiler Overrides
Building Access Paths BAP 2 ndash 7
882019 2 Setup
httpslidepdfcomreaderfull2-setup 88
Changing Compiler Overrides
BAP 2 ndash 8 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 68
Changing theGenerationMode at theAccess PathLevel
To change the generation mode for a specific accesspath at the access path level
1 Zoom into the file At the Edit Database Relationspanel type Z next to the relations for the file and
press Enter
The Edit File Details panel displays
2 Zoom into the access path Type Z next to theaccess path whose generation mode you want tochange and press Enter
The Edit Access Path Details panel displays
3 Change the generation mode Type the character
that represents the new generation model value
Your options are
D for DDS
S for SQL
X for UNIX
M for MDLVAL
Note If an access path specifies M for MDLVAL when itis generated it will use the current value for the
YDBFGEN model value If you want to overridethis value enter D S or X The default is M
4 Press Enter
Changing Values
BAP 2 ndash 6 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 78
Changing Compiler Overrides
Within Synon2E there are various properties of theOS400 database files that you can modify byspecifying compiler overrides The overrides are the
parameters on the compiler commands
Synon2E allows you to prompt for and store theseoverrides that are then automatically applied by thecompile pre-processor when you compile yourprograms
Some of the overrides you can specify are
bull Physical files OS400 Create Physical File(CRTPF) command
bull MAXMBRS SIZE
Note MAXMBRS is a parameter that specifies themaximum number of members the file canhold
bull Logical files OS400 Create Logical File (CRTLF)command
bull MAXMBRS DTAMBRS
Note Some of the compile parameters (MAINTTEXT) are specified by the access pathdetails Override values should not bespecified for these values
For more informationon how to prompt for and store overrides referto this modulersquos Chapter 7 ldquoGenerating andCompilingrdquo Changing Compiler Overrides topic
on the OS400 commands refer to IBM AS400 CL Command Reference
Changing Compiler Overrides
Building Access Paths BAP 2 ndash 7
882019 2 Setup
httpslidepdfcomreaderfull2-setup 88
Changing Compiler Overrides
BAP 2 ndash 8 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 78
Changing Compiler Overrides
Within Synon2E there are various properties of theOS400 database files that you can modify byspecifying compiler overrides The overrides are the
parameters on the compiler commands
Synon2E allows you to prompt for and store theseoverrides that are then automatically applied by thecompile pre-processor when you compile yourprograms
Some of the overrides you can specify are
bull Physical files OS400 Create Physical File(CRTPF) command
bull MAXMBRS SIZE
Note MAXMBRS is a parameter that specifies themaximum number of members the file canhold
bull Logical files OS400 Create Logical File (CRTLF)command
bull MAXMBRS DTAMBRS
Note Some of the compile parameters (MAINTTEXT) are specified by the access pathdetails Override values should not bespecified for these values
For more informationon how to prompt for and store overrides referto this modulersquos Chapter 7 ldquoGenerating andCompilingrdquo Changing Compiler Overrides topic
on the OS400 commands refer to IBM AS400 CL Command Reference
Changing Compiler Overrides
Building Access Paths BAP 2 ndash 7
882019 2 Setup
httpslidepdfcomreaderfull2-setup 88
Changing Compiler Overrides
BAP 2 ndash 8 Building Access Paths
882019 2 Setup
httpslidepdfcomreaderfull2-setup 88
Changing Compiler Overrides
BAP 2 ndash 8 Building Access Paths
