Vern - putting the B and pressing enter displays the bottom of the result
set *IMMED.
Rob - thanks for those suggestions. I will consider them next time I
encounter such a situation.
It is a quite simple statement that I used in STRSQL and in the PC tools:
select STATUS,ECWUID,CHART,ECWACCT,LASTNAME,FIRSTNAME,
BIRTHDATE,RPPTSX from ecppatxrf
join rpmast on chart = rpptno
where rpstat in ('A', 'I') and rploc =
'0'
order by ecwacct
I don't think it's a memory issue (64 bit Win 7 with 16 gb ram), but I
suppose the pc tools could have their own constraints. Network isn't the
issue as we do a lot of image distribution/exchanges with hospitals and
have gigabit fiber running internally in our network.
The job eventually did finish after about 20 minutes.
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
