Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

add date & time

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
knobi

New User


Joined: 16 Aug 2005
Posts: 46

PostPosted: Fri Jun 20, 2014 9:22 am    Post subject: add date & time
Reply with quote

I have a file with one record (date & time), FB 15, and i would like to add this record to left side of all entries from another file.
Could someone suggest some DFSort way to do that, please ? Thanks
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7234

PostPosted: Fri Jun 20, 2014 11:24 am    Post subject: Reply to: add date & time
Reply with quote

Generate one or more DFSORT Symbols from the single-record file. Use the symbols thus generated everywhere you need them.
Back to top
View user's profile Send private message
knobi

New User


Joined: 16 Aug 2005
Posts: 46

PostPosted: Fri Jun 20, 2014 11:43 am    Post subject:
Reply with quote

i'm trying to use JOINKEYS and REFORMAT ...
but i'm getting rc=20
Back to top
View user's profile Send private message
knobi

New User


Joined: 16 Aug 2005
Posts: 46

PostPosted: Fri Jun 20, 2014 11:44 am    Post subject:
Reply with quote

not sure if JOINKEYS and REFORMAT works when the amount of records on both files are different ..
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7234

PostPosted: Fri Jun 20, 2014 12:46 pm    Post subject: Reply to: add date & time
Reply with quote

Show your sysout. In the Code tags. We can't just guess what you've got.

JOINKEYS is a big hammer in this case, and you only have a little nut to crack, but it will work.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Fri Jun 20, 2014 12:48 pm    Post subject:
Reply with quote

If are facing error you need to show us the SYSOUT

Can you show us the job and the sysout withing code tags?
Back to top
View user's profile Send private message
knobi

New User


Joined: 16 Aug 2005
Posts: 46

PostPosted: Fri Jun 20, 2014 1:27 pm    Post subject:
Reply with quote

i was doing wrong with the JOINKEYS.. that's why i was getting this error...
ICE405A 0 JOINKEYS STATEMENTS HAD MISMATCH IN NUMBER, LENGTH OR ORDER OF KEYS..... anyway i have changed the JCL some times since the error... and so far nothing ..

if anyone could point me to an example of ICETOOL using JOINKEYS where there is only one record in the first file (FB80), several records on the second one (FB80)..... and they successfuly put the content of the first file before each record of the second one.. i would appreciate...
Back to top
View user's profile Send private message
knobi

New User


Joined: 16 Aug 2005
Posts: 46

PostPosted: Fri Jun 20, 2014 1:58 pm    Post subject:
Reply with quote

just found.. it worked.. thanks
http://www-01.ibm.com/support/knowledgecenter/SSLTBW_1.12.0/com.ibm.zos.r12.icea100/ice1ca50124.htm%23wq962?lang=en
Back to top
View user's profile Send private message
wiprov

New User


Joined: 13 Feb 2008
Posts: 15
Location: Chennai

PostPosted: Mon Jun 23, 2014 7:12 pm    Post subject:
Reply with quote

Could you please share your code?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Get a job submitted itself every time... arunsoods JCL & VSAM 3 Tue Nov 22, 2016 4:05 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
This topic is locked: you cannot edit posts or make replies. Get correct date and time when curren... balaji81_k DB2 24 Fri Oct 14, 2016 10:40 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us