Page 1 of 1

Generate date using IKJEFT1B with DML

PostPosted: Mon Dec 21, 2015 10:30 pm
by puffes
Hi,
I wonder if it's possible to generate all dates for one year using utility IKJEFT1B with DML?
So for year 2016 I want the utility to generate 366 rows on a sequential file starting with 2016-01-01, 2016-01-02 and so on

Regards,

Mikael

Re: Generate date

PostPosted: Tue Dec 22, 2015 3:27 am
by NicC
I do not know how you intend to do this. IKJEFT1B is one of three versions of "batch TSO" the others being IKJEFT01 and IKJEFT1A. You still need to execute a program under TSO. Which one were you thinking of? Have you tried your SQL in SPUFI yet to see if you can actually do it?