|
Hi Again
Tank you all for your participation !!!
I have tried with CNTLLEV=REC and 'REREAD_EXPOSURE=YES' and i did get me
further.
Then a had a fonny expirience with the KEY that sas cutn't find.
I solved it by renaming the index name to the same as the columnname.
But now it is the OBC driver witch is making trouble.
I am surre that I can update DB2 via ODBC , because I can make tables from
SAS in DB2 and inserting is also working fine..
I have also sertch SAS home pages, without result.
Recards Tom
and Tanks i advance
SAS log
225 libname TBC ODBC noprompt=XXXXXXXXXXXXXXXXXXXXXXXXXXXXX
226 DBINDEX=YES USE_ODBC_CL=yes
227 UPDATE_LOCK_TYPE=ROW REREAD_EXPOSURE=YES;
NOTE: Libref TBC was successfully assigned as follows:
Engine: ODBC
Physical Name:
228 Data Pers;
229 length name $40;
230 pnr = 1;
231 name='Tom';
232 output;
233 pnr = 5;
234 name='bla';
235 output;
236 run;
NOTE: The data set WORK.PERS has 2 observations and 2 variables.
NOTE: DATA statement used:
real time 0.03 seconds
cpu time 0.03 seconds
237 data TBC.person;
238 set pers;
239 flag=0;
240 do until(flag);
241 modify TBC.person (CNTLLEV=REC) key=PNR;
242 select (_iorc_);
243 when (%sysrc(_sok)) replace;
244 when (%sysrc(_dsenom))
245 do;
246 _error_=0;
247 flag=1;
248 end;
249 otherwise
250 do;
251 put 'Unexpected ERROR: _iorc_= ' _iorc_;
252 stop;
253 end;
254 end; /* ends SELECT group */
255 end; /* ends DO UNTIL loop */
256 run;
ERROR: Error updating table entry: [Microsoft][ODBC Cursor Library] Driver
not capable
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1 observations read from the data set WORK.PERS.
NOTE: The data set TBC.PERSON has been updated. There were 0 observations
rewritten, 0
observations added and 0 observations deleted.
NOTE: There were 1 rejected updates, 0 rejected adds, and 0 rejected
deletes.
ERROR: ROLLBACK issued due to errors for data set TBC.PERSON.DATA.
NOTE: DATA statement used:
real time 0.23 seconds
cpu time 0.04 seconds
| 
