Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

User abend 016 for SYNCSORT MERGE
Goto page 1, 2  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
balakrishna reddy

Active User


Joined: 13 Jul 2007
Posts: 130
Location: Guntur

PostPosted: Tue Jul 31, 2007 6:51 pm    Post subject: User abend 016 for SYNCSORT MERGE
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    Post subject:
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: 130
Location: Guntur

PostPosted: Tue Jul 31, 2007 8:24 pm    Post subject:
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

Site Director


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

PostPosted: Tue Jul 31, 2007 11:46 pm    Post subject:
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

Senior Member


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

PostPosted: Wed Aug 01, 2007 11:27 am    Post subject:
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: 130
Location: Guntur

PostPosted: Wed Aug 01, 2007 12:41 pm    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Wed Aug 01, 2007 12:54 pm    Post subject:
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: 130
Location: Guntur

PostPosted: Wed Aug 01, 2007 2:35 pm    Post subject:
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    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Wed Aug 01, 2007 3:18 pm    Post subject:
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    Post subject:
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: 130
Location: Guntur

PostPosted: Wed Aug 01, 2007 3:45 pm    Post subject:
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    Post subject:
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

Senior Member


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

PostPosted: Wed Aug 01, 2007 4:16 pm    Post subject:
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    Post subject:
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: 130
Location: Guntur

PostPosted: Thu Aug 02, 2007 4:39 pm    Post subject:
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

Senior Member


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

PostPosted: Thu Aug 02, 2007 5:57 pm    Post subject:
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: 130
Location: Guntur

PostPosted: Thu Aug 02, 2007 6:40 pm    Post subject:
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

Senior Member


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

PostPosted: Thu Aug 02, 2007 7:12 pm    Post subject:
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    Post subject: Reg of syncsort
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 3 Fri Dec 02, 2016 9:47 am
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us