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
 
DFSORT Insert Hex String at the end of a VB Dataset

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

New User


Joined: 09 Aug 2006
Posts: 2

PostPosted: Wed Aug 09, 2006 2:55 pm    Post subject: DFSORT Insert Hex String at the end of a VB Dataset
Reply with quote

Hi,

I want to reformat a dataset with DFSORT. I have a VB Dataset and I want to insert a Hex String at the end of the dataset. Does anybody have an idea?

Thanks in advance!
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Aug 09, 2006 9:23 pm    Post subject:
Reply with quote

Please show an example of the records in your input file (including the length of each record) and what you expect for output. Also, give the RECFM and LRECL of your input file.
Back to top
View user's profile Send private message
c_litze

New User


Joined: 09 Aug 2006
Posts: 2

PostPosted: Thu Aug 10, 2006 1:12 pm    Post subject: Re: DFSORT Insert Hex String at the end of a VB Dataset
Reply with quote

RECFM is VB, Record length is 1000.
The problem is that I don't know the length of each record because it is VB.

Example:
20060808EXAMPLEONE AAABBBCCC
FFFFFFFFCECDDDCDDC4CCCCCCCCC
2006080857147356550111222333
-------------------------------
20060809EXAMPLETWO DDEEFF
FFFFFFFFCECDDDCEED4CCCCCC
2006080957147353660445566

I expect
20060808EXAMPLEONE AAABBBCCC
FFFFFFFFCECDDDCDDC4CCCCCCCCC00
2006080857147356550111222333DA
-------------------------------
20060809EXAMPLETWO DDEEFF
FFFFFFFFCECDDDCEED4CCCCCC00
2006080957147353660445566DA

Thanks.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Aug 10, 2006 9:12 pm    Post subject:
Reply with quote

Here's a DFSORT job that will do what you asked for. You'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) in order to use DFSORT's JFY function. If you don't have the April, 2006 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTF, see:

www.ibm.com/servers/storage/support/software/sort/mvs/peug/

Code:

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file (VB/1000)
//SORTOUT DD DSN=...  output file (VB/1002)
//SYSIN    DD    *
  OPTION COPY
* Add X'0D0A' and blanks after last non-blank byte of VB record.
  INREC OVERLAY=(5:5,996,JFY=(SHIFT=LEFT,TRAIL=X'0D0A',LENGTH=998))
* Remove blanks after X'0D0A'.
  OUTFIL VLTRIM=C' '
/*
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 line 52: Name or string > 250 char... Ashishpanpaliya CLIST & REXX 5 Sat Oct 14, 2017 2:29 am
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts How to insert a value on specific pos... Poha Eater DFSORT/ICETOOL 9 Sun Oct 01, 2017 3:04 am
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm

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