|
View previous topic :: View next topic
|
| Author |
Message |
jyotsnapanicker
New User
Joined: 30 Dec 2015
Posts: 2
Location: India
|
|
|
|
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 |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
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 |
|
|
jyotsnapanicker
New User
Joined: 30 Dec 2015
Posts: 2
Location: India
|
|
|
|
| Syncsort v 1.2.3R doesnt support "group" |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| 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 |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
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.  |
|
| Back to top |
|
|
|
|
