$Count_ABAP_DF = $Count_Target_DB_Table.
• We can Insert the Source Count and Target Count values from Audit Labels, into any Table using below Script.
This Script is used in Custom Audit Condition.
$Count_Source_Count=$Count_Target_Count
and
sql('Target_SQL', 'insert into dbo.Source_table_Count values ([$Count_Source_Count],[$Count_Target_Count])') is NULL ## THIS CONDITION IS ALWAYS TRUE as Output of Insert query is NULL
After successful completion of the Job, You will find the Source and Target Counts inserted into the Control Table.
select * from Source_table_Count
Source_Count | Target_Count |
66 | 66 |
Note: This Script can be used in Any Audit Condition regardless of the type of Source/Target table, to Capture Audit Label Value.
1.
2.
3.
4.Apply the above mentioned script in Custom Audit Condition.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 |