ACCESS Procedure Reference |
Adds new records, groups, or items to an existing access descriptor.
Optional statement |
|
Applies to: |
access descriptor
|
Interacts with: |
UPDATE statement
|
INSERT|INS item-name
<... item-name-n>;
|
The INSERT statement is a positioning
statement; it inserts the RECORD=, GROUP=, or ITEM= statements following it
after the item it references. The syntax and use of the RECORD=, GROUP=, and
ITEM= statements are the same in update mode as they are in create mode.
Although the INSERT statement can reference only one
item, more than one RECORD=, GROUP=, or ITEM= statement can follow an INSERT
statement. The INSERT statement retains control until it encounters an editing,
LIST, DELETE, or REPLACE statement, or the ACCESS procedure ends through a
QUIT, RUN, or other procedure statement. Multiple INSERT statements can be
used in one UPDATE statement. When more than one INSERT statement references
the same item, the most recent update displays as first.
The following arguments can appear in
a INSERT statement:
-
item-number
-
is an index number that represents the item's
place in the access descriptor. You can get the index number of an item by
using the LIST statement described later in this section.
-
item-name
-
is the name of the IMS group, record, or
item after which subsequent groups, records, or items will be inserted. This
field can also contain a quoted string.
The following is an example of an INSERT
statement. A new record and item are inserted at the beginning of the access
descriptor ADLIB.CUSTINS. "INSERT 0" inserts items at the beginning
of the descriptor. The first item in an access descriptor must always be a
record. Also in the example, note that the first LIST statement prints a pre-update
listing of the database as defined by the access descriptor, while the second
prints a post-update listing.
proc access dbms=ims;
update adlib.custins.access;
list all db;
insert 0;
record=newfrec sg=newrecsg sl=400;
item=newfitem lv=3 dbf=$12. se=custfsti;
list all db;
run;
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.