Generate date using IKJEFT1B with DML



IBM's flagship relational database management system

Generate date using IKJEFT1B with DML

Postby puffes » Mon Dec 21, 2015 10:30 pm

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
puffes
 
Posts: 5
Joined: Wed Mar 12, 2014 12:46 am
Has thanked: 0 time
Been thanked: 0 time

Re: Generate date

Postby NicC » Tue Dec 22, 2015 3:27 am

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?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post