This option determines
how the
SAS/ACCESS engine handles rows that contain data values that
exceed the length of the DBMS column.
DBFORCE= works only when you create a DBMS table with the DBTYPE=
data set option—namely, you must specify both DBTYPE= and this
option. DBFORCE= does not work for inserts or updates. Therefore,
to insert or update a DBMS table, you cannot use the DBFORCE= option—you
must instead specify the options that are available with SAS procedures.
For example, specify the FORCE= data set option in SAS with PROC
APPEND.
FORCE= overrides DBFORCE=
when you use FORCE= with PROC APPEND or the PROC SQL UPDATE statement.
PROC SQL UPDATE does not warn you before it truncates data.