Re: Do I really need two structs?

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

Sorry,

Thought I was one the RPG list.

Still, the idea is the same, the C equivalent to SETLL is _Rlocate().

Charles

On Mon, Oct 20, 2008 at 4:29 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
> You could simply use SETLL to check for the existence, it doesn't
> actually read a record so no structure needed.
>
> HOWEVER, I'd recommend simply trying to do the write and monitoring
> for a duplicate key error.
>
> Otherwise, it is possible that at the time you do the SETLL the record
> doesn't exist, yet when you go to write it, somebody else has already
> written it.  So your program could still receive a duplicate key
> error.
>
> In addition, the SETLL technique will not detect the fact that some
> other logical has a key specified as UNIQUE.
>
> Charles
>
>
>
> On Mon, Oct 20, 2008 at 4:20 PM, Olsson Erik <erik.eo.olsson@xxxxxxxxx> wrote:
> > Hello,
> >
> > A most trivial question.
> >
> > I'm using native I/O and have a struct corresponding to a database "record".
> > Before I write to my file I want to check to see if a row with my values
> > exist before I write to a db file - can I manage this without two structs
> > (one for the "record" and another one for the composite key?
> >
> > Thanks,
> > Erik
> > --
> > This is the C programming iSeries / AS400 (C400-L) mailing list
> > To post a message email: C400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/c400-l
> > or email: C400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/c400-l.