Well, we could give bit and pieces, but when I don't see the full picture, the suggestion may not be appropriate.
First of all, loading 5'' records (in one instance) doesn't sound like real time to me, rather batch oriented. Perhaps near real time - whet is the applications?
If you want to do real real time with SAS, I thin the Event Stream Processing the the appropriate product to use. It desn't use Base SAS (at least not in the stream part).
Also, please define "in the middle of the process". What is the process? A whole ETL job, or a single SQL statement? And what is the requirement?
... View more