declare variable $xPRSXMLInput as document-node(element(*, xs:untyped)) external;
declare variable $convPath as xs:string external;
declare variable $POLCUST := $xPRSXMLInput/root/POLCUST/text();
declare variable $POLCUST2 := $xPRSXMLInput/root/POLCUST2/text();
declare variable $DLSCSTR := $xPRSXMLInput/root/DLSCSTR/text();
declare variable $DLSFIP1 := $xPRSXMLInput/root/DLSFIP1/text();
declare variable $DLSADTY := $xPRSXMLInput/root/DLSADTY/text();

<dataroot>
  {
    for $PCustRow in doc(concat("converter:file:///", $convPath, "/POLCUST_MAIN.conv?file:///", $POLCUST))/root/row
    for $PCust2Row in doc(concat("converter:file:///", $convPath, "/POLCUST2.conv?file:///", $POLCUST2))/root/row
    where $PCustRow/DPT_KEY_POL_ID/text() = $PCust2Row/DPT_KEY_POL_ID/text()
    return
      <POLCUST>
        <KEY_CLERK_DIST_ACCT>
          { concat($PCustRow/DPT_KEY_CLERK_DIST, $PCustRow/DPT_KEY_ACCT) }
        </KEY_CLERK_DIST_ACCT>
        <KEY_POL_ID>
          { $PCustRow/DPT_KEY_POL_ID/text() }
        </KEY_POL_ID>
        <POL_NUM>
          { $PCustRow/DPT_POL_NUM/text() }
        </POL_NUM>
        <PRODUCT>
          { $PCustRow/PRODUCT/text() }
        </PRODUCT>
        <JURIS>
          { $PCustRow/JURIS/text() }
        </JURIS>

...snip 403 fields...

        <OIR_CURR_INDEX_10YR>
          { $PCustRow/DPT_OIR_CURR_INDEX_10YR/text() }
        </OIR_CURR_INDEX_10YR>
        <OIR_CURR_INDEX_20YR>
          { $PCustRow/DPT_OIR_CURR_INDEX_20YR/text() }
        </OIR_CURR_INDEX_20YR>
        <OIR_GUAR_INDEX_10YR>
          { $PCustRow/DPT_OIR_GUAR_INDEX_10YR/text() }
        </OIR_GUAR_INDEX_10YR>
        <OIR_GUAR_INDEX_20YR>
          { $PCustRow/DPT_OIR_GUAR_INDEX_20YR/text() }
        </OIR_GUAR_INDEX_20YR>
        <ADBR_LOAN_INT_TEXT>
          { $PCust2Row/DPT_ADBR_LOAN_INT_TEXT/text() }
        </ADBR_LOAN_INT_TEXT>
        <COPHONE>
          { $PCust2Row/DPT_COPHONE/text() }
        </COPHONE>
        <AGENT_PHONE>
          { $PCust2Row/DPT_AGENT_PHONE/text() }
        </AGENT_PHONE>

...snip 48 fields...

        <MIN_ST_AMT>
          { $PCust2Row/DPT_MIN_ST_AMT/text() }
        </MIN_ST_AMT>
	<ADDTL_EXCHANGE_TEXT>
          { $PCust2Row/DPT_ADDTL_EXCHANGE_TEXT/text() }
        </ADDTL_EXCHANGE_TEXT>
	<OIR_EXCHANGE_TEXT>
          { $PCust2Row/DPT_OIR_EXCHANGE_TEXT/text() }
        </OIR_EXCHANGE_TEXT>
        {
          for $FIP1Row in doc(concat("converter:file:///", $convPath, "/DLSFIP1.conv?file:///", $DLSFIP1))/root/row
          (:		 for $FIP1Row in doc('converter:file:///c:/Working/Stylus_Studio/Com/xQuery/Conv/DLSFIP1.conv?file:///c:/ESP/Data/Com/polprint/WSD04/DLSFIP1.TXT')/root/row  :)
          where $PCustRow/DPT_KEY_POL_ID/text() = concat($FIP1Row/FIP1_COMPANY_CODE, $FIP1Row/FIP1_POL_NO, $FIP1Row/FIP1_SEC_CODE)
          return
            <DLSFIP1>
              <FIP1_POL_ID>
                { concat($FIP1Row/FIP1_COMPANY_CODE, $FIP1Row/FIP1_POL_NO, $FIP1Row/FIP1_SEC_CODE) }
              </FIP1_POL_ID>
              <FIP1_SEQ_NO>
                { $FIP1Row/FIP1_SEQ_NO/text() }
              </FIP1_SEQ_NO>
              <FIP1_PG_NO>
                { $FIP1Row/FIP1_PG_NO/text() }
              </FIP1_PG_NO>
              <FIP1_TOT_PGS>
                { $FIP1Row/FIP1_TOT_PGS/text() }
              </FIP1_TOT_PGS>
              <FILLER/>
              <FIP1_PAGE_TEXT>
                { $FIP1Row/FIP1_PAGE_TEXT/text() }
              </FIP1_PAGE_TEXT>
            </DLSFIP1>
        }
        {
          for $CSTRRow in doc(concat("converter:file:///", $convPath, "/DLSCSTR.conv?file:///", $DLSCSTR))/root/row
          (:		 for $CSTRRow in doc('converter:file:///c:/Working/Stylus_Studio/Com/xQuery/Conv/DLSCSTR.conv?file:///c:/ESP/Data/Com/polprint/WSD04/DLSCSTR.TXT')/root/row  :)
          where $PCustRow/DPT_POL_NUM/text() = $CSTRRow/CSTR_POLICY_NUMBER/text()
          return
            <DLSCSTR>
              <CSTR_POLICY_NUMBER>
                { $CSTRRow/CSTR_POLICY_NUMBER/text() }
              </CSTR_POLICY_NUMBER>
              <CSTR_SEQ_NUM>
                { $CSTRRow/CSTR_SEQ_NUM/text() }
              </CSTR_SEQ_NUM>
              <CSTR_RIDER_NUMBER>
                { $CSTRRow/CSTR_RIDER_NUMBER/text() }
              </CSTR_RIDER_NUMBER>
              <CSTR_RIDER_TEXT_1>
                { $CSTRRow/CSTR_RIDER_TEXT/text() }
              </CSTR_RIDER_TEXT_1>
              <CSTR_FILLER>
                { $CSTRRow/CSTR_FILLER/text() }
              </CSTR_FILLER>
            </DLSCSTR>
        }
        {
          for $ADTYRow in doc(concat("converter:file:///", $convPath, "/DLSADTY.conv?file:///", $DLSADTY))/root/row
          (:		for $ADTYRow in doc('converter:file:///c:/Working/Stylus_Studio/Com/xQuery/Conv/DLSADTY.conv?file:///c:/ESP/Data/Com/polprint/WSD04/DLSADTY.TXT')/root/row  :)
          where $PCustRow/DPT_POL_NUM/text() = $ADTYRow/ADTY_POLICY_NUMBER/text()
          return
            <DLSADTY>
              <ADTY_POLICY_NUMBER>
                { $ADTYRow/ADTY_POLICY_NUMBER/text() }
              </ADTY_POLICY_NUMBER>
              <ADTY_SEQ_NUM>
                { $ADTYRow/ADTY_SEQ_NUM/text() }
              </ADTY_SEQ_NUM>
              <ADTY_TABLE_TYPE>
                { $ADTYRow/ADTY_TABLE_TYPE/text() }
              </ADTY_TABLE_TYPE>
              <ADTY_CODE>
                { $ADTYRow/ADTY_CODE/text() }
              </ADTY_CODE>
            </DLSADTY>
        }
      </POLCUST>
  }
</dataroot>
(: Stylus Studio meta-information - (c) 2004-2009. Progress Software Corporation. All rights reserved.

<metaInformation>
	<scenarios>
		<scenario default="yes" name="Scenario1" userelativepaths="no" externalpreview="no" useresolver="yes" url="" outputurl="" processortype="datadirect" tcpport="3145776" profilemode="0" profiledepth="" profilelength=""
		          urlprofilexml="file:///c:/Documents and Settings/lfaig/Desktop/XML/test.xml" commandline="" additionalpath="" additionalclasspath="" postprocessortype="none" postprocesscommandline="" postprocessadditionalpath=""
		          postprocessgeneratedext="" host="" port="0" user="" password="" validateoutput="no" validator="internal" customvalidator="">
			<parameterValue name="xPRSXMLInput" value="doc('file:///C:/Working/Stylus_Studio/WESTERN_SOUTHERN_xPRSXMLInput.xml')"/>
			<parameterValue name="convPath" value="C:/Working/Stylus_Studio/xQuery/Dev/Conv"/>
		</scenario>
	</scenarios>
	<MapperMetaTag>
		<MapperInfo srcSchemaPathIsRelative="yes" srcSchemaInterpretAsXML="no" destSchemaPath="..\WS.xml" destSchemaRoot="dataroot" destSchemaPathIsRelative="yes" destSchemaInterpretAsXML="no">
			<SourceSchema srcSchemaPath="converter:./Conv\POLCUST.conv?..\..\ESP\Data\Com\polprint\WSD04\POLCUST.TXT" srcSchemaRoot="root"
			              AssociatedInstance="converter:file:///c:/Working/Stylus_Studio/Com/xQuery/Conv/POLCUST.conv?file:///c:/ESP/Data/Com/polprint/WSD04/POLCUST.TXT" loaderFunction="document" loaderFunctionUsesURI="no"/>
			<SourceSchema srcSchemaPath="converter:./Conv\DLSFIP1.conv?..\..\ESP\Data\Com\polprint\WSD04\DLSFIP1.TXT" srcSchemaRoot="root"
			              AssociatedInstance="converter:file:///c:/Working/Stylus_Studio/Com/xQuery/Conv/DLSFIP1.conv?file:///c:/ESP/Data/Com/polprint/WSD04/DLSFIP1.TXT" loaderFunction="document" loaderFunctionUsesURI="no"/>
			<SourceSchema srcSchemaPath="converter:./Conv\DLSCSTR.conv?..\..\ESP\Data\Com\polprint\WSD04\DLSCSTR.TXT" srcSchemaRoot="root"
			              AssociatedInstance="converter:file:///c:/Working/Stylus_Studio/Com/xQuery/Conv/DLSCSTR.conv?file:///c:/ESP/Data/Com/polprint/WSD04/DLSCSTR.TXT" loaderFunction="document" loaderFunctionUsesURI="no"/>
			<SourceSchema srcSchemaPath="converter:./Conv\DLSADTY.conv?..\..\ESP\Data\Com\polprint\WSD04\DLSADTY.TXT" srcSchemaRoot="root"
			              AssociatedInstance="converter:file:///c:/Working/Stylus_Studio/Com/xQuery/Conv/DLSADTY.conv?file:///c:/ESP/Data/Com/polprint/WSD04/DLSADTY.TXT" loaderFunction="document" loaderFunctionUsesURI="no"/>
			<SourceSchema srcSchemaPath="..\WESTERN_SOUTHERN_xPRSXMLInput.xml" srcSchemaRoot="root" AssociatedInstance="$xPRSXMLInput" loaderFunction="document" loaderFunctionUsesURI="no"/>
		</MapperInfo>
		<MapperBlockPosition>
			<template name="xquery_body">
				<block path="dataroot/flwr" x="140" y="36"/>
				<block path="dataroot/flwr/POLCUST/KEY_CLERK_DIST_ACCT/concat" x="180" y="54"/>
				<block path="dataroot/flwr/POLCUST/CLIENT_ACCOUNT/concat" x="140" y="175"/>
				<block path="dataroot/flwr/POLCUST/LOAN_INT_PERCENT/concat" x="180" y="175"/>
				<block path="dataroot/flwr/POLCUST/EXP_CHARGE_PERCENT/concat" x="100" y="175"/>
				<block path="dataroot/flwr/POLCUST/BENE_LINE_01/substring" x="60" y="175"/>
				<block path="dataroot/flwr/POLCUST/BENE_LINE_01A/substring" x="20" y="175"/>
				<block path="dataroot/flwr/POLCUST/BENE_LINE_02/substring" x="140" y="135"/>
				<block path="dataroot/flwr/POLCUST/BENE_LINE_02A/substring" x="180" y="135"/>
				<block path="dataroot/flwr/POLCUST/BENE_LINE_03/substring" x="100" y="135"/>
				<block path="dataroot/flwr/POLCUST/BENE_LINE_03A/substring" x="60" y="135"/>
				<block path="dataroot/flwr/POLCUST/BENE_LINE_04/substring" x="20" y="135"/>
				<block path="dataroot/flwr/POLCUST/BENE_LINE_04A/substring" x="140" y="95"/>
				<block path="dataroot/flwr/POLCUST/MAIL_CODE/concat" x="180" y="95"/>
				<block path="dataroot/flwr/POLCUST/flwr" x="100" y="95"/>
				<block path="dataroot/flwr/POLCUST/flwr/=[1]" x="54" y="117"/>
				<block path="dataroot/flwr/POLCUST/flwr/DLSDCDE/flwr" x="180" y="255"/>
				<block path="dataroot/flwr/POLCUST/flwr/DLSDCDE/flwr/=[1]" x="134" y="277"/>
				<block path="dataroot/flwr/POLCUST/flwr[1]" x="60" y="95"/>
				<block path="dataroot/flwr/POLCUST/flwr[1]/=[1]" x="14" y="117"/>
				<block path="dataroot/flwr/POLCUST/flwr[2]" x="20" y="95"/>
				<block path="dataroot/flwr/POLCUST/flwr[2]/=[1]" x="0" y="117"/>
				<block path="dataroot/flwr/POLCUST/flwr[2]/=[1]/concat[1]" x="0" y="139"/>
				<block path="dataroot/flwr/POLCUST/flwr[2]/DLSFIP1/FIP1_POL_ID/concat" x="100" y="255"/>
				<block path="dataroot/flwr/POLCUST/flwr[3]" x="100" y="55"/>
				<block path="dataroot/flwr/POLCUST/flwr[3]/=[1]" x="54" y="77"/>
				<block path="dataroot/flwr/POLCUST/flwr[3]/=[1]/concat[1]" x="8" y="99"/>
				<block path="dataroot/flwr/POLCUST/flwr[3]/DLSFIP2/FIP2_POL_ID/concat" x="60" y="255"/>
				<block path="dataroot/flwr/POLCUST/flwr[4]" x="60" y="55"/>
				<block path="dataroot/flwr/POLCUST/flwr[4]/=[1]" x="14" y="77"/>
				<block path="dataroot/flwr/POLCUST/flwr[5]" x="20" y="55"/>
				<block path="dataroot/flwr/POLCUST/flwr[5]/=[1]" x="0" y="77"/>
				<block path="dataroot/flwr/POLCUST/flwr[6]" x="100" y="15"/>
				<block path="dataroot/flwr/POLCUST/flwr[6]/=[1]" x="54" y="37"/>
				<block path="dataroot/flwr/POLCUST/flwr[7]" x="60" y="15"/>
				<block path="dataroot/flwr/POLCUST/flwr[7]/=[1]" x="14" y="37"/>
				<block path="dataroot/flwr/POLCUST/flwr[8]" x="20" y="15"/>
				<block path="dataroot/flwr/POLCUST/flwr[8]/=[1]" x="0" y="37"/>
				<block path="dataroot/flwr/POLCUST/flwr[9]" x="140" y="215"/>
				<block path="dataroot/flwr/POLCUST/flwr[9]/=[1]" x="94" y="237"/>
				<block path="dataroot/flwr/POLCUST/flwr[10]" x="180" y="215"/>
				<block path="dataroot/flwr/POLCUST/flwr[10]/=[1]" x="134" y="237"/>
				<block path="dataroot/flwr/POLCUST/flwr[11]" x="100" y="215"/>
				<block path="dataroot/flwr/POLCUST/flwr[11]/=[1]" x="54" y="237"/>
				<block path="dataroot/flwr/POLCUST/flwr[12]" x="60" y="215"/>
				<block path="dataroot/flwr/POLCUST/flwr[12]/=[1]" x="14" y="237"/>
				<block path="dataroot/flwr/POLCUST/flwr[13]" x="20" y="215"/>
				<block path="dataroot/flwr/POLCUST/flwr[13]/=[1]" x="0" y="237"/>
				<block path="dataroot/flwr/POLCUST/flwr[14]" x="140" y="255"/>
				<block path="dataroot/flwr/POLCUST/flwr[14]/=[1]" x="94" y="277"/>
			</template>
		</MapperBlockPosition>
		<TemplateContext></TemplateContext>
		<MapperFilter side="source"></MapperFilter>
	</MapperMetaTag>
</metaInformation>
:)