Re: Foot-Warner?

[DaveL Smith <davesmit@US.IBM.COM>]

Norman,

I have been less than impressed with SQR ability to monitor and recover from
errors.   I don't know of any way that you can monitor a user terminating SQR.
I have been having problems with ODBC connections failing during my program, and
having to code and flag records accordingly so I can recover on the next run,
its a real pain.

The only suggestion I would have here is to write an entry at the end of your
file if it completes successfully, then check for that, assume the user aborted
if the file does not contain the last line.  You could then inform the user to
clean up their own mess, or offer to delete the offending fragments the next
time the SQR was run.


David L. Smith
IBM Global Services




Norman Dolph <NEDOLPH@AOL.COM> on 10/06/99 07:45:22 AM

Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:
Subject:  Foot-Warner?




Warmest Thanks for previous help!   -  Here is the Problem...

The application is selecting and writing records into a flat ASCII file,
"c:\foobar.txt".  It could run a long time. (Platform is PeopleSoft windows
NT)

The User is looking at the minimized SQRW button in the Tray. User gets bored
and decides to bail out by right clicking this icon and selecting "Close."

Thus the file on c:  is PARTIALLY written and sitting there.
------
The question: Can the user's electing to ABORT  fire an event WITHIN the SQR
code to WRITE a footer message to this file before closing it?
Such as:
"WARNING!  This file was terminated by operator, and may be corrupt or
incomplete!"

Alternatively, is there a way - within the SQR code - to close and blow away
the file fragment if the user bails out.  That way the user only gets all or
none.

All best,

Norman Dolph