Path placeholders

A path placeholder is a variable element that by itself represents an absolute path. A path variable is replaced by an absolute path at a later time than when it is declared.

Delivery Manager has a single path placeholder called $$xsl. This placeholder may only be used in upgrade scripts as the 2nd argument of an INVOKE USXSL.APPLY2FILE statement.

Example

INVOKE USXSL.APPLY2FILE WITH SELECT

'$$unpack\scripts\Addresses.xml'

, '$$xsl'

, '$$unpack\scripts\New_Addresses.xml'

If you use the $$xsl placeholder in this way, you must specify an XSL transformation for the SQL statement in the "Added XSL" field. When the script is released:

•This XSL transformation is released as an .XSL file in the using folder.

•In the released upgrade script, $$xsl is replaced by an absolute path pointing at this .XSL file.

Suppose the example statement is the statement with number 12 in a Pre-upgrade script for application TRAVEL with number 310.

The transformation specified in the "Added XSL" field could be released as a file named:

\\fs\myapp$\Releases\3.0.12\scripts\using\TRAVEL.310.12.xsl

The upgrade script itself could be named:

\\fs\myapp$\Releases\3.0.12\scripts\TRAVEL.310.post.ure.active.sql

In this script, the generated statement with number 12 could look like this:

/* 12 - Addresses */

invoke usxsl.apply2file with select

'c:\usd91\udeliver\scripts\Addresses.xml'

, 'c:\usd91\udeliver\scripts\using\TRAVEL.310.12.xsl'

, 'c:\usd91\udeliver\scripts\New_Addresses.xml'

where rulesengine.getproperty( 'ENV COMPUTERNAME' ) = 'COMPUTER_25'

;

invoke usxsl.apply2file with select

'c:\usoft\deploy\Addresses.xml'

, 'c:\usoft\deliver\using\TRAVEL.310.12.xsl'

, 'c:\usoft\deploy\New_Addresses.xml'

where rulesengine.getproperty( 'ENV COMPUTERNAME' ) = 'COMPUTER_33'

;