Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SORT - TRAILER3 question

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

New User


Joined: 24 Jun 2007
Posts: 57
Location: US

PostPosted: Thu Oct 09, 2014 8:36 am    Post subject: SORT - TRAILER3 question
Reply with quote

Hi,

Can someone please help me with this TRAILER3 query.
Here is my Stmt:
Code:
TRAILER3=(5:28,4,10:25,3,15:17,2,25:19,01,45:COUNT)


in Above stmt,
Code:
 5:28,4
is a packed decimal field. (Date:2014273). IT i snow printing in Packed format. But I need it to convert it to display format.

Please advise.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2104
Location: NY,USA

PostPosted: Thu Oct 09, 2014 11:27 am    Post subject:
Reply with quote

You probably be looking for EDIT and SIGNS to be used to do the same also see if you can use TO=ZD operator.
Back to top
View user's profile Send private message
saravanakmr.tpr

New User


Joined: 16 Feb 2012
Posts: 7
Location: India

PostPosted: Fri Aug 21, 2015 5:32 pm    Post subject:
Reply with quote

I am also having the same kind of requirement..
My input is in binary & i need to convert it to ZD. But, as I checked in some manuals, we cannot edit fields in TRAILER3 unless we specify it in aggregate functions like TOT, AVG etc..

Could anyone please confirm on the same ?

Is there any way to change it in trailer3 itself rather changing it using INREC fields ?
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Fri Aug 21, 2015 5:43 pm    Post subject: Reply to: SORT - TRAILER3 question
Reply with quote

Your interpretation of the manual was correct. You can only access "unedited input" to the OUTFIL on TRAILER3 as far as direct source-data is concerned. So you'll have to use INREC or OUTREC.
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 Build SQL query using SORT balaji81_k DFSORT/ICETOOL 0 Mon Feb 18, 2019 9:56 am
No new posts Build Dynamic Sort output and limit '... balaji81_k DFSORT/ICETOOL 2 Sat Feb 02, 2019 4:40 am
This topic is locked: you cannot edit posts or make replies. PARAMETER 'F1' IS UNIDENTIFIED error ... Poha Eater DFSORT/ICETOOL 14 Fri Feb 01, 2019 2:39 pm
No new posts SORT INNER JOIN [F1] OUT OF SEQ ERROR balaji81_k DFSORT/ICETOOL 8 Wed Jan 30, 2019 3:21 am
No new posts Dates compare on specific dates using... balaji81_k DFSORT/ICETOOL 2 Thu Jan 24, 2019 12:03 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us