MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Easytrive-Remove bad char from inout flat file
Goto page Previous  1, 2
 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming
View previous topic :: View next topic  
Author Message
Phantom
Data Mgmt Moderator
Data Mgmt Moderator


Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet

PostPosted: Thu Sep 29, 2005 8:43 am    Post subject: Reply with quote

rsivananda,

Version 1.1 is one of the latest versions of syncsort (Latest: 1.2). This supports ALTSEQ. Customize my code and try it. Should work.

Thanks,
Phantom
Back to top
View user's profile Send private message
rsivananda
Beginner


Joined: 11 Aug 2004
Posts: 30
Topics: 10

PostPosted: Thu Sep 29, 2005 8:48 am    Post subject: Reply with quote

Apologies to Phantom for not responding to that question on file2
I thought it's file1 alone.
anyway i am checking with the code u have sent and will get back to u
Back to top
View user's profile Send private message
rsivananda
Beginner


Joined: 11 Aug 2004
Posts: 30
Topics: 10

PostPosted: Thu Sep 29, 2005 9:18 am    Post subject: Reply with quote

Hi Phantom
I tried executing u r code and resulted in the following error

WER164B 1,028K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 1,020K BYTES USED
WER146B 4K BYTES OF EMERGENCY SPACE ALLOCATED
WER267A SORT STATEMENT : STATEMENT NOT FOUND
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE

The : is missing and coudn't fix that. Could you plz help me out and i think i need to sit with syncsort guide to explore more options and syntax
Back to top
View user's profile Send private message
Phantom
Data Mgmt Moderator
Data Mgmt Moderator


Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet

PostPosted: Thu Sep 29, 2005 9:25 am    Post subject: Reply with quote

rsivananda,

Did you change PGM=SYNCTOOL to PGM=SORT ?

If so, you need to use SORT FIELDS=COPY.

If not, Then paste your JCL. Probably in TOOLIN or CTL1CNTL, you would not have left any blanks before COPY / OUTFIL statement.

Syntax: You need to leave atleast 1 space in each and every line of SYSIN / TOOLIN / Custom control cards while using Sort.

Thanks,
Phantom
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Thu Sep 29, 2005 9:34 am    Post subject: Reply with quote

Rsivananda,

Here is an untested code. I assumed that your special char has just one record with all possible special character. I coded it for a max of 80 special characters.

[code:1:a2586d03ff]
//STEP0100 EXEC PGM=EZTPA00
//*
//STEPLIB DD DSN=EASYTREV.LOADLIB,
// DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSSNAP DD SYSOUT=*
//INFILE DD DSN=YOUR INPUT FILE,
// DISP=SHR
//SPLCHAR DD *
`~!@#$%^&*()_-+=[]{}\
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
rsivananda
Beginner


Joined: 11 Aug 2004
Posts: 30
Topics: 10

PostPosted: Mon Oct 24, 2005 2:41 am    Post subject: Reply with quote

Phantom and Kolusu... All i can say ur stars... the code is absolutely working and into production now.i used the ezt solution
Back to top
View user's profile Send private message
Nabanita Das
Beginner


Joined: 09 Nov 2005
Posts: 33
Topics: 10

PostPosted: Fri Nov 25, 2005 8:07 am    Post subject: Reply with quote

Can anyone give me similar code in SAS. My shop does not have EZT, sorry. Any help??????????????????
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Sat Nov 26, 2005 9:05 am    Post subject: Reply with quote

Quote:

Can anyone give me similar code in SAS. My shop does not have EZT, sorry. Any help??????????????????


Nabanita Das,

You can customize the solutions posted in this link

http://www.sconsig.com/sastips/tip00283.htm

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming All times are GMT - 5 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group