[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: PRO2 : is there a way of exclude specific Data from Columns ?

  • Thread starter Thread starter Nuthana Dasari
  • Start date Start date
Status
Not open for further replies.
N

Nuthana Dasari

Guest
Hi Adrian, Yes it is possible. We do have a support for Custom Retention Rules. If you want to omit any data then you can write your own condition to avoid the data from replication/bulk loading. Please find the steps below to add Retention rules. 1. Go to Tools->Custom Retention Rules from Pro2 Admin tool 2. A new window which displays the info regarding generating rules will pop up. Click 'OK' 3. Click on 'Add' to add the new rule 4. Enter Source DB, table details 5. Enter your condition in 'Condition Statement' text box. You can always use 'Past-DB-Tab' to select the source db 6. Here is the example statement to avoid data from customer table which has country as 'USA' >.customer.country = "USA" 7. After adding the Condition then clock on 'Save' 8. Generate the Process Libraries again and restart the replication threads. Hope this will work for your situation. Thanks, Nuthana

Continue reading...
 
Status
Not open for further replies.
Back
Top