LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (May 2003, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Sat, 3 May 2003 10:59:19 +0200
Reply-To:     Tom Schliemann <trs@ITERATION.DK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tom Schliemann <trs@ITERATION.DK>
Organization: TDC Internet
Subject:      Re: Updating DB2-2 tables via ODBC With DATA step

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

Back to: Top of message | Previous page | Main SAS-L page