Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
with CTE1 as ( select MAP_TRANCODE_ID, MAP_ID, TRANCODE, MAP_TYPE, DELETE_FLAG, FILE_GROUP_CODE, CATEGORY, FILE_FORMAT_ID, DATE_FORMAT_OPTION, MATCHING_KEY_ID, MAKE_ACCOUNT_OPTION, row_number() over (PARTITION BY MAP_ID, TRANCODE, MAP_TYPE, DELETE_FLAG, FILE_GROUP_CODE, CATEGORY, FILE_FORMAT_ID, DATE_FORMAT_OPTION, MATCHING_KEY_ID, MAKE_ACCOUNT_OPTION order by MAP_TRANCODE_ID) cte1_RN from TLF_MAP_TRANCODE where DELETE_FLAG = 'N' ) , CTE2 as ( select cte1_2.MAP_TRANCODE_ID, cte1_2.MAP_ID, row_number() over (PARTITION BY cte1_2.MAP_ID) cte2_RN FROM CTE1 cte1_1 Join CTE1 cte1_2 on cte1_2.MAP_ID = cte1_1.MAP_ID where cte1_1.cte1_RN > 1 and cte1_2.MAP_TRANCODE_ID in ( select MT.MAP_TRANCODE_ID AS "MT.MAP_TRANCODE_ID" from FTC.TLF_MAP_TRANCODE MT LEFT JOIN FTC.TLF_FILE_ATTRIBUTE FA on MT.MAP_TRANCODE_ID = FA.MAP_TRANCODE_ID where FA.MAP_TRANCODE_ID is null ) ) select MAP_TRANCODE_ID from TLF_MAP_TRANCODE where MAP_TRANCODE_ID in ( select MAP_TRANCODE_ID FROM CTE2 where CTE2_RN = 1 )
|Analytical functions in db2||2||304|
|Exclude numbers that start with 7||4||229|
|OleDb Command Timeout setting is ignored when calling DB2 stored procedure||8||430|
|Something from iSeries disc to install on Windows machine to allow access||5||101|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!