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: 7282

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: 7282

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: 1531
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
No new posts Checking Current date vickey_dw DFSORT/ICETOOL 1 Wed Feb 08, 2017 11:14 pm
This topic is locked: you cannot edit posts or make replies. Full Time COBOL Software Development ... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:24 am
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 3 Thu Jan 19, 2017 1:31 am
No new posts DD DUMMY & CPU TIME Nileshkul Testing & Performance analysis 16 Mon Dec 19, 2016 11:35 pm
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


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