|
View previous topic :: View next topic
|
| Author |
Message |
Sam07Sam
Currently Banned
New User
Joined: 16 Dec 2020
Posts: 1
Location: India
|
|
|
|
Hi,
I have one control file in the below layout format.The record length is 100 and one Flat Date parm file(layout of timestamp 20201211055202)
Basically, my requirement is to compare the GRAND total of control file-1 with the sum of individual .dat file record counts(total 5 files given below with record count) and make sure it is same. if not some RC should pop.
2nd Req: Once the above step runs fine, I have to make sure the Flat file timestamp is the same as the previous session run timestamp and less than incremental Load timestamp else return code.
3rd req: Once the 2nd step runs fine,I have to replace the Flat file timestamp with the Incremental Load timestamp of Control file-1.and for subsequent next day run with Control file-2 and so on...
Control file1 layout:
| Code: |
GRAND TOTAL=00000000000042669177
Previous session run timestamp=11110101000000
Incremental load timestamp=20201211055202
SPS_OB_IND_PROV_FULL_FILE_V1.0_20201130071138_001.dat 00008533835 [u] (Pos will start from 81 col to 91 col in same line)[/u]
SPS_OB_IND_PROV_FULL_FILE_V1.0_20201130071138_002.dat 00008533836
SPS_OB_IND_PROV_FULL_FILE_V1.0_20201130071138_003.dat 00008533836
SPS_OB_IND_PROV_FULL_FILE_V1.0_20201130071138_004.dat 00008533836
SPS_OB_IND_PROV_FULL_FILE_V1.0_20201130071138_005.dat 00008533834 |
Coded for you |
|
| Back to top |
|
 |
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1245
Location: Bamberg, Germany
|
|
|
|
| And you have tried what by yourself? Samples/Attempts/Anything? |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
| JCL cannot do this and you have not mentioned VSAM so why post in this section of the forum? I suggest that you decide how this requirement is to be achieved (COBOL/PL/1/Rexx/some other programming language/standard utility) and let us know so that this topic can be moved to a more appropriate part of the forum. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2018
Location: USA
|
|
|
|
| Sam07Sam wrote: |
Hi,
I have one control file in the below layout format.The record length is 100 and one Flat Date parm file(layout of timestamp 20201211055202)
Basically, my requirement is to compare the GRAND total of control file-1 with the sum of individual .dat file record counts(total 5 files given below with record count) and make sure it is same. if not some RC should pop.
2nd Req: Once the above step runs fine, I have to make sure the Flat file timestamp is the same as the previous session run timestamp and less than incremental Load timestamp else return code.
3rd req: Once the 2nd step runs fine,I have to replace the Flat file timestamp with the Incremental Load timestamp of Control file-1.and for subsequent next day run with Control file-2 and so on...
Control file1 layout:
| Code: |
GRAND TOTAL=00000000000042669177
Previous session run timestamp=11110101000000
Incremental load timestamp=20201211055202
SPS_OB_IND_PROV_FULL_FILE_V1.0_20201130071138_001.dat 00008533835 [u] (Pos will start from 81 col to 91 col in same line)[/u]
SPS_OB_IND_PROV_FULL_FILE_V1.0_20201130071138_002.dat 00008533836
SPS_OB_IND_PROV_FULL_FILE_V1.0_20201130071138_003.dat 00008533836
SPS_OB_IND_PROV_FULL_FILE_V1.0_20201130071138_004.dat 00008533836
SPS_OB_IND_PROV_FULL_FILE_V1.0_20201130071138_005.dat 00008533834 |
Coded for you |
This post sounds like a Statement Of Work given by yourself to the members of this forum? As if you had been assigned a manager to control our activity, isn’t it? |
|
| Back to top |
|
|
Garry Carroll
Senior Member
Joined: 08 May 2006
Posts: 1193
Location: Dublin, Ireland
|
|
|
|
| Quote: |
| if not some RC should pop. |
... and how to make a return code "pop" ??
Garry. |
|
| Back to top |
|
|
|
|
