212 SEGMENT_NAME= Data Set Option Chapter 10
libname mydblib oracle user=testuser password=testpass path="myorapath";
proc print data=employees (schema=scott);
run;
In the following example, user TESTUSER prints the contents of the Employees
table, which is located in the Donna database.
libname mydblib teradata user=testuser pw=testpass;
proc print data=mydblib.employees(schema=donna);
run;
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “SCHEMA= LIBNAME Option” on page 123.
SEGMENT_NAME= Data Set Option
Enables you to control the segment in which you create a table
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: SYBASE
Default value: none
Syntax
SEGMENT_NAME=segment-name
Syntax Description
segment-name
specifies the name of the segment in which to create a table.
TRAP151= Data Set Option
Enables non-updatable columns to be removed from a FOR UPDATE OF clause so updating of
columns can proceed as normal
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 OS/390
Default value: NO
Syntax
TRAP151=YES | NO
