IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

User abend 016 for SYNCSORT MERGE


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 128
Location: Guntur

PostPosted: Tue Jul 31, 2007 6:51 pm
Reply with quote

Hi all,

Can any one resolve this issue.

i am getting u016 abend when i am trying to do merge on 3 flat files

i will provide you my jcl so that you can find where the error is.

Code:

STEP03  EXEC PGM=SORT                                   
SYSOUT   DD   SYSOUT=*                                     
SORTIN01 DD   DSN=TEST.BALA.FILEA,DISP=SHR               
SORTIN02 DD   DSN=TEST.BALA.FILEB,DISP=SHR               
SORTIN03 DD   DSN=TEST.BALA.FILEC,DISP=SHR               
SORTOUT  DD   DSN=TEST.BALA.FILE,DISP=(,CATLG,DELETE),
         UNIT=SYSDA,SPACE=(CYL,(20,10))
SYSIN    DD   *                                         
         MERGE FIELDS=(46,2,CH,A)
/*


when i opened the spool messages it is showing like numeric error
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Tue Jul 31, 2007 7:19 pm
Reply with quote

balakrishna reddy
Provide your SYSOUT details.
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 128
Location: Guntur

PostPosted: Tue Jul 31, 2007 8:24 pm
Reply with quote

krisprems wrote:
Quote:

Provide your SYSOUT details


Hi this is my sysout information,need anything else please let me know
Code:

                                       G
                                       
 MERGE FIELDS=(45,2,A,CH)               
                      *                 
 MERGE STATEMENT   : NUMERIC FIELD ERROR
 SYNCSMF  CALLED BY SYNCSORT; RC=0000   
 SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE   
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Jul 31, 2007 11:46 pm
Reply with quote

Hello,

Instead of
Code:
 MERGE FIELDS=(45,2,A,CH)

try
Code:
 MERGE FIELDS=(45,2,CH,A)
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Aug 01, 2007 11:27 am
Reply with quote

Reddy,

A small doubt, your original JCL (first post of this thread from you) shows
Code:
MERGE FIELDS=(46,2,CH,A)

while in SYSOUT you got the error in
Code:
MERGE FIELDS=(45,2,A,CH)

bit strange for me. Can you please clarify.
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 128
Location: Guntur

PostPosted: Wed Aug 01, 2007 12:41 pm
Reply with quote

hi anuj,

I am really very sorry,that was one of my trails to get rid of the abend

even though i changed it to
Code:

merge fields=(46,2,A,CH)


the same message is coming
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Wed Aug 01, 2007 12:54 pm
Reply with quote

Please post your sysout.
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 128
Location: Guntur

PostPosted: Wed Aug 01, 2007 2:35 pm
Reply with quote

hi thomposon,

Quote:

Please post your sysout.


Code:

BROWSE - SYSOUT            STEP03   - Page  1     Line  1      Cols 1-80       
COMMAND ===>                                                SCROLL ===> SCREEN
******************************** Top of Data ***********************************
 SYNCSORT FOR Z/OS  1.1DN   TPF3   U.S. PATENTS: 4210961, 5117495  (C) 2002 SYNC
                                                GLICOA   z/OS   1.7.1           
 SYSIN :                                                                       
            MERGE FIELDS=(46,2,A,CH)                                           
                                 *                                             
 WER271A  MERGE STATEMENT   : NUMERIC FIELD ERROR                               
 WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000                                 
 WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE                                 


this is my sysout.
Back to top
View user's profile Send private message
shankar.v

Active User


Joined: 25 Jun 2007
Posts: 196
Location: Bangalore

PostPosted: Wed Aug 01, 2007 2:45 pm
Reply with quote

I think for MERGE, we should have to use EXEC PGM=ICEMAN.

Change the EXEC PGM=SORT to EXEC PGM=ICEMAN and MERGE FIELDS=(46,2,A,CH) to MERGE FIELDS=(46,2,CH,A)
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Wed Aug 01, 2007 3:18 pm
Reply with quote

Sort will work just fine, but you must get the format of the fields parameter correct......
Back to top
View user's profile Send private message
shankar.v

Active User


Joined: 25 Jun 2007
Posts: 196
Location: Bangalore

PostPosted: Wed Aug 01, 2007 3:41 pm
Reply with quote

Balakrishna reddy,

MERGE FIELDS=(46,2,A,CH) is an incorrect syntax.
Change MERGE FIELDS=(46,2,A,CH) to MERGE FIELDS=(46,2,CH,A) and make sure that the SORTINnn input files are in the sorted order of 46,2,CH,A
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 128
Location: Guntur

PostPosted: Wed Aug 01, 2007 3:45 pm
Reply with quote

Hi shankar,

i have did the same you have suggested,still abend is coming.

below i am giving you the sysout.
Code:

                                                         
  MERGE FIELDS=(46,2,CH,A)                               
8,876K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
   0 BYTES RESERVE REQUESTED, 1,004K BYTES USED         
20K BYTES OF EMERGENCY SPACE ALLOCATED                   
SORTOUT  NOT DEFINED                                     
SYNCSMF  CALLED BY SYNCSORT; RC=0000                     
SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE                     
Back to top
View user's profile Send private message
shankar.v

Active User


Joined: 25 Jun 2007
Posts: 196
Location: Bangalore

PostPosted: Wed Aug 01, 2007 4:10 pm
Reply with quote

Quote:
SORTOUT NOT DEFINED


This means that SORTOUT DD statement could not be found.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Aug 01, 2007 4:16 pm
Reply with quote

Reddy,

In a nut-shell, what Dick has suggested long back use that syntax. After the change, show your JCL & the SYSOUT messages from this JOB to get better suggestions.
However, in the SYSOUT, shown above in your post, there is
Code:
SORTOUT  NOT DEFINED
I think, instead of SORTOUT, you used some other DD Name(ah..I can just guess, please show your JCL & SYSOUT).
Back to top
View user's profile Send private message
BalaMuraliL

New User


Joined: 01 Aug 2007
Posts: 10
Location: Pune

PostPosted: Wed Aug 01, 2007 5:29 pm
Reply with quote

Hi Balakrishna,

As per my observation, I have few questions and suggessions to you

Question 1:

Did you create the dataset to store the output records ? Or Are you creating newly in the same JCL ?

Suggession 1 :
If Not, try with the DCB parameters with equal record length of your input records.

Question 2 :

Did you mention temporary work space ? I hope you didn't mention the temporary work space for sorting and merging all the records that are located in input files.

Suggession 2 :

If you didn't mention that then please code this
//SORTWK00 DD UNIT=SYSDA, SPACE=(CYL ( n , n), RLSE )
or
//SORTWK00 DD DSN=&TEMP, UNIT=SYSDA,SPACE=(CYL ( n , n), RLSE ) (Note : Code Primary & Secondary spaces based on your number of inputs records)

Suggession 3 :

If your input records are more please specify more work spaces.. Like this..

//SORTWK00 DD UNIT=SYSDA, SPACE=(CYL ( n , n), RLSE )
//SORTWK01 DD UNIT=SYSDA, SPACE=(CYL ( n , n), RLSE )
//SORTWK02 DD UNIT=SYSDA, SPACE=(CYL ( n , n), RLSE )
//SORTWK03 DD UNIT=SYSDA, SPACE=(CYL ( n , n), RLSE )

Suggession 4 :

Check all your input records of length, formate,blocksize also, should be equal in all the input data sets.

Suggession 5 :

Try use PGM=SORT


Please let me know if it works / any issues..

Please try to mention clear information about the issue with JOB and JCL error messages.
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 128
Location: Guntur

PostPosted: Thu Aug 02, 2007 4:39 pm
Reply with quote

Hi ,

this is my jcl :

Code:

STEP03  EXEC PGM=SORT                                   
SYSPRINT DD SYSOUT=*                                     
SORTIN01 DD   DSN=TEST.BALA.FILEA,DISP=SHR               
SORTIN02 DD   DSN=TEST.BALA.FILEB,DISP=SHR               
SORTIN03 DD   DSN=TEST.BALA.FILEC,DISP=SHR               
SORTOUT1  DD   DSN=TEST.BALA.FILE,DISP=(NEW,CATLG,DELETE),
             UNIT=SYSDA,SPACE=(CYL,(20,10)),             
             DCB=(LRECL=80,RECFM=FB,BLKSIZE=400,DSORG=PS)
SYSIN    DD   *                                         
         MERGE FIELDS=(46,2,CH,A)                       
                                                         
SYSPRINT  DD SYSOUT=*                                   
SYSOUT    DD SYSOUT=*                                   
SYSUDUMP  DD SYSOUT=*                                   
ABNLNODP  DD DUMMY                                       
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Thu Aug 02, 2007 5:57 pm
Reply with quote

Hi,

You have given SORTOUT1 in your SORT, change it to SORTOUT
Code:
SORTOUT1  DD   DSN=TEST.BALA.FILE,DISP=(NEW,CATLG,DELETE),
If you'll use above code you'll get U0016 & SYSOUT will show
Code:
SORTOUT  NOT DEFINED


So change your SORTOUT1 DD name to SORTOUT & let us know the result.
Back to top
View user's profile Send private message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 128
Location: Guntur

PostPosted: Thu Aug 02, 2007 6:40 pm
Reply with quote

oh thanks a lot anuj its working now.

what i did is when i am giving sortout in dd statement, i have given a wrong syntax for merge,it's showing numeric error . I changed that format to correct one and i also changed that dd name to sortout1,so, that's why i got that abend again.

thanks to all icon_biggrin.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Thu Aug 02, 2007 7:12 pm
Reply with quote

balakrishna reddy wrote:
its working now.

Good icon_smile.gif
Back to top
View user's profile Send private message
kotesh

New User


Joined: 11 May 2005
Posts: 20

PostPosted: Fri Sep 30, 2011 2:39 pm
Reply with quote

is it possible to complete in single step????

I tried in one step to create 4 files in next step I will mege all and copy to one.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Fri Sep 30, 2011 3:02 pm
Reply with quote

are You sleeping ? icon_biggrin.gif
haven' t You noticed that Your topic has been split and is <standing> on its own ?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts ISAM and abend S03B JCL & VSAM 9
No new posts PuTTY - "User is not a surrogate... IBM Tools 5
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts How to delete a user's alias from the... JCL & VSAM 11
Search our Forums:

Back to Top