SCHEMA=

SCHEMA=

Enables you to read database objects, such as tables and views, in the specified schema.

Default value: None

Syntax
Details

Syntax

SCHEMA= schema-name

Details

A schema is a logical classification of objects in a database. SCHEMA= is optional. If it is omitted, you connect to the default schema. In the following example, the SCHEMA= option causes MYDB.TEMP_EMPS to be interpreted by DB2 as SCOTT.TEMP_EMPS.

proc print data=mydb.temp_emps   
    SCHEMA=scott; 
run;

Chapter Contents
Previous
Next
Top of Page