Browsing and Updating ADABAS Data

Inserting and Deleting Data with the INSERT and DELETE Statements

You can use the INSERT statement to add logical records to an ADABAS file or the DELETE statement to remove logical records. In the following example, the logical record containing the CUSTOMER value 15432147 is deleted by using the CUSTOMERS DDM. The SELECT statement then displays the VLIB.USACUST data in the following output, ordering them again by the CUSTOMER data field.

delete from vlib.usacust
   where custnum='15432147';
   title 'Logical Record Deleted from 
      CUSTOMERS';
select custnum, state, name, limit, signatur
   from vlib.usacust;

Results of Deleting Data with the DELETE Statement

                                 Updated ADABAS Data in CUSTOMERS                               

CUSTOMER  STATE  NAME                                                                       LIMIT
SIGNATURE
-------------------------------------------------------------------------------------------------
12345678  NC     DURHAM SCIENTIFIC SUPPLY COMPANY                                         5000.00
MARC PLOUGHMAN

14324742  CA     SANTA CLARA VALLEY TECHNOLOGY SPECIALISTS                                5000.00
BOB HENSON

14324742  CA     SANTA CLARA VALLEY TECHNOLOGY SPECIALISTS                               25000.00
KAREN DRESSER

14569877  NC     PRECISION PRODUCTS                                                       5000.00
JEAN CRANDALL

14569877  NC     PRECISION PRODUCTS                                                     100000.00
STEVE BLUNTSEN

14898029  MD     UNIVERSITY BIOMEDICAL MATERIALS                                         10000.00
MASON FOXWORTH

14898029  MD     UNIVERSITY BIOMEDICAL MATERIALS                                         50000.00
DANIEL STEVENS

14898029  MD     UNIVERSITY BIOMEDICAL MATERIALS                                        100000.00
ELIZABETH PATTON

18543489  TX     LONE STAR STATE RESEARCH SUPPLIERS                                      10000.00
NANCY WALSH

18543489  TX     LONE STAR STATE RESEARCH SUPPLIERS                                      50000.00
TED WHISTLER

18543489  TX     LONE STAR STATE RESEARCH SUPPLIERS                                     100000.00
EVAN MASSEY

19783482  VA     TWENTY-FIRST CENTURY MATERIALS                                           5000.00
PETER THOMAS

19783482  VA     TWENTY-FIRST CENTURY MATERIALS                                          10000.00
LOUIS PICKERING

19876078  CA     SAN JOAQUIN SCIENTIFIC AND INDUSTRIAL SUPPLY, INC.                       7500.00
EDWARD LOWE

19876078  CA     SAN JOAQUIN SCIENTIFIC AND INDUSTRIAL SUPPLY, INC.                      25000.00
E.F. JENSEN

CAUTION:: Always use the WHERE clause in a DELETE statement.
If you omit the WHERE clause from a DELETE statement, you delete all the data in the ADABAS file that is accessed by the view descriptor.

For more information about SAS SQL procedure, see the SQL section in the Base SAS Procedures Guide.

Top of Page