mainframe


How can I remove duplicates from an input file and write duplicates to a file without using XSUM in JCL? [closed]


How to remove duplicate file and write duplicate into file without using 'ICETOOL'
I tried this code it's working fine. But I Can't use ICETOOL. How to do this without XSUM
//SORTXSUM DD DSN=datasetname,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(1,4),RLSE),
// DCB=(RECFM=FBM,LERCL=80,BLKSIZE=800)
//SYSIN DD *
SORT FIELDS=(1,3,CH,A)
SUM FIELDS=NONE,XSUM
/*
You are using SyncSORT. SyncSORT provide the undocumented SyncTOOL which is to provide the functionality of DFSORT's ICETOOL. When installed at sites, SyncTOOL is often Aliased to ICETOOL to ease migration of the JCL.
SyncSORT mainly has the same functionality as DFSORT. One of the extras, however, that SyncSORT has is XSUM. XSUM is a SORT function which writes the duplicate records which would otherwise be omitted by a SUM statement to a specific DDNAME.
SyncTOOL has a number of operators for combining SORT functionality and providing high-level extensions to that functionality. To find out what they are, the only documentation you can look at is DFSORT's, which is IBM's original product with which SyncSORT competes.
If you look at Chapter 7 of the DFSORT Application Programming Guide you will find out about ICETOOL. Most of the functionality of ICETOOL is provided by SyncTOOL, depending on how up-to-date your SyncTOOL is.
XSUM belongs to SORT. SyncTOOL/ICETOOL are not SORT. XSUM is not part of SyncTOOL/ICETOOL.
You are not using ICETOOL. The example you have shown is using SORT. You are not using ICETOOL.
You have code that works for you (although you failed to paste it here correctly) which uses EXEC PGM=SORT and supplies XSUM on one of the control cards.
You have not used PGM=ICETOOL, and if you did, you would not have been able to use XSUM on SYSIN (you would have had to use TOOLIN for ICETOOL/SyncTOOL, and could only specify SORT statements, where allowed by the syntax, in xxxxCNTL files, which you haven't used.
You are good to go, and there is no question to answer.
Further from the comments before they are removed, you should not code DCB or any of its sub-parameters on an output file from SORT. SORT will supply the correct ones for you. You must not have blank cards in your JCL, this will generate a //SYSIN DD * which at best will cause you confusion. SORT and SUM must be preceded by at least one blank.

Related Links

SMTP Flat File losing formatting in email
Best Practice for Mainframe Testing Environment to create QA, UAT [closed]
z/OS Partitioned dataset access of JCL jobs through Notepad++/any other editors in windows
SORT to replace a column in JCL
point statement in easytrieve
JCL job with java source code within SYSIN DD *
Running JConsole on MainFrame
Splitting of Mainframe datasets based on header
JCL what is wrong with this?
Find and delete dynamic string using JCL
Compare two files and include both match and non match records
How to get a notification ( by an email ) of mainframe job completion
Passing input for COND through a file
How to compare two totals from different datasets
z/VSE sample jcl to print sequential file to spool
How to remove these duplicates?

Categories

HOME
ajax
semantic-ui
openssl
npm
amazon-product-api
automated-tests
orientation
data-science-experience
proguard
internet-explorer-11
unity2d
jboss-eap-7
gwtp
activesync
multiple-monitors
event-log
flat-file
internet-explorer-8
distance
shippo
thingsboard
spring-ws
explode
csh
pitest
protobuf-net
exponential
idl
modelandview
division
gettext
superpowered
css-counter
wfp
codesys
parse-android-sdk
poco-libraries
fax
linq-to-entities
infusionsoft
onbackpressed
nsexception
homekit
upsert
stress-testing
resuming-training
cppunit
range-v3
taskmanager
slot
forerunnerdb
barcode-printing
build-process
android-navigationview
update-site
jackson-databind
django-south
asp.net-mvc-2
loopj
persistence.xml
datasnap
textkit
python-winshell
webhdfs
twython
vine
ytplayerview
type-mismatch
debian-based
cpan
python-ggplot
pisa
ogr2ogr
io.js
slick-2.0
opensocial
roxygen
hamsterdb
magicalrecord-2.2
document-database
haskell-platform
database-permissions
moq-3
sunspot-rails
scrollto
parameterization
nssavepanel
wchar
nsindexpath
datacontract
dashcode
nagle
gethashcode
hardware-acceleration
clients
mvvm-foundation
asp.net-mvc-controller
usability-testing
system-codedom-compiler
evb
database-diagramming
visual-studio-dbpro

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App