Problem Note 7859: Setting a special register via DBCONINIT does not always work
A special register can be set via the LIBNAME statement option
DBCONINIT=. However, it appears that the special setting is no longer in
effect when the subsequent query is processed by DB2. Rather, the
default value is used. This can cause parallelism to not occur (degree=)
or precision to be an issue (precision=).
The only workaround is to switch to the SQL Pass Thru Facility and
issue the command and the query in the same step.
proc sql;
connect to db2(ssid=your-db2-subsystem);
execute(set current precision='DEC31') by db2;
create table test as
select * from connection to db2
( ... your DB2 query that is dependent on the precision being
set to dec31);
disconnect from db2;
quit;
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#007859
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 8 TS M0 | 9.1 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2 SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2003-06-20 10:22:48 |
| Date Created: | 2002-06-25 15:41:00 |