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

how to extract a portion (e.g. fields 10 - 20) of a record


IBM Mainframe Forums -> SYNCSORT
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
dot1q3
Warnings : 1

New User


Joined: 09 Feb 2021
Posts: 26
Location: United States

PostPosted: Fri Feb 26, 2021 5:36 am
Reply with quote

how to extract a portion (e.g. fields 10 - 20) of a record and send just that portion to a new dataset?
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 619
Location: Bamberg, Germany

PostPosted: Fri Feb 26, 2021 6:22 am
Reply with quote

Use some SORT product. That's one of the simplest tasks it can do for you.
Back to top
View user's profile Send private message
dot1q3
Warnings : 1

New User


Joined: 09 Feb 2021
Posts: 26
Location: United States

PostPosted: Fri Feb 26, 2021 6:31 am
Reply with quote

i'm using sort with the following sysin:

INREC FIELDS=(10,5)
SORT FIELDS=COPY


I'M GETTING IEC130I SYNOUT DD STATEMENT MISSING


ANY OTHER SUGGESTIONS OR SAMPLES?
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 619
Location: Bamberg, Germany

PostPosted: Fri Feb 26, 2021 11:15 am
Reply with quote

Add:
Code:
//SYMNOUT DD SYSOUT=*
//SYSOUT  DD SYSOUT=*


And, please use code tags when presenting code in the forum.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10801
Location: italy

PostPosted: Fri Feb 26, 2021 2:36 pm
Reply with quote

DO NOT POST THE SAME QUESTION ON DIFFERENT FORUMS AT THE SAME TIME

the people answering there are the same answering here
www.ibmmainframeforum.com/jcl/topic12492.html

decide where you want to carry on the discussion

the other topic will be deleted by a moderator
Back to top
View user's profile Send private message
sergeyken
Warnings : 2

Senior Member


Joined: 29 Apr 2008
Posts: 1201

PostPosted: Fri Feb 26, 2021 7:47 pm
Reply with quote

Joerg.Findeisen wrote:
Add:
Code:
//SYMNOUT DD SYSOUT=*
//SYSOUT  DD SYSOUT=*


And, please use code tags when presenting code in the forum.


In fact, only one of those DD is needed for a particular system.
Code:
//SYNOUT DD SYSOUT=*
//SYSOUT  DD SYSOUT=*


Initially, //SYSOUT has been used by SYNCSORT developers. Then it was found that this //SYSOUT is used by many other programs, which may conflict when more than two of them are called within the same job step. So, in some particular installed versions the default value was changed to //SYNOUT

Try: which one is working in your configuration, and continue using only that one.
Back to top
View user's profile Send private message
sergeyken
Warnings : 2

Senior Member


Joined: 29 Apr 2008
Posts: 1201

PostPosted: Fri Feb 26, 2021 8:00 pm
Reply with quote

dot1q3 wrote:
i'm using sort with the following sysin:

INREC FIELDS=(10,5)
SORT FIELDS=COPY


I'M GETTING IEC130I SYNOUT DD STATEMENT MISSING


ANY OTHER SUGGESTIONS OR SAMPLES?


1. You have quoted your SORT control statements, but the problem is with your JCL code, not demonstrated. Do you understand the difference between apples, and oranges?

2. Is the message IEC130I SYNOUT DD STATEMENT MISSING not self-explanatory???
That exactly means that the required DD statement is missing. What you see is what you get.
Try to find the IBM explanation for IEC130I
Back to top
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 619
Location: Bamberg, Germany

PostPosted: Sat Feb 27, 2021 10:25 pm
Reply with quote

sergeyken wrote:
In fact, only one of those DD is needed for a particular system.
Code:
//SYNOUT DD SYSOUT=*
//SYSOUT  DD SYSOUT=*


Initially, //SYSOUT has been used by SYNCSORT developers. Then it was found that this //SYSOUT is used by many other programs, which may conflict when more than two of them are called within the same job step. So, in some particular installed versions the default value was changed to //SYNOUT

Thank you for this update. I always can learn new things from you. Thanks!
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2790
Location: NYC,USA

PostPosted: Sun Feb 28, 2021 8:28 pm
Reply with quote

Cleaned and locked.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts create table with more than 32k recor... DB2 1
No new posts Converting unpacked fields to pack us... SYNCSORT 4
No new posts SORT for dynamic trailer record + CSV... DFSORT/ICETOOL 14
No new posts Selective extract of multi-record-typ... SYNCSORT 4
No new posts Data for newly added fields not displ... IMS DB/DC 6
Search our Forums:

Back to Top