On Tue, 30 Apr 2019 08:16:20 +0800, Peter Van Dyke wrote: >If you have a copybook that maps the records you want to generate then IBM >File Manager can be used to generate random date values. You could use the >copybook with the File Manager "Data Create Utility": > >https://www.ibm.com/support/knowledgecenter/en/SSXJAV_14.1.0/com.ibm.filemanager.doc_14.1/base/dsgtemp.html > The linked page: https://www.ibm.com/support/knowledgecenter/SSXJAV_14.1.0/com.ibm.filemanager.doc_14.1/base/datetimeattpan.html#datetimeattpan
... does not specify whether the dates are selected with replacement or without replacement. Nor did the OP indicate a preference. Skip weekends, holidays, and off-shift hours? > > The edit copybook/template function can be used to identify fields >containing date values and scrambling processing for those date fields can >also be defined: > >https://www.ibm.com/support/knowledgecenter/en/SSXJAV_14.1.0/com.ibm.filemanager.doc_14.1/base/datetime.html > > >These features are also available for the File Manager "Copy Utility". > >Regards, >Peter Van Dyke >HCL Technologies > >On Mon, 29 Apr 2019 at 05:09, Thomas Kern < >[email protected]> wrote: > >> I was thinking that generating the random dates in Julian format >> (15001-15365,16001-16366) and then convert the whatever date format your >> record needed (yyyy-mm-dd). >> >> On 04/26/2019 13:48, Sri h Kolusu wrote: >> >> Also if you have any other ideas for generating random dates (YYYYMMDD) >> > overall, I would welcome your thoughts! >> > >> > DFSORT has plethora of date arithmetic/conversion functions that can get >> > you the desired results. ... >> > >> > You can pass 3 parms. The Begin-year , End year and Number of records. >> > >> > The Begin-Year and End Year parameters are self explanatory. The number >> > of records can either be a multiple of 365 or 366. ... -- gil ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
