The connection to the remote DB2 subsystem is done implicitly by DB2 when DB2 receives a three-level table name in an SQL statement. LOCATION= is optional. If you omit it, SAS accesses the data from ...

Database identification statements are required only when you create access descriptors. Because DB2 information is stored in an access descriptor, you do not need to repeat this information when you ...