This example shows you how to reverse changes to resources from a test library (in SQLServer) to a development library (in SQL Server).
This example reverses the promotion performed in Promoting Resources. The LBYPROC utility is run with a single Rollback script. The Rollback script specifies the source library name (LBYTEST) and the target library name (LBYDEV). Each library is stored in an SQL server database. Note that the source library is the library you are rolling back from and the target library is the library you are rolling back to.
| Note | A rollback does not copy any resources from the source library to the target library. A rollback removes a resource from the source library and, optionally, updates the Mode, Status, Class, and/or Project fields of that resource in the target library to a value you assign, like RolledBack, to indicate that it has been rolled back from a higher library. |
In this example, resources in the source library (LBYTEST) that have a status of TEST are removed from this library. In the target library (LBYDEV), these resources are then assigned a status of RolledBack.
If you run the utility with these parameters:
C:\fap\dll\dms1dm>lbyproc /i=deflib\roll3.lsc
You will get this output from the utility:
--- LBYPROC Copyright (C) 1997, 2009 Oracle. All rights reserved.
--- Documaker library script processor
ROLLBACK Successful. Name<Q1ADDR> Type<FAP> Ver<00001> Rev<00001> Note<Normal rollback>
ROLLBACK Successful. Name<Q1AFLG> Type<FAP> Ver<00001> Rev<00001> Note<Normal rollback>
ROLLBACK Successful. Name<Q1B302> Type<FAP> Ver<00001> Rev<00001> Note<Normal rollback>
ROLLBACK Successful. Name<Q1BA32> Type<FAP> Ver<00001> Rev<00001> Note<Normal rollback>
ROLLBACK Successful. Name<SUPPLEMENT> Type<FOR> Ver<00001> Rev<00001> Note<Normal rollback>
ROLLBACK Successful. Name<FSI_CPP> Type<GRP> Ver<00001> Rev<00001> Note<Normal rollback>
ROLLBACK Successful. Name<Q1DLOG> Type<LOG> Ver<00001> Rev<00001> Note<Normal rollback>
--- LBYPROC Complete ---
Here are the contents of the pro3.lsc file, which contains the Rollback script:
<LBYSCRIPT>
<ROLLBACK>
<LIBRARY SRC="LBYTEST" TGT="LBYDEV"/>
<NAME SRC=""/>
<TYPE SRC=""/>
<VERSION SRC=""/>
<REVISION SRC=""/>
<USERID SRC=""/>
<EFFDATE SRC=""/>
<MODE SRC="" TGT=""/>
<STATUS SRC="TEST" TGT="ROLLEDBACK"/>
<CLASS SRC="" TGT=""/>
<PROJECT SRC="" TGT=""/>
</ROLLBACK>
</LBYSCRIPT>
© Copyright 2012, Oracle and/or its affiliates. All rights reserved. Legal notices.