At the ACCENT R ICL (Interactive Command Language) level you can create an Oracle table, attach to an existing Oracle table, or remove an Oracle table. An Oracle table is equivalent to an ACCENT R Data Set, so the normal ACCENT R commands are used to manipulate Oracle tables.
The CREATE DS command lets you specify an ACCENT R Schema Definition (SD) that is used to create a new table or to attach to an existing table. The Schema Definition object contains the Oracle table definition.
The REMOVE DS command lets you remove any Oracle table that has a Data Set object in your DBL.
Figure 14 below shows the relationship between a Schema Definition (SD) object, a Data Set object, and an Oracle table. The SD object is stored in the Data Base Library (DBL) so that it is accessible to ACCENT R Open SQL and the entire ACCENT R 4GL and 4th Generation Tool Set. In ACCENT R, a set of statements called a Schema Definition describes a Data Set. A Schema Definition is stored in a separate DBL object. The name of that object is specified when giving the command that creates the Data Set. The same Schema Definition can be used to create many Data Sets with the same format.
In a relational database management system, users see data as tables (also known as relations). Each row (or record or multiple) of a table describes one occurrence of an entity. Each column (or field or attribute) describes one characteristic of the entity.
Oracle tables with identical columns can be created with a single Schema Definition in ACCENT R.
Figure 14 Relationship between a Schema Definition, Data Set and a Table
Figure 14 shows that the Schema Definition named XX was used to create two Oracle tables called Table A and Table B. Both of these tables have a Data Set object in the DBL. For purposes of comparison, the Schema Definition YY was used to create a DB-MACH2 Data Set.
