Search found 16 matches

by magesh_j
Sat Nov 19, 2016 1:27 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Syncsort - scanning a record for a string of 16 digits
Replies: 6
Views: 5218

Try this //SYSIN DD * OPTION COPY INREC FINDREP=(IN=C’1212121212121212’,OUT=C’9898989898989898’) As per dfsort application programing guide FINDREP is a new option that allows you to do various types of find and replace operations on your records. FINDREP makes it easy to replace character o...
by magesh_j
Thu Nov 17, 2016 10:18 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Syncsort - scanning a record for a string of 16 digits
Replies: 6
Views: 5218

show us with an example to suggest
by magesh_j
Thu Nov 17, 2016 10:16 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: How to Copy Vraiable length file?
Replies: 1
Views: 2278

I want to reduce the record length from 680 to 670.
The "File Length" will not change (=3000 + 4 bytes for Length
There is no concept called file length, only record length.
by magesh_j
Thu Nov 17, 2016 10:03 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: ICETOOL SPLIT RECORDS
Replies: 1
Views: 1638

You can use OUTFIL FTOV to convert fixed to variable.

Code: Select all

outfil include=(your cond to split),VTOF,FNAMES=OUT2
outfil include=(your cond to split),VTOF,FNAMES=OUT1
by magesh_j
Thu Nov 17, 2016 9:57 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Go to Next Record via Sort
Replies: 3
Views: 2474

You can either use RESIZE ICETOOL or IFTHEN=(WHEN=GROUP,BEGIN=, END= in SORT
by magesh_j
Thu Nov 17, 2016 9:53 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT for 2 files
Replies: 4
Views: 3473

Start using code tag like below 1 SDBSKAFJO 456 12 12302009 NEJFIREJT 1000 2 NARJWEOP 678 24 12312010 DFNGIJREO 2000 4 MNJDJHDJ 956 08 12082012 ASEFGRG 950 1 SDBSKAFJO 456 12 12302009 NEJFIREJT 200 2 NARJWEOP 678 24 12312010 DFNGIJREO 300 3 ABCDEFGH 362 15 12302010 ASDAFGGF 80 what should be the out...
by magesh_j
Fri Oct 21, 2016 12:13 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Split the input file using delimiter and output only few col
Replies: 5
Views: 3744

what is the possibility of showing expected output ?
by magesh_j
Fri Oct 21, 2016 12:12 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Split the input file using delimiter and output only few col
Replies: 5
Views: 3744

Yes, Possible using INREC PARSE.

Should your output be without a delimiter or with the delimiter?

If without the delimiter, you want the output of each column to be fixed or variable?
by magesh_j
Wed Sep 14, 2016 4:37 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Outrec - move 12 byte data to occupy 13 bytes
Replies: 1
Views: 1430

svnsk1056,

From which position 9(10)V99 starts in your input to be copied into output ?

9999991000014000001272098060276000000000000000186718771 ?

Thanks
Magesh
by magesh_j
Wed Sep 14, 2016 4:27 am
Forum: DFSORT , ICETOOL & Utilities
Topic: How to remove trailing spaces in a mainframe file
Replies: 1
Views: 2163

nishant , Use FINDREP INREC FINDREP=(INOUT=(C' ,',C',')) if you have more than one space before comma then you can having multiple replace like below INREC FINDREP=(INOUT=(C' ,',C',', C' ,',C',', C' ,',C',', C' ,',C',', C' ,',C',', C' ,',C',', C' ,',C',', C' ,',C',', C' ,',C...
by magesh_j
Tue Sep 06, 2016 9:22 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: formatting a numeric field in input file
Replies: 7
Views: 4606

BANUREKHAB,

Start using code tags. which will help people to read it better.

Code: Select all

[ code ] ur code [ / code ]

Regards,
Magesh
by magesh_j
Tue Sep 06, 2016 9:22 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: formatting a numeric field in input file
Replies: 7
Views: 4606

BANUREKHAB,

Start using code tags. which will help people to read it better.

Code: Select all

[ code ] ur code [ / code ]

Regards,
Magesh
by magesh_j
Mon Sep 05, 2016 7:38 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: formatting a numeric field in input file
Replies: 7
Views: 4606

Also we can move the values and decimal and symbol seperately in 81:%00,%01,c'+1'

IFThen=(when=(1,16,ss,eq,c'-'),overlay=(99:c'-'))

Then read 81,19,sff,zd,length=18 will make more easy.

We haven't got anything from op. Left as is.

Thanks
Magesh
by magesh_j
Sat Sep 03, 2016 5:39 am
Forum: DFSORT , ICETOOL & Utilities
Topic: formatting a numeric field in input file
Replies: 7
Views: 4606

BANUREKHAB,
Also let us know if you need

Code: Select all

418.1 to be 418.10

or

418.1 to be 418.01

I assumed to be

Code: Select all

418.1 to be 418.10
Regards,
Magesh
by magesh_j
Fri Sep 02, 2016 7:36 am
Forum: DFSORT , ICETOOL & Utilities
Topic: formatting a numeric field in input file
Replies: 7
Views: 4606

Assuming LRECL=80, use the below code OPTION COPY INREC IFTHEN=(WHEN=(1,1,CH,EQ,C'-'), PARSE=(%00=(ENDBEFR=C'.',ENDBEFR=C' ',FIXLEN=16,PAIR=QUOTE), %01=(FIXLEN=2)), BUILD=(%00,UFF,ZD,LENGTH=16, %01,81:C'-')), IFTHEN=(WHEN=NONE, PARSE=(%02=(...