Try OpenEdge Now
skip to main content
Database Administration
Database Basics : Creating and Deleting Databases : PRODB maintains pathname convention
 

PRODB maintains pathname convention

When you use the PRODB utility, the target database you create maintains the same pathname convention, relative or absolute, as the source database. For example, if you use PRODB to create a database and name it example1, and use a relative path database such as sports2000 as the source database, PRODB maintains the pathname convention of sports2000 (the source database), and example1 (the target database) becomes a relative path database. Conversely, if the source database is an absolute path database, the target database you create with PRODB will also be an absolute path database. Use PROSTRCT LIST to verify whether the pathname is relative or absolute. For example:
prodb example1 sports2000
prostrct list example1
In the following sample output of the PROSTRCT LIST utility, note dot (.) notation of the relative pathname of the database, example1.db:
Area Name: Control Area, Type 6, BlockSize 4096, Extents 1, Records/Block32,
Cluster Size 1
Ext # 1, Type VARIABLE, Size 32 KByte, Name: ./example1.db

Area Name: Primary Recovery Area, Type 3, BlockSize 8192, Extents 1
Ext # 1, Type VARIABLE, Size 2176, Name: ./example1.b1

Area Name: Schema Area, Type 6, BlockSize 4096, Extents 1, Records/Block 32,
Cluster Size 1
Ext # 1, Type VARIABLE, Size 960 KByte, Name: ./example1.d1

Area Name: Info, Type 6, BlockSize 4096, Extents 1, Records/Block 32,
Cluster Size 1
   Ext #1, Type VARIABLE, Size 192 KByte, Name: ./example1_7.d1

Area Name: Order, Type 6, BlockSize 1024, Extents 1, Records/Block 32,
Cluster Size 1
Ext # 1, Type FIXED , Size 1280, Name: ./example1_8.d1
Note: See OpenEdge Getting Started: Database Essentials for an explanation of relative- and absolute-pathnames. See Maintaining Database Structure for information about changing pathname conventions when adding storage areas and extents to a structure description file.