Fujitsu UDS/SQL V2.5 사용자 설명서
Relational schema
User interface
196
U929-J-Z125-9-76
6.2 Relational schema
The schema DDL can be used to create a schema complying with relational rules or with
CODASYL rules. A schema defined according to relational rules contains no set relation-
ships, and the primary and foreign keys are defined by the user.
CODASYL rules. A schema defined according to relational rules contains no set relation-
ships, and the primary and foreign keys are defined by the user.
If a schema was defined according to CODASYL rules, the utility routine BPSQLSIA can be
used to provide SQL programmers with a relational view of the CODASYL subschema.
used to provide SQL programmers with a relational view of the CODASYL subschema.
The BPSQLSIA utility routine analyzes all the objects in a subschema and represents them
as objects in a relational database.
as objects in a relational database.
The list resulting from the conversion by BPSQLSIA contains all the information that
programmers need to work with SQL.
programmers need to work with SQL.
If a CODASYL subschema is to be processed on a completely relational basis with SQL, it
must satisfy certain requirements. Restrictions and notes on DDL, SSL and subschema
DDL can be found in the relevant chapters.
must satisfy certain requirements. Restrictions and notes on DDL, SSL and subschema
DDL can be found in the relevant chapters.
A description of the BPSQLSIA utility routine, including an overview of the relevant restric-
tions and an example, is provided in another UDS/SQL manual (see the "
tions and an example, is provided in another UDS/SQL manual (see the "
" manual, BPSQLSIA).