Re: Embedded SQL & commitment control

[Phil Groschwitz <sublime78ska@xxxxxxxxx>]

What I'm doing in the rpg pgm is opening the file for
update, and when I read a record that record is locked
until I read another, update it, or unlock it.

I want to do the same thing in sql.  I'm using the
select statement to get the last key value, then
adding one to it, then doing an insert.

Problem is that the record doesn't get locked when I
do the select.  Somewhere in the documentation I read
that inorder for the lock to span more than just the
select statement, I had to use a cursor so that's why
I'm using the cursor rather than just a select and an
insert - so that I can define a transaction.

I don't want to lock the entire table - just the row
so I won't get any duplicate keys.

Am I going about this the wrong way?  I know I must be
missing something or people would have more to
complain about sql than the pre-compiler!:)

Thanks,
Phil
 
--- "R. Bruce Hoffman, Jr." <rbruceh@attglobal.net>
wrote:
> -----Original Message-----
> From: Phil Groschwitz <sublime78ska@yahoo.com>
> To: RPG400-L@midrange.com <RPG400-L@midrange.com>
> Date: Wednesday, March 14, 2001 12:37 AM
> Subject: Embedded SQL & commitment control
> 
> 
> >
> >The file gets locked *SHRRD, which means the select
> >statement can still occur after another job's
> select
> >and before that job's insert.
> >
> >Could someone please show where I've gone astray?
> 
> I am not sure what you are asking. You may have to
> elaborate.
> 
> But reads on SQL are not held locked unless it is
> for update.
> 
> Reads without update are not normally held by RPG.
> 
> If you are trying to lock the file exclusive... the
> commit level is
> REPEATABLE READ.
>
===========================================================
> R. Bruce Hoffman, Jr.
>  -- IBM Certified Specialist - AS/400 Administrator
>  -- IBM Certified Specialist - RPG IV Developer
> 
> "America is the land that fought for freedom and
> then
>   began passing laws to get rid of it."
> 
>      - Alfred E. Neuman
> 
> 
> 
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to
> RPG400-L@midrange.com.
> | To subscribe to this list send email to
> RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list
> owner/operator: david@midrange.com
> +---


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---