On Thu, 28 Mar 2019 20:36:59 +, David W Noon wrote:
>
>The purpose of TIMESTAMP is just its face value: to provide a temporal
>log of when a database event occurred. It is a measure of external
>times, rather than of the internal clock of the CPU.
>
I believe that in some cases the order in whi
On Thu, 28 Mar 2019 14:14:46 -0500, Paul Gilmartin
<000433f07816-dmarc-requ...@listserv.ua.edu> wrote abour Re: Using
DFSORT to generate data:
> On Thu, 28 Mar 2019 11:38:24 -0700, Sri h Kolusu wrote:
>
>>> I'm astonished; I'd expect data bases to log times o
Note: With Multi-Row Fetch rows wouldn’t have unique timestamps if the
timestamps WERE generated at fetch time.
Cheers, Martin
Sent from my iPad
> On 28 Mar 2019, at 19:15, Paul Gilmartin
<000433f07816-dmarc-requ...@listserv.ua.edu> wrote:
>
> On Thu, 28 Mar 2019 11:38:24 -0700, Sri h Kolus
I assumed the time stamp was in a format like STCKE which is really just an
integer - so it doesn’t have the rollover issue.
Cheers, Martin
Sent from my iPad
On 28 Mar 2019, at 17:18, Sri h Kolusu wrote:
>> Kolusu, I would like one little tweak, if you please - is it possible to
>> get the ti
On Thu, 28 Mar 2019 11:38:24 -0700, Sri h Kolusu wrote:
>>I'm astonished; I'd expect data bases to log times of transactions. Or is
>>that left the responsibility of the UI/API?
>
>When I say DB2 gives a static timestamp is when you are trying to get
>EXISTING records from a DB2 table and append
>I'm astonished; I'd expect data bases to log times of transactions. Or is
that left the responsibility of the UI/API?
Gil,
When I say DB2 gives a static timestamp is when you are trying to get
EXISTING records from a DB2 table and append a time stamp. Something like
this
SELECT NAME
,CU
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,
Unfortunatel
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
> 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 f
Some people are never satisfied. Write a little E15 exit.
sas
On Thu, Mar 28, 2019 at 11:44 AM Martin Packer
wrote:
> You raise a good point but we don't know what kind of "real" timestamp
> they want. We could increment by, say, 1 second or 1 millisecond. Random
> increments is not something
inframe-performance-topics/id1127943573?mt=2
Youtube channel: https://www.youtube.com/channel/UCu_65HaYgksbF6Q8SQ4oOvA
From: Paul Gilmartin <000433f07816-dmarc-requ...@listserv.ua.edu>
To: IBM-MAIN@LISTSERV.UA.EDU
Date: 28/03/2019 14:23
Subject: Re: Using DFSORT to generate
On Thu, 28 Mar 2019 13:21:40 +, Martin Packer wrote:
>ON INREC, if you used IFTHEN WHEN=INIT you could prime with a timestamp
>and then with a subsequent IFTHEN overwrite the last few bytes of the
>timestamp with an incrementing value.
>
But what if the OP requires an actual timestamp rather
/03/2019 12:32
Subject: Re: Using DFSORT to generate data
Sent by:IBM Mainframe Discussion List
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?
Billy
On Wed
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?
Billy
On Wed, Mar 27, 2019 at 6:29 PM Sri h Kolusu wrote:
> Hi everyone! I am trying to generate a large test file for an i
I could not find a way for IEBDG to create the first record with 10001
in the first 9 bytes, then the next rec with 10009, then 10017,
etc. In addition, I could not see any use of the time generation. I have
used IEBDG only a few times in my life for simple things, so I am far from
an e
Sri h Kolusu wrote:
>It is quite easy to generate your test data. I generated 1 million records
>with an LRECL of 100 bytes
It is indeed easy for you. But for the rest of us, you're awesome with what you
can conjure up with DFSORT and ICETOOL.
> OUTFIL REPEAT=100,
> BUILD=(SEQNUM,9,ZD
On Wed, 27 Mar 2019 19:39:40 -0400, Steve Smith wrote:
>Kolusu, you should write a Redbook. Or maybe better, a SHARE session: 101
>things you didn't know that DFSORT could do.
>
Wouldn't it be easier to enumerate just the things that DFSORT *can't* do?
>On Wed, Mar 27, 2019 at 6:31 PM Sri h Kolu
Truly. CharlesSent from a mobile; please excuse the brevity.
Original message From: Steve Smith Date:
3/27/19 4:39 PM (GMT-08:00) To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Using
DFSORT to generate data Kolusu, you should write a Redbook. Or maybe better, a
SHARE session
Kolusu, you should write a Redbook. Or maybe better, a SHARE session: 101
things you didn't know that DFSORT could do.
On Wed, Mar 27, 2019 at 6:31 PM Sri h Kolusu wrote:
> > Is there any reason not to use IEBDG for this?
>
> Mark,
>
> Does IEBDG have the ability to generate Time stamp with mi
t; To: IBM-MAIN@LISTSERV.UA.EDU
> Date: 03/27/2019 02:01 PM
> Subject: Re: Using DFSORT to generate data
> Sent by: IBM Mainframe Discussion List
>
>
> Mark Jacobs
>
--
For IBM-MAIN subscribe / signoff / archiv
Hi everyone! I am trying to generate a large test file for an internal
> project, and I wanted to know if anyone has done this with SORT.
Bill,
It is quite easy to generate your test data. I generated 1 million
records with an LRECL of 100 bytes
TCB: 00:00:00.922436
ELAPSED: 00:00:09.
Is there any reason not to use IEBDG for this?
Mark Jacobs
Sent from ProtonMail mobile
Original Message
On Mar 27, 2019, 4:44 PM, Bill Ashton wrote:
> Hi everyone! I am trying to generate a large test file for an internal
> project, and I wanted to know if anyone has done this
22 matches
Mail list logo
