Re: Object Allocation Problem - or Something Else?

<<SNIP>>

The company that provides our Point-of-Sales applications and I
teamed up so that the stores could send an order directly to the
System i. I don't know much about the POS side, but the programmer
there said he used OLE DB to connect, which we both thought was great
because I could create an SQL DDL file on the System i into which the
orders would be dumped.

<<SNIP>>

The problem that we have been experiencing is that, occasionally, I
will get only part of the order, say 10 lines out of 100 (it varies).
I have a check at my end (the store's purchase order number) to be
sure that the store managers (not the sharpest knives in the drawer)
don't try to send the same order a second (or more) time. But on the
next cycle the rest of the order is there and, naturally, my program
rejects it as being a duplicate.

What I don't know, and have been unable to test, is whether or not
the ALCOBJ actually works if the store has already made the
connection to my bucket file when I allocate the file and start
processing. This seems to be what is happening, but is it possible? I
do know that the orders are not being submitted twice.