Popular Posts

Saturday, September 7, 2013

Pass dynamic file URL in document in XSLT

XSLT - How to pass dynamic file URL in document.

<xsl:for-each select="document($fileUrl)/SXXXXX/*/Field">

1) Use Parameter name instead of variable will resolve the issue

2) Pass Absolute path to a variable
    <xsl:variable name="fileLocation" select="'C:/XXX/'"/>

3) Pass Relative Path to a variable
     <xsl:variable name="fileUrl">../staging/<xsl:value-of  select="$producttype"/>.xml</xsl:variable>

Concatenate query values with comma separated with quote IN SQL usage in Tibco SQL Direct

Concatenate query values with comma and quote Separated in Tibco SQL Direct is  passed as IN parameter

concat("'",tib:concat-sequence-format($Start/pfx:GetOrdersByXXXXRequest/pfx:OrderXXX,"','"),"'")