DBFORCE=

DBFORCE=

Specifies whether to force the truncation of data during insert processing.

Default value: NO

See Also: DBTYPE=

Syntax
Details

Syntax

DBFORCE=YES | NO

YES: inserts rows into the specified DBMS table, truncating data values that exceed the length of the DBMS column.
NO: does not insert rows into the specified DBMS table when data values exceed the length of the DBMS column.

Details

The DBFORCE= option is overridden by the FORCE option when it is used with PROC APPEND or when used with the PROC SQL UPDATE statement. The PROC SQL UPDATE statement does not provide a warning before truncating the data.

In the following example, two librefs are associated with ORACLE databases; the default databases and schemas are used and therefore are not specified. In the DATA step, MYDBLIB.DEPT is created from the ORACLE data referenced by MYORALIB.STAFF. The LASTNAME variable is a character variable of length 20 in MYORALIB.STAFF. During the creation of MYDBLIB.DEPT, the LASTNAME variable is stored as a column of type character and length 10 by using DBFORCE=YES.

libname myoralib oracle user=tester1 password=tst1;
libname mydblib oracle user=lee password=dataman;

data mydblib.dept(dbtype=(lastname='char(10)') 
     dbforce=yes);
  set myoralib.staff;
run;

See your DBMS chapter for details on the option values that are supported by your DBMS.

Chapter Contents
Previous
Next
Top of Page