Browsing and Updating ADABAS Data

Browsing and Updating ADABAS Data with the SQL Procedure

The SAS SQL procedure enables you to retrieve and update ADABAS data. You can retrieve and browse ADABAS data by specifying a view descriptor in a PROC SQL SELECT statement.

To update the data, you can specify view descriptors in the PROC SQL DELETE, INSERT, and UPDATE statements. You must have access to the data through appropriate ADABAS and NATURAL security options before you can edit ADABAS data. Here is a summary of the pertinent PROC SQL statements:

DELETE	deletes logical records from an ADABAS file.
INSERT	inserts logical records in an ADABAS file.
SELECT	retrieves and displays data from an ADABAS file. A SELECT statement is usually referred to as a query because it queries the ADABAS file for information.
UPDATE	updates values in an ADABAS file.

When using the SQL procedure, note that the data is displayed in the SAS OUTPUT window. The procedure displays output data automatically without using the PRINT procedure and executes without using the RUN statement when an SQL procedure statement is executed.

Top of Page