By default, rows are
not committed to an in-memory table until the DATA step completes.
That is, the rows are held in intermediate storage areas in the server
and are not included in requests for data or computational results
until the DATA step completes. If you specify AUTOCOMMIT=
n or
AUTOCOMMIT=
nR, then the server
commits the rows when at least
n rows
have been received.
If you specify AUTOCOMMIT=
kS,
the server commits any rows received within
k seconds
of the start of the Append operation or within
k seconds
of the previous commit.