Accessing Data Sources

In this section:

To access a data source using Maintain you must identify the data source to:


Top of page

x
Reading From Data Sources

Maintain can read many kinds of data sources, including DB2, Teradata, and FOCUS databases, and VSAM and fixed-format sequential data files. Maintain reads data sources using the NEXT and MATCH commands.

Maintain can read data sources to which the operating system does not permit write access.

Maintain can read individual and joined data sources. Maintain supports joins that are defined in the Master File. For information about defining joins in the Master File, see the FOCUS Interface documentation for the types of data sources that you wish to join, and the Describing Data manual for FOCUS data sources.

If a database administrator has applied FOCUS DBA security to a data source, and you wish to read:

Maintain supports DBA except for the VALUE and NOPRINT attributes. See the Describing Data manual for information about DBA.


Top of page

x
Writing to Data Sources

Maintain can write to many kinds of data sources, including DB2, Teradata, and FOCUS databases, and VSAM data files. Maintain writes to data sources using the INCLUDE, UPDATE, REVISE, and DELETE commands.

If your database administrator has applied FOCUS DBA security to a data source, the DBA specification must grant you access privileges of write (W), read/write (RW), or update (U). Each of these enables you to write to and read from the data source using any Maintain data source command; with regard to Maintain, these three DBA access privileges are equivalent.

Maintain supports DBA except for the VALUE and NOPRINT attributes. See the Describing Data manual for information about DBA.


Information Builders