Hi guys

I try to use the Procedure PROC DBLOAD in SAS system language with connection DB2 database named CB01
here the program i try to run



234 PROC dbload dbms=db2 data=a ;
235 in pbbbe5e.bbbe5e ;
236 database='cb01' ;
237 user='bbbe5e';
238 using=XXXXXXXXX;
239 table = bbbe5e.x1;
240 limit=0 ;
241 commit=100 ;
242 errlimit=10 ;
243 load ;
244 run ;

ERROR: CLI execute error: [IBM][CLI Driver][DB2] SQL0551N "BBBE5E" does not have the privilege to
perform operation "CREATE TABLE" on object "DSNDB04 ". SQLSTATE=42501
NOTE: Load ended due to errors. See the log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE DBLOAD used:
real time 0.17 seconds
cpu time 0.02 seconds


And the same try with a sysadm user mikevw

ROC dbload dbms=db2 data=a ;
in mikevwc1.mikevw ;
database='cb01' ;
user='mikevw';
using='sidney';
table = mikevw.x1;
limit=0 ;
commit=100 ;
errlimit=10 ;
load ;
run ;

LOG



256 PROC dbload dbms=db2 data=a ;
257 in mikevwc1.mikevw ;
258 database='cb01' ;
259 user='mikevw';
260 using=XXXXXXXX;
261 table = mikevw.x1;
262 limit=0 ;
263 commit=100 ;
264 errlimit=10 ;
265 load ;
266 run ;

ERROR: CLI execute error: [IBM][CLI Driver][DB2] SQL0904N Unsuccessful execution caused by an
unavailable resource. Reason code: "00D70001", type of resource: "00000500", and resource
name: "SYSDEFLT ". SQLSTATE=57011
NOTE: Load ended due to errors. See the log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE DBLOAD used:
real time 0.73 seconds
cpu time 0.02 seconds

The key word "Database" has a different meaning in SAS that to DB2 OS/390
In SAS database is the SSID of th DB2 OS/390 environment and in DB2 OS/390 the meaning of "database" is le the name before tablespace name including in the IN clause

Has anybody seen this error yet ??
Please i need your help ...

Thanks a lot for your replies !!!

Sidnet