Search found 29 matches

by Vikas.betu
Sat May 24, 2014 1:56 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Elimination of Special Char. Using SORT.
Replies: 7
Views: 8478

Thanks Dick but do u have list bit pattern (from x'00' thru x'FF') for all special characters. If yes then please provide me the same. As I tried as much as I could but still there are some characters which are missing and I can't recognise the bit pattern (from x'00' thru x'FF') for them.
:( :(
by Vikas.betu
Fri May 23, 2014 7:18 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Elimination of Special Char. Using SORT.
Replies: 7
Views: 8478

Hi William

Thanks
I am currently using ALTSEQ for replacing special characters. However I am not able to replace all the special char thats why I am want to try this.

so help me to use this for my requirement
by Vikas.betu
Fri May 23, 2014 3:40 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Elimination of Special Char. Using SORT.
Replies: 7
Views: 8478

Elimination of Special Char. Using SORT.

Hi I found below mention code to eliminate special char by using sort. But I am failed to change it as per my requirement. In this code we are passing data and creating 2 different files. Requirement: I have a file of 350 record length and I need to replace all the special char with spaces or blanks...
by Vikas.betu
Fri Apr 18, 2014 1:14 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Need to remove special character
Replies: 8
Views: 12096

Dik
I am sayiing that I am not able to replace these characters through ALTSEQ. My question is how to replace. Is there any other way to replace these
by Vikas.betu
Fri Apr 18, 2014 12:04 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Need to remove special character
Replies: 8
Views: 12096

having some special charater like (" , Ì ) in my file. I need to replace these characters with Zero's or spaces.
by Vikas.betu
Thu Apr 17, 2014 9:57 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need to remove special character
Replies: 8
Views: 12096

Yes but I don't have the exact position. I was using below code to remove special character OPTION COPY ALTSEQ CODE=(0040,0140,0240,0340, 0440,0540,0640,0740, 0A40,0B40,0C40,0D40, 0E40,0F40,1040,1140, 1240,1340,1440,1540, 1640,1740,1840,1940, 1A40,1B40,1C40,1D40, 1E40,1F40,2040,2140, 2240,2450,2540,...
by Vikas.betu
Thu Apr 17, 2014 8:11 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Need to remove special character
Replies: 8
Views: 12096

Need to remove special character

Hi

I have file which is having some special charater like (" , Ì ). I need to remove these character. Please help me out in this
by Vikas.betu
Mon Apr 07, 2014 8:46 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort or DFSORT - find all those fields and replace with 0
Replies: 6
Views: 6834

PS is packed decimal field. there are some alpha numeric values in that column. I want to use it through DFSORT. Just need your help in this
by Vikas.betu
Mon Apr 07, 2014 6:25 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort or DFSORT - find all those fields and replace with 0
Replies: 6
Views: 6834

I have a VSAM file in which a field is defined as a character field and then it got redefined in PS field. When I am trying to extract that field in flat file, it is throwing SOC7 error as there are some value which are not numeric So I just want to remove those values. Those values can be different,
by Vikas.betu
Fri Apr 04, 2014 9:07 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort or DFSORT - find all those fields and replace with 0
Replies: 6
Views: 6834

Sort or DFSORT - find all those fields and replace with 0

Hello Guys I have a vsam file in which I have some invalid fields for some of the records, however I am not sure about the values of those fields(defined in PS format). I am extracting that file into flat file. but while doing extraction I want to find all those fields and replace with 0 or spaces. ...
by Vikas.betu
Thu Mar 13, 2014 8:07 pm
Forum: JCL
Topic: Mainframe as sFTP server - handle EBCDIC files
Replies: 8
Views: 11708

I am sorry Nic, my intention was clear. I thought it's on going topic and everyone can easily search the same. Anyways I'll post a new topic for the same.
by Vikas.betu
Wed Mar 12, 2014 11:34 pm
Forum: JCL
Topic: Mainframe as sFTP server - handle EBCDIC files
Replies: 8
Views: 11708

I am doing FTP from mainframe to window server with the help of JCL ftp job. But now I need to get the same file from window server to mainframe server, Can anyone help in this or provide me some sample code for that ?
by Vikas.betu
Wed Feb 26, 2014 2:33 am
Forum: DFSORT , ICETOOL & Utilities
Topic: bit to 8 different char
Replies: 38
Views: 37208

Thanks all. I got the correct result. William thakns for your great help.. :D
by Vikas.betu
Tue Feb 25, 2014 2:00 am
Forum: DFSORT , ICETOOL & Utilities
Topic: bit to 8 different char
Replies: 38
Views: 37208

William, I just need to extract only first column of this input file vsam file into seq file. account is reimb next year and this year only then it should be like this: 0000 0011 account is reimb only 3 and 4 years back only: 0011 0000 Please find below example of current input file and output binar...
by Vikas.betu
Mon Feb 24, 2014 8:08 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: bit to 8 different char
Replies: 38
Views: 37208

William/ Dik Please find below sysout Sysout : SYSDIAG= 6851696, 9502323, 9502323, 4970550 8,876K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED, 128K BYTES RESERVE REQUESTED, 1,347,536 BYTES USED 20K BYTES OF EMERGENCY SPACE ALLOCATED SORTIN : RECFM=F ; LRECL= 1000; CISIZE = 4096 SORTIN : DSNAME...