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
 

 

Include groups of records

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
jyotsnapanicker

New User


Joined: 30 Dec 2015
Posts: 2
Location: India

PostPosted: Wed Dec 30, 2015 4:37 pm    Post subject: Include groups of records
Reply with quote

I have a FB file record length 50 which consists of account info in the header, starting at position 11 of length 5 followed by detailed records. Each account can have a different number of detailed records.
For example:
Code:
01ABCDEFGH12345678
02ABCDEFGHGAJHGJHG
03ABCDEFGHIJKLKLMNO
03ABCDEFGHGAJRSTUV
04ABCDEFGHIJKRSTUV0
13ABCDEFGHIJKRSTMNO
01ABCDEFGH87654321
02ABCDEFGHGAJHGJHG
03ABCDEFGHIJKLKLMNO
13ABCDEFGHIJKRSTMNO


I need to pull all records associated with specific account

I had thought I would use something like...
INREC IFTHEN=(WHEN=GROUP,BEGIN=(11,5,CH,EQ,C'12345'),PUSH=(52:11,5))

This would suffix account number to all records associated with the account, and outfile include condition will let me select all records of the account.

Since we are using Syncsort 1.2 and group, begin and push isn't working and I'm not sure how to achieve this.
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Wed Dec 30, 2015 7:34 pm    Post subject:
Reply with quote

What do you mean by "isn't working"? !Isn't working" covers all sorts of things from job not run JCL error to job abended or wrong data selected or whatever.

You need to show your control cards as used, the rror message(s) if any, the input data, the desired output data and the actual output data.
Back to top
View user's profile Send private message
jyotsnapanicker

New User


Joined: 30 Dec 2015
Posts: 2
Location: India

PostPosted: Wed Dec 30, 2015 7:41 pm    Post subject: Reply to: Include groups of records
Reply with quote

Syncsort v 1.2.3R doesnt support "group"
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7233

PostPosted: Thu Dec 31, 2015 8:57 am    Post subject: Reply to: Include groups of records
Reply with quote

1.2 is very old. Does your SyncTOOL support SPLICE? Even then I think it would be... interesting. You'll probably be best off by writing a program. A SORT Exit if you want to add it into an existing SORT.
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 645
Location: Pennsylvania

PostPosted: Thu Dec 31, 2015 6:53 pm    Post subject:
Reply with quote

At my company, the Systems Programmer would be shot, and the Manager fired, for allowing such an outdated version of a product to still be running on our system. icon_neutral.gif
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 -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


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