You are here: Available Utilities > L > LBYPROC > Promoting Resources > Example 3

Promoting Resources: Example 3

This example shows how to promote resources from a development library (in SQL Server) to a test library (in SQL Server). This script specifies the source library name (LBYDEV) and the target library name (LBYTEST). Each library is stored in an SQL Server database.

Resources in the source library (LBYDEV) that have a status of Passed are promoted to the target library (LBYTEST). In the target library, these newly promoted resources are assigned a status of Test. Upon successful promotion, the resources in the source library that were promoted are assigned a status of Promoted.

If you run the utility with these parameters:

c:\fap\dll\dms1dm>lbyproc /i=deflib\pro3.lsc

You will get this output from the utility:

--- Documaker library script processor

Found <1> Library Scripts

PROMOTE Successful. Name<Q1ADDR> Type<FAP> Ver<00001> Rev<00001> Note<Normal promotion>

PROMOTE Successful. Name<Q1AFLG> Type<FAP> Ver<00001> Rev<00001> Note<Normal promotion>

PROMOTE Successful. Name<Q1B302> Type<FAP> Ver<00001> Rev<00001> Note<Normal promotion>

PROMOTE Successful. Name<Q1BA32> Type<FAP> Ver<00001> Rev<00001> Note<Normal promotion>

PROMOTE Successful. Name<SUPPLEMENT> Type<FOR> Ver<00001> Rev<00001> Note<Normal promotion>

PROMOTE Successful. Name<FSI_CPP> Type<GRP> Ver<00001> Rev<00001> Note<Normal promotion>

PROMOTE Successful. Name<Q1DLOG> Type<LOG> Ver<00001> Rev<00001> Note<Normal promotion>

--- LBYPROC Complete ---

Here are the contents of the pro3.lsc file, which contains the Promote script:

<PROMOTE>

<LIBRARY SRC="LBYDEV" TGT="LBYTEST"/>

<NAME SRC=""/>

<TYPE SRC=""/>

<VERSION SRC=""/>

<REVISION SRC=""/>

<USERID SRC=""/>

<EFFDATE SRC=""/>

<MODE SRC="" TGT="" FINAL=""/>

<STATUS SRC="PASSED" TGT="TEST" FINAL="PROMOTED"/>

<CLASS SRC="" TGT="" FINAL=""/>

<PROJECT SRC="" TGT="" FINAL=""/>

</PROMOTE>

</LBYSCRIPT>

Here are the INI options that relate to the ODBC database handlers and library tables used for this example:

< DBHandler:LBYSETUP >

Class             = ODBC

CreateTable       = Yes

Debug             = No

Description       = Original ODBC handler in SQL Server

Passwd            = pw

Server            = SQLDEV    (ODBC Data Source Name)

UserID            = userid

< DBHandler:LBYTEST >

Class             = ODBC

CreateTable       = Yes

Debug             = No

Description       = ODBC handler for Test database in SQL Server

Passwd            = pw

Server            = SQLTEST   (ODBC Data Source Name)

UserID            = userid

< DBTable:CATALOG >

DBHandler         = LBYSETUP

< DBTable:LBYDEV >

DBHandler         = LBYSETUP

< DBTable:LBYDEVD >

DBHandler         = LBYSETUP

< DBTable:LBYTEST >

DBHandler         = LBYTEST

< DBTable:LBYTESTD >

DBHandler         = LBYTEST

< Library:LBYDEV >

DBTable           = LBYDEVD

Description       = Development library in SQL Server

< Library:LBYTEST >

DBTable           = LBYTESTD

Description       = Test library in SQL Server

< ODBC_FileConvert >

CATALOG           = dbo.DMKR_CATALOG

LBYDEV            = dbo.DMKR_LBYDEV

LBYDEVD           = dbo.DMKR_LBYDEVD

LBYTEST           = dbo.DMKR_LBYTEST

LBYTESTD          = dbo.DMKR_LBYTESTD