Specifies whether to ignore or include columns whose data types are read-only when generating an SQL statement for inserts or updates.
Valid in: | LIBNAME statement |
Default: | NO |
Supports: | DB2 under UNIX and PC, Greenplum, MySQL, ODBC, Oracle, Teradata |
specifies to ignore columns whose data types are Read-Only when generating INSERT and UPDATE statements.
specifies to include columns whose data types are Read-Only when generating INSERT and UPDATE statements
create table products (id int identity primary key, product_name varchar(40))
data work.products; id=1; product_name='screwdriver'; output; id=2; product_name='hammer'; output; id=3; product_name='saw'; output; id=4; product_name='shovel'; output; run;
libname x fedsvr server="d1234.us.company.com" port=2171 user=user1 pwd=pass1 dsn=db2dsn ignore_read_only_columns=yes; options sastrace=',,,d' sastraceloc=saslog nostsuffix; proc append base=x.products data=work.products; run;