Article

Pro2 - Utility to identify missing records for a single table

Information

 
Article Number000091473
EnvironmentProduct: OpenEdge
Version: All supported versions
Product: Pro2Ent, Pro2Pro, Pro2SQL, Pro2Ora
Version: All supported versions
OS: Windows
Question/Problem Description
This utility is intended to identify missing target side records from a single table.
The output information will provide the ROWID and a specific field data to help in identifying the records that exist on the source side but not on the target. 
Steps to Reproduce
Clarifying Information
Error Message
Defect/Enhancement Number
Cause
Resolution
This utility has 4 variables that must be configured prior to running it:
DEFINE VARIABLE sDatabase AS CHARACTER   NO-UNDO INITIAL "sourcedb".
DEFINE VARIABLE tDatabase AS CHARACTER   NO-UNDO INITIAL "targetdb".
DEFINE VARIABLE tableName AS CHARACTER   NO-UNDO INITIAL "customer".
DEFINE VARIABLE fieldName AS CHARACTER   NO-UNDO INITIAL "custnum".
Change each variable initial value to the desired names. 

sDatabase = Source database name.
tDatabase = Target database name.
tableName = The desired table.
fieldName = A unique field which identifies the record from the application perspective. 

Once the changes have been made run the procedure from within a Pro2 editor and take note of the missing records. 

Note: This utility only works in a Pro2 LAN environment.  
 
Workaround
Notes
Last Modified Date9/10/2018 8:31 PM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025