To query or update data in a CA-Datacom database, you must create a relational table that maps to that database. You can also create a view on the table to filter record types or to filter rows and columns.
Before you begin
If you use the CA-Datacom DDUTILITY to generate COBOL copybooks, edit the resulting copybooks to remove any $ characters that might be present.
Restrictions
About this task
One or more FIELD entities are associated with a table in a CA-Datacom database. These FIELD definitions describe the contents of the table. In the CA-Datacom documentation, FIELD entities are also referred to as columns when the SQL option is used to access the CA-Datacom table. The online help does not use the term column to refer to a CA-Datacom FIELD entity.
The table that you map to must have one or more CA-Datacom ELEMENT definitions associated with it. A CA-Datacom ELEMENT definition refers to one or more contiguous CA-Datacom FIELD entities and is the unit of data transfer between Classic federation and a CA-Datacom database.
Use the New CA-Datacom Table wizard to create the table and optionally the view. For more information about creating tables and views that map to CA-Datacom databases, see the related links for CA-Datacom syntax diagrams and for views.
Procedure
To create a CA-Datacom table and optionally a view for Classic federation: