On Thursday, October 16, 1997 2:21 PM, ROGER SMITH
[SMTP:[log in to unmask]] wrote:
> We have purchased Netbase (demo period) from Quest Software. Netbase
> creates a MSG file for changes to one of our datasets. We have another
> program that is supposed to read the MSG file and pass the information
> to an Oracle database on the HP9000. I understand that both programs
> should read and write to the MSG file (until physically terminated).
> Netbase does this OK, but the script reading the MSG file reads through
> the file one time and then pauses. This is OK. However, the next time
> that Netbase writes to the MSG file, the script terminates without doing
> another read.
>
> Any help is appreciated. Our demo period is about to expired and I do
> not have this working correctly. A listf ,5 of the file is enclosed.
>
> FILE: AUXMSG.DATA.NETBASE
>
> FILE CODE : 0 FOPTIONS: ASCII,VARIABLE,NOCCTL,MSG
> BLK FACTOR: 1 CREATOR : **
> REC SIZE: 8192(BYTES) LOCKWORD: **
> BLK SIZE: 8202(BYTES) SECURITY--READ : ANY
> EXT SIZE: 41283(SECT) WRITE : ANY
> NUM REC: 88 APPEND : ANY
> NUM SEC: 512 LOCK : ANY
> NUM EXT: 2 EXECUTE : ANY
> MAX REC: 10007 **SECURITY IS ON
> FLAGS : 2 ACCESSORS,EXCL,1 R,1 W
> NUM LABELS: 0 CREATED : THU, OCT 16, 1997, 2:49 PM
> MAX LABELS: 0 MODIFIED: THU, OCT 16, 1997, 2:49 PM
> DISC DEV #: 52 ACCESSED: THU, OCT 16, 1997, 2:49 PM
> SEC OFFSET: 0 LABEL ADDR: **
> VOLCLASS : MPEXL_SYSTEM_VOLUME_SET:DISC
>
>
> tia,
> roger
Roger,
I'm sure Jeff Vance (or any number of listers) could answer this better
than I. But as I have gone throught this, I thought I would share the
solution I came up with.
We wrote such a job, one that would read a message file and take action on
the records that were written to it. Same problem occurred, the command
script would work the first time, then terminate. The solution was to
create a third process that kept the message file open for writing (and did
nothing else). This allowed the first write process to open and close the
message file as needed.
Hope this helps.
|
