Thursday, June 18, 2015

Running "udatacnv.sqr" report


Each of the upgrade data conversion sections contains comments that describe the processing performed by the section. 

PeopleSoft has delivered an SQR to list all of these comments by the group and sequence numbers that determine how they run. The name of this report is UDATACNV.
To run UDATACNV:
1. Using SQRW, run SQR UDATACNV on your Copy of Production database.
2. When prompted for Upgrade Path, enter:
3. When prompted for Group Number, enter the two-digit group number to report on, or enter 0 to see the comments for all groups.


You can get the Upgrade Path and Group Number using the below sequel statements:

SELECT DISTINCT UPG_PATH  FROM PS_UPG_DATACONV ORDER BY 1

SELECT * FROM PS_UPG_DATACONV ORDER BY 1


No comments :

Post a Comment