Insert date into a file



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Insert date into a file

Postby gauravfrankly » Thu Feb 11, 2016 4:12 pm

Hi all,

I want to create a FB PS file having date in each row in below pattern using SORT/DFSORT
19000101
19000102
19000103
19000104 .... and so on.
gauravfrankly
 
Posts: 39
Joined: Fri Aug 07, 2015 3:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Insert date into a file

Postby enrico-sorichetti » Thu Feb 11, 2016 5:02 pm

cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Insert date into a file

Postby gauravfrankly » Thu Feb 11, 2016 5:22 pm

Hi enrico, topic you provided is having Julian date conversion. I need to create a new file with Greg Date incremented by 1 day in every next row.
gauravfrankly
 
Posts: 39
Joined: Fri Aug 07, 2015 3:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Insert date into a file

Postby enrico-sorichetti » Thu Feb 11, 2016 5:35 pm

I said FOR HINTS, not that it would be a FULL working solution
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Insert date into a file

Postby gauravfrankly » Thu Feb 11, 2016 6:57 pm

can you please provide the logic or syntax of SORT card to get this done
gauravfrankly
 
Posts: 39
Joined: Fri Aug 07, 2015 3:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Insert date into a file

Postby enrico-sorichetti » Thu Feb 11, 2016 7:59 pm

the snippet in the topic linked makes easy to construct a dataset with a JULIAN date

this link will tell how to add a couple of statements to convert a julian date to the equivalent gregorian
ftp://ftp.software.ibm.com/storage/dfso ... rtugpg.pdf
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Insert date into a file

Postby NicC » Thu Feb 11, 2016 8:36 pm

This is NOT a JCL topic but you wanted a DFSort solution so WHY did you post in the JCL section?
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

Re: Insert date into a file

Postby gauravfrankly » Fri Feb 12, 2016 11:00 am

NicC apologies for this. Will keep it in mind to post in correct forum.
gauravfrankly
 
Posts: 39
Joined: Fri Aug 07, 2015 3:30 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post