You need to include your "where" clause. In your case I expect to see
where bshBEGtm<'1150929200000'

If you need to be more generic you could try
with t1 as (
select cast(max (left(bshbegtm,7)) as char(7)) as CYYMMDD
from qtemp.prtrptbrm)
SELECT BSHLIB, BSHSIZ, BSSAVTIME, cast( left(BSVOLS,7) as char(7))
as volume, BSHSAV, BSHERR, BSHBEGTM, BSHENDTM, BSHGRP
FROM qtemp.prtrptbrm, t1
where bshbegtm<t1.cyymmdd concat '200000'
ORDER BY bssavtime desc

Pretty cool output though. We are nuts with journals. It takes us 3
hours to save our journals during our quarterly downtime.
Library Size in Total VOLUME Number
Number Start End Control
Name Millions bytes Save Time Objects
Objects time stamp time stamp Group
Minutes Saved Not
Saved CYYMMDDHHMMSS CYYMMDDHHMMSS
#MXJRN 2,623,141 179 BR0327 557 0
1150918211300 1150919001234 DTFULL
ERPLXF 441,018 34 BR0327 5,740 0
1150919002555 1150919010004 DTFULL
QPFRDATA 189,032 18 BR0327 58 0
1150919021045 1150919022856 DTFULL
ERPLXSAVF 125,699 14 BR0327 218 0
1150919010856 1150919012306 DTFULL
QGPL 244,244 13 BR0327 2,086 0
1150918205922 1150918211246 DTFULL
YEAREND 57,961 8 BR0327 14 0
1150919024240 1150919025103 DTFULL
GDIDIVF 77,736 7 BR0327 11,093 0
1150919014305 1150919015006 DTFULL
ERPLXUSRF 58,440 5 BR0327 1,016 0
1150919012306 1150919012901 DTFULL

Guested SSD's to fiber LTO4

Rob Berendt

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].