RE: Embedded SQL with cursor with delete

What's your select statement look like?

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx 
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: Tuesday, November 21, 2006 11:58 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: Embedded SQL with cursor with delete

I'm using embedded SQL to process selected records from a file.

Optionally I want to delete some of the records and I'm 
trying to do it like
this:

Exec SQL  Delete From PCWSDET Where Current of MyCursor;

It bombs with SQL state 42828 which says "This SQLSTATE 
reports an attempt
to DELETE WHERE CURRENT OF CURSOR or UPDATE WHERE CURRENT OF 
CURSOR on a
cursor that is fetching rows using a blocking protocol."

The documentation I read says _not_ to specify "For Update 
Of" when deleting
only.

How do I tell it not to use a blocking cursor?

Thanks.

-- 
Jeff Crosby
Dilgard Frozen Foods, Inc.
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531

The opinions expressed are my own and not necessarily the 
opinion of my
company.  Unless I say so.


-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) 
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.