When you run a task in SAS Enterprise Guide against a pre-assigned DB2 library under z/OS, the following errors might appear in the SAS Enterprise Guide log:

2          OPTIONS PAGENO=MIN;
3          %eclibassign(DB2LIB,DB2,DB2,%str(schema='sasschema'
           USER='sasuser' PASSWORD='password'
4          '));
ERROR 22-7: Invalid option name USER.
ERROR 22-7: Invalid option name PASSWORD.
WARNING: Libref DB2LIB could not be assigned

Note that the task completes successfully, despite the errors in the log.

You should complete the following steps to prevent the password from being displayed in the log:

1. Open SAS^® Management Console.
2. Right-click DB2 library and select Properties.
3. Select the Extended Attributes tab.
4. Click New to add the attribute LoginMode with the value of None.
5. Click New again to add the attribute AssignMode with the value of 0
   (Using a value of 0 gives a result similar to being pre-assigned).

Although the following error will appear in your SAS log, the task will complete successfully.

  WARNING: Apparent invocation of macro ECLIBASSIGN not resolved.
  ERROR 180-322: Statement is not valid or it is used out of proper order.
2          OPTIONS PAGENO=MIN;
3          %eclibassign(DB2LIB,DB2,DB2,%str(schema='sasschema' ));
           _
           180

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for Enterprise Guide 4.1 is available at: