#! /usr/bin/perl use strict; use warnings; my $print; while () { $print = 1 if /^AIR_TCD/; $print = 0 if $print && /record\(s\) selected/; print if $print; } __DATA__ DATE1=2018-05-24 DATE=2018-05-20 SETTING USER RELATED INFORMATION .. SETTING USER RELATED INFORMATION .. ; Database Connection Information ;Database server = DB2/LINUXX8664 10.5.6 ;SQL authorization ID = ORV5_ETL ;Local database alias = CHADDB AIR_TCD_AIR_CS5 ------------------------------------------- 1 2 3 ------------------- ----------- ----------- 2018-05-20-00.00.00 761 1186102 2018-05-21-00.00.00 773 1226970 2018-05-22-00.00.00 746 1158361 2018-05-23-00.00.00 767 1225759 2018-05-24-00.00.00 727 1123991 ; 5 record(s) selected. DB20000I The TERMINATE command completed successfully. SETTING USER RELATED INFORMATION .. ; Database Connection Information ;Database server = DB2/LINUXX8664 10.5.6 ;SQL authorization ID = ORV5_ETL ;Local database alias = CHADDB AIR_TCD_CCN:VOICE_CS5 ------------------------------------------- 1 2 3 ------------------- ----------- ----------- 2018-05-20-00.00.00 4554 7578729 2018-05-21-00.00.00 4533 7533879 2018-05-22-00.00.00 4399 7349718 2018-05-23-00.00.00 4597 7781008 2018-05-24-00.00.00 4411 7344806 ; 5 record(s) selected. #### AIR_TCD_AIR_CS5 ------------------------------------------- 1 2 3 ------------------- ----------- ----------- 2018-05-20-00.00.00 761 1186102 2018-05-21-00.00.00 773 1226970 2018-05-22-00.00.00 746 1158361 2018-05-23-00.00.00 767 1225759 2018-05-24-00.00.00 727 1123991 AIR_TCD_CCN:VOICE_CS5 ------------------------------------------- 1 2 3 ------------------- ----------- ----------- 2018-05-20-00.00.00 4554 7578729 2018-05-21-00.00.00 4533 7533879 2018-05-22-00.00.00 4399 7349718 2018-05-23-00.00.00 4597 7781008 2018-05-24-00.00.00 4411 7344806