Am 28.03.2019 um 19:01 schrieb Paul Gilmartin:
On Thu, 28 Mar 2019 10:18:23 -0700, Sri h Kolusu wrote:
Kolusu, I would like one little tweak, if you please - is it possible to
get the timestamp fresh on each record, instead of using the same timestamp
value for all of them?
Bill,
Unfortunately DFSORT cannot get a fresh timestamp on each record. As far as
I know even DB2 does not give you fresh timestamp on each record.
I'm astonished; I'd expect data bases to log times of transactions. Or
is that left the responsibility of the UI/API?
-- gil
If you issue a long running SQL SELECT with DB2 (for example),
then a CURRENT TIMESTAMP expression in the SELECT result will show the
same value for all the (millions of) result records, even if the SQL is
running
for hours; the whole SQL SELECT is one single transaction and the value
shown is the starting time of the transaction (the time when the SQL
SELECT started).
If you are not happy with this, you need to code some application logic
and get
a new timestamp on every SQL FETCH (which is possible, of course).
Kind regards
Bernd
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
