libname d db2 user=dbitest pw=dbigrp1 schema=sysibm qualifier=sample
db=sample;

NOTE: Libref D was successfully assigned as follows:
      Engine:        DB2
      Physical Name: sample

options sastrace=',,,d' sastraceloc=saslog;
proc sql;
create table work.test as select distinct name from d.systables;

DB2: AUTOCOMMIT turned ON for connection id 0 0 1184677962 xoopen 0 SQL
  1 1184677962 du_prep 0 SQL
DB2_1: Prepared: 2 1184677962 du_prep 0 SQL
SELECT * FROM sample.sysibm.SYSTABLES FOR READ ONLY  3 1184677962 du_prep 0
SQL
  4 1184677962 du_prep 0 SQL
DB2: COMMIT performed on connection 0. 5 1184677962 du_comm 0 SQL
  6 1184677962 du_prep 0 SQL
DB2_2: Prepared: 7 1184677962 du_prep 0 SQL
 select distinct sysibm.systables."NAME" from sysibm.SYSTABLES FOR READ ONLY
8 1184677962 du_prep 0 SQL
  9 1184677962 du_prep 0 SQL
DB2: COMMIT performed on connection 0. 10 1184677962 du_comm 0 SQL
  11 1184677962 du_exec 0 SQL
DB2_3: Executed: 12 1184677962 du_exec 0 SQL
Prepared statement DB2_2 13 1184677962 du_exec 0 SQL
  14 1184677962 du_exec 0 SQL
ACCESS ENGINE:  SQL statement was passed to the DBMS for fetching data.  15
1184677962 sqlloop 0 SQL
NOTE: Table WORK.TEST created, with 286 rows and 1 columns.

create table work.test as select name from d.systables;

  16 1184678010 du_prep 0 SQL
DB2_4: Prepared: 17 1184678010 du_prep 0 SQL
SELECT * FROM sample.sysibm.SYSTABLES FOR READ ONLY  18 1184678010 du_prep 0
SQL
  19 1184678010 du_prep 0 SQL
DB2: COMMIT performed on connection 0. 20 1184678010 du_comm 0 SQL
  21 1184678010 du_prep 0 SQL
DB2_5: Prepared: 22 1184678010 du_prep 0 SQL
SELECT  "NAME"  FROM sample.sysibm.SYSTABLES  FOR READ ONLY  23 1184678010
du_prep 0 SQL
  24 1184678010 du_prep 0 SQL
DB2: COMMIT performed on connection 0. 25 1184678010 du_comm 0 SQL
  26 1184678010 du_exec 0 SQL
DB2_6: Executed: 27 1184678010 du_exec 0 SQL
Prepared statement DB2_5 28 1184678010 du_exec 0 SQL
  29 1184678010 du_exec 0 SQL
NOTE: Table WORK.TEST created, with 336 rows and 1 columns.
  7? quit;