IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Include groups of records


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
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
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: 2432
Location: Hampshire, UK

PostPosted: Wed Dec 30, 2015 7:34 pm
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
Reply with quote

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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Thu Dec 31, 2015 8:57 am
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: 746
Location: Pennsylvania

PostPosted: Thu Dec 31, 2015 6:53 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Inserting records into the empty segm... IMS DB/DC 0
No new posts JCL to extract repeating records DFSORT/ICETOOL 6
No new posts Group selective VB records - Trailer ... DFSORT/ICETOOL 16
This topic is locked: you cannot edit posts or make replies. SORT the records based on the second ... SYNCSORT 1
No new posts Required Date Format in Include Sort ... DFSORT/ICETOOL 6

Back to Top