FTOV with VLTRIM option



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

FTOV with VLTRIM option

Postby mfrookie » Tue Mar 06, 2012 6:38 pm

Hi,

I am trying to convert a fixed length file to a variable length file, and while doing so I would like the trailing spaces to be removed.

Sample input data -
****** ***************************** Top of Data ******************************
000001 0000000000000001                                                       
       FFFFFFFFFFFFFFFF44444444444444444444444444444444444444444444444444444444
       000000000000000100000000000000000000000000000000000000000000000000000000
------------------------------------------------------------------------------
000002 0000000000000002AAAAA                                                   
       FFFFFFFFFFFFFFFFCCCCC444444444444444444444444444444444444444444444444444
       000000000000000211111000000000000000000000000000000000000000000000000000
------------------------------------------------------------------------------
000003 0000000000000003BB                                                     
       FFFFFFFFFFFFFFFFCC444444444444444444444444444444444444444444444444444444
       000000000000000322000000000000000000000000000000000000000000000000000000
------------------------------------------------------------------------------
000004 0000000000000004CCCCCCCCCCCC                                           
       FFFFFFFFFFFFFFFFCCCCCCCCCCCC44444444444444444444444444444444444444444444
       000000000000000433333333333300000000000000000000000000000000000000000000
------------------------------------------------------------------------------
000005 0000000000005                                                           
       FFFFFFFFFFFFF44444444444444444444444444444444444444444444444444444444444
       000000000000500000000000000000000000000000000000000000000000000000000000


Expected output result -
****** ***************************** Top of Data ******************************
000001 0000000000000001                                                       
       FFFFFFFFFFFFFFFF
       0000000000000001
------------------------------------------------------------------------------
000002 0000000000000002AAAAA                                                   
       FFFFFFFFFFFFFFFFCCCCC
       000000000000000211111
------------------------------------------------------------------------------
000003 0000000000000003BB
       FFFFFFFFFFFFFFFFCC
       000000000000000322
------------------------------------------------------------------------------
000004 0000000000000004CCCCCCCCCCCC                                           
       FFFFFFFFFFFFFFFFCCCCCCCCCCCC
       0000000000000004333333333333
------------------------------------------------------------------------------
000005 0000000000005                                                           
       FFFFFFFFFFFFF
       0000000000005


The SORT JCL I am using -
//STEP0001 EXEC PGM=SORT,COND=(0,NE)
//SORTIN   DD   DSN=&HLQ..TEST.FB,                                 
//             DISP=SHR                                                 
//OUTPUTFI DD   DSN=&HLQ..TEST.FBTOVB,                               
//             DISP=(NEW,CATLG,DELETE),                                 
//             SPACE=(CYL,(15,15),RLSE),                               
//             RECFM=VB,                                               
//             LRECL=27994,                                             
//             DSORG=PS                                                 
//SYSIN  DD *                                                           
  SORT FIELDS=COPY                                                     
  OUTFIL FNAMES=OUTPUTFI,FTOV,VLTRIM=X'40'                             
/*                                                                     
//SYSOUT   DD SYSOUT=*                                                 


But I keep getting the trailing spaces even though the file gets converted to variable length format. I thought VLTRIM would strip them off. When I replace the spaces in input file with '*' and use VLTRIM=C'*', the '*' are removed and are replaced with spaces. I am confused as to why trailing blanks keep coming in both cases. Shouldn't VLTRIM remove them and adjust the RDW accordingly. Or may be I am missing something.

Please help.

Thanks.
mfrookie
 
Posts: 40
Joined: Mon Apr 25, 2011 8:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: FTOV with VLTRIM option

Postby pjagathis » Tue Mar 06, 2012 8:50 pm

Hello,

Could you please what value should replace the Spaces?
Thanks and Regards,
Jagathis P
pjagathis
 
Posts: 67
Joined: Wed May 04, 2011 5:04 pm
Location: Chennai
Has thanked: 0 time
Been thanked: 0 time

Re: FTOV with VLTRIM option

Postby mfrookie » Tue Mar 06, 2012 9:01 pm

I want the trailing spaces to be removed completely, rather then replacing them by something else. The result should be a variable legnth file with no traling spaces.
mfrookie
 
Posts: 40
Joined: Mon Apr 25, 2011 8:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: FTOV with VLTRIM option

Postby BillyBoyo » Wed Mar 07, 2012 12:27 am

Can't see what is wrong with what you have.

Can you post the output from the step as well, please?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: FTOV with VLTRIM option

Postby mfrookie » Wed Mar 07, 2012 9:52 am

Problem solved on another Help board by the DFSORT guys.

It was the ISPF display that was making me feel that I have the trailing blanks.

When I just browse the file (as against to viewing it), this is what I see.

----+----1----+----2----+----3----+----4
----+----F----+----F----+----F----+----F
----+----1----+----2----+----3----+----4
 ---------------------------------------
0000000000000001                       
FFFFFFFFFFFFFFFF                       
0000000000000001                       
 ---------------------------------------
0000000000000002AAAAA                   
FFFFFFFFFFFFFFFFCCCCC                   
000000000000000211111                   
 ---------------------------------------
0000000000000003BB                     
FFFFFFFFFFFFFFFFCC                     
000000000000000322                     
 ---------------------------------------
0000000000000004CCCCCCCCCCCC           
FFFFFFFFFFFFFFFFCCCCCCCCCCCC           
0000000000000004333333333333           
 ---------------------------------------


I should checked the RDWs by displaying them, I instead spent lot of time going thru the manuals, forums etc ... :)

Thanks a lot for all your help.
mfrookie
 
Posts: 40
Joined: Mon Apr 25, 2011 8:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: FTOV with VLTRIM option

Postby BillyBoyo » Wed Mar 07, 2012 12:49 pm

OK, thanks for letting us know.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post