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: 1731
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: 7280

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: 650
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 Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm
No new posts To Merge mutliple records into a sing... anandgbe DFSORT/ICETOOL 4 Wed Feb 22, 2017 8:49 am
No new posts Match records - scdinesh DFSORT/ICETOOL 6 Wed Feb 22, 2017 5:02 am
No new posts Matching and unmatching records scdinesh DFSORT/ICETOOL 11 Tue Feb 07, 2017 12:41 am
No new posts Sort Card to Remove Duplicate records... raj4neo SYNCSORT 2 Wed Jan 25, 2017 4:44 am


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