SAS/ACCESS Software for Relational Databases: Reference

Introduction

This chapter introduces SAS System users to Database 2 (DB2), IBM's relational database management system for OS/390. It accompanies and should be used with SAS/ACCESS Software for Relational Databases: Reference (order # 57204).(footnote 1)

This chapter describes the SAS/ACCESS LIBNAME and data set options that are specific to DB2. It then focuses on the terms, basic concepts, and options that help you use the SAS/ACCESS interface to DB2. Next, it describes the DB2-specific options and statements that you use in the ACCESS and DBLOAD procedures and in the SQL procedure's CONNECT statement. The statements include those that are necessary to accommodate IBM's addition of DRDA support for DB2. Also documented in this chapter is a Version 5 procedure, DB2UTIL, which enables you to make modifications to a DB2 table using a SAS data set. Finally, there are some tips for improving your performance and some DB2-specific information for the database administrator.

Chapter Contents
Previous
Next
Top of Page