Edit D:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\xml\xsl\kumodusr.xsl
<?xml version="1.0"?> <!-- NAME kumodusr.xsl DESCRIPTION XSLT stylesheet for MODIFY of USER_T and DEFROLE_T objects NOTES Do NOT modify this file under any circumstance. Copy the file if you wish to use this stylesheet with an external XML/XSL parser MODIFIED MM/DD/YY lbarton 11/02/05 - Bug 4715313: reformat files for use with XMLSpy lbarton 07/10/02 - lbarton_mdapi_modify_transform lbarton 06/10/02 - Created --> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:import href="kumodcom.xsl"/> <xsl:import href="kumodts.xsl"/> <xsl:param name="OBJECT_ROW1">0</xsl:param> <xsl:param name="OBJECT_ROW2">0</xsl:param> <xsl:param name="OBJECT_ROW3">0</xsl:param> <xsl:param name="OBJECT_ROW4">0</xsl:param> <xsl:param name="OBJECT_ROW5">0</xsl:param> <xsl:param name="OBJECT_ROW6">0</xsl:param> <xsl:param name="OBJECT_ROW7">0</xsl:param> <xsl:param name="OBJECT_ROW8">0</xsl:param> <xsl:param name="OBJECT_ROW9">0</xsl:param> <xsl:param name="OBJECT_ROW10">0</xsl:param> <xsl:param name="REMAP_SCHEMAO1" select="''"/> <xsl:param name="REMAP_SCHEMAN1" select="''"/> <xsl:param name="REMAP_SCHEMAO2" select="''"/> <xsl:param name="REMAP_SCHEMAN2" select="''"/> <xsl:param name="REMAP_SCHEMAO3" select="''"/> <xsl:param name="REMAP_SCHEMAN3" select="''"/> <xsl:param name="REMAP_SCHEMAO4" select="''"/> <xsl:param name="REMAP_SCHEMAN4" select="''"/> <xsl:param name="REMAP_SCHEMAO5" select="''"/> <xsl:param name="REMAP_SCHEMAN5" select="''"/> <xsl:param name="REMAP_SCHEMAO6" select="''"/> <xsl:param name="REMAP_SCHEMAN6" select="''"/> <xsl:param name="REMAP_SCHEMAO7" select="''"/> <xsl:param name="REMAP_SCHEMAN7" select="''"/> <xsl:param name="REMAP_SCHEMAO8" select="''"/> <xsl:param name="REMAP_SCHEMAN8" select="''"/> <xsl:param name="REMAP_SCHEMAO9" select="''"/> <xsl:param name="REMAP_SCHEMAN9" select="''"/> <xsl:param name="REMAP_SCHEMAO10" select="''"/> <xsl:param name="REMAP_SCHEMAN10" select="''"/> <xsl:param name="REMAP_TABLESPACEO1" select="''"/> <xsl:param name="REMAP_TABLESPACEN1" select="''"/> <xsl:param name="REMAP_TABLESPACEO2" select="''"/> <xsl:param name="REMAP_TABLESPACEN2" select="''"/> <xsl:param name="REMAP_TABLESPACEO3" select="''"/> <xsl:param name="REMAP_TABLESPACEN3" select="''"/> <xsl:param name="REMAP_TABLESPACEO4" select="''"/> <xsl:param name="REMAP_TABLESPACEN4" select="''"/> <xsl:param name="REMAP_TABLESPACEO5" select="''"/> <xsl:param name="REMAP_TABLESPACEN5" select="''"/> <xsl:param name="REMAP_TABLESPACEO6" select="''"/> <xsl:param name="REMAP_TABLESPACEN6" select="''"/> <xsl:param name="REMAP_TABLESPACEO7" select="''"/> <xsl:param name="REMAP_TABLESPACEN7" select="''"/> <xsl:param name="REMAP_TABLESPACEO8" select="''"/> <xsl:param name="REMAP_TABLESPACEN8" select="''"/> <xsl:param name="REMAP_TABLESPACEO9" select="''"/> <xsl:param name="REMAP_TABLESPACEN9" select="''"/> <xsl:param name="REMAP_TABLESPACEO10" select="''"/> <xsl:param name="REMAP_TABLESPACEN10" select="''"/> <xsl:template match="USER_T/NAME | PSW_HIST_T/NAME"> <xsl:choose> <xsl:when test=".=$REMAP_SCHEMAO1"> <NAME> <xsl:value-of select="$REMAP_SCHEMAN1"/> </NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO2"> <NAME> <xsl:value-of select="$REMAP_SCHEMAN2"/> </NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO3"> <NAME> <xsl:value-of select="$REMAP_SCHEMAN3"/> </NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO4"> <NAME> <xsl:value-of select="$REMAP_SCHEMAN4"/> </NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO5"> <NAME> <xsl:value-of select="$REMAP_SCHEMAN5"/> </NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO6"> <NAME> <xsl:value-of select="$REMAP_SCHEMAN6"/> </NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO7"> <NAME> <xsl:value-of select="$REMAP_SCHEMAN7"/> </NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO8"> <NAME> <xsl:value-of select="$REMAP_SCHEMAN8"/> </NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO9"> <NAME> <xsl:value-of select="$REMAP_SCHEMAN9"/> </NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO10"> <NAME> <xsl:value-of select="$REMAP_SCHEMAN10"/> </NAME> </xsl:when> <xsl:otherwise> <xsl:copy> <xsl:apply-templates select="@*|node()"/> </xsl:copy> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="DEFROLE_T/USER_NAME | TSQUOTA_T/USER_NAME | AUDIT_T/USER_NAME"> <xsl:choose> <xsl:when test=".=$REMAP_SCHEMAO1"> <USER_NAME> <xsl:value-of select="$REMAP_SCHEMAN1"/> </USER_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO2"> <USER_NAME> <xsl:value-of select="$REMAP_SCHEMAN2"/> </USER_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO3"> <USER_NAME> <xsl:value-of select="$REMAP_SCHEMAN3"/> </USER_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO4"> <USER_NAME> <xsl:value-of select="$REMAP_SCHEMAN4"/> </USER_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO5"> <USER_NAME> <xsl:value-of select="$REMAP_SCHEMAN5"/> </USER_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO6"> <USER_NAME> <xsl:value-of select="$REMAP_SCHEMAN6"/> </USER_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO7"> <USER_NAME> <xsl:value-of select="$REMAP_SCHEMAN7"/> </USER_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO8"> <USER_NAME> <xsl:value-of select="$REMAP_SCHEMAN8"/> </USER_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO9"> <USER_NAME> <xsl:value-of select="$REMAP_SCHEMAN9"/> </USER_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO10"> <USER_NAME> <xsl:value-of select="$REMAP_SCHEMAN10"/> </USER_NAME> </xsl:when> <xsl:otherwise> <xsl:copy> <xsl:apply-templates select="@*|node()"/> </xsl:copy> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="POWNER"> <xsl:choose> <xsl:when test=".=$REMAP_SCHEMAO1"> <POWNER> <xsl:value-of select="$REMAP_SCHEMAN1"/> </POWNER> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO2"> <POWNER> <xsl:value-of select="$REMAP_SCHEMAN2"/> </POWNER> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO3"> <POWNER> <xsl:value-of select="$REMAP_SCHEMAN3"/> </POWNER> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO4"> <POWNER> <xsl:value-of select="$REMAP_SCHEMAN4"/> </POWNER> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO5"> <POWNER> <xsl:value-of select="$REMAP_SCHEMAN5"/> </POWNER> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO6"> <POWNER> <xsl:value-of select="$REMAP_SCHEMAN6"/> </POWNER> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO7"> <POWNER> <xsl:value-of select="$REMAP_SCHEMAN7"/> </POWNER> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO8"> <POWNER> <xsl:value-of select="$REMAP_SCHEMAN8"/> </POWNER> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO9"> <POWNER> <xsl:value-of select="$REMAP_SCHEMAN9"/> </POWNER> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO10"> <POWNER> <xsl:value-of select="$REMAP_SCHEMAN10"/> </POWNER> </xsl:when> <xsl:otherwise> <xsl:copy> <xsl:apply-templates select="@*|node()"/> </xsl:copy> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="UNAME"> <xsl:choose> <xsl:when test=".=$REMAP_SCHEMAO1"> <UNAME> <xsl:value-of select="$REMAP_SCHEMAN1"/> </UNAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO2"> <UNAME> <xsl:value-of select="$REMAP_SCHEMAN2"/> </UNAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO3"> <UNAME> <xsl:value-of select="$REMAP_SCHEMAN3"/> </UNAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO4"> <UNAME> <xsl:value-of select="$REMAP_SCHEMAN4"/> </UNAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO5"> <UNAME> <xsl:value-of select="$REMAP_SCHEMAN5"/> </UNAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO6"> <UNAME> <xsl:value-of select="$REMAP_SCHEMAN6"/> </UNAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO7"> <UNAME> <xsl:value-of select="$REMAP_SCHEMAN7"/> </UNAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO8"> <UNAME> <xsl:value-of select="$REMAP_SCHEMAN8"/> </UNAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO9"> <UNAME> <xsl:value-of select="$REMAP_SCHEMAN9"/> </UNAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO10"> <UNAME> <xsl:value-of select="$REMAP_SCHEMAN10"/> </UNAME> </xsl:when> <xsl:otherwise> <xsl:copy> <xsl:apply-templates select="@*|node()"/> </xsl:copy> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="PROXY_T/CLIENT_NAME"> <xsl:choose> <xsl:when test=".=$REMAP_SCHEMAO1"> <CLIENT_NAME> <xsl:value-of select="$REMAP_SCHEMAN1"/> </CLIENT_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO2"> <CLIENT_NAME> <xsl:value-of select="$REMAP_SCHEMAN2"/> </CLIENT_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO3"> <CLIENT_NAME> <xsl:value-of select="$REMAP_SCHEMAN3"/> </CLIENT_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO4"> <CLIENT_NAME> <xsl:value-of select="$REMAP_SCHEMAN4"/> </CLIENT_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO5"> <CLIENT_NAME> <xsl:value-of select="$REMAP_SCHEMAN5"/> </CLIENT_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO6"> <CLIENT_NAME> <xsl:value-of select="$REMAP_SCHEMAN6"/> </CLIENT_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO7"> <CLIENT_NAME> <xsl:value-of select="$REMAP_SCHEMAN7"/> </CLIENT_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO8"> <CLIENT_NAME> <xsl:value-of select="$REMAP_SCHEMAN8"/> </CLIENT_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO9"> <CLIENT_NAME> <xsl:value-of select="$REMAP_SCHEMAN9"/> </CLIENT_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO10"> <CLIENT_NAME> <xsl:value-of select="$REMAP_SCHEMAN10"/> </CLIENT_NAME> </xsl:when> <xsl:otherwise> <xsl:copy> <xsl:apply-templates select="@*|node()"/> </xsl:copy> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template match="PROXY_T/PROXY_NAME"> <xsl:choose> <xsl:when test=".=$REMAP_SCHEMAO1"> <PROXY_NAME> <xsl:value-of select="$REMAP_SCHEMAN1"/> </PROXY_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO2"> <PROXY_NAME> <xsl:value-of select="$REMAP_SCHEMAN2"/> </PROXY_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO3"> <PROXY_NAME> <xsl:value-of select="$REMAP_SCHEMAN3"/> </PROXY_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO4"> <PROXY_NAME> <xsl:value-of select="$REMAP_SCHEMAN4"/> </PROXY_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO5"> <PROXY_NAME> <xsl:value-of select="$REMAP_SCHEMAN5"/> </PROXY_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO6"> <PROXY_NAME> <xsl:value-of select="$REMAP_SCHEMAN6"/> </PROXY_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO7"> <PROXY_NAME> <xsl:value-of select="$REMAP_SCHEMAN7"/> </PROXY_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO8"> <PROXY_NAME> <xsl:value-of select="$REMAP_SCHEMAN8"/> </PROXY_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO9"> <PROXY_NAME> <xsl:value-of select="$REMAP_SCHEMAN9"/> </PROXY_NAME> </xsl:when> <xsl:when test=".=$REMAP_SCHEMAO10"> <PROXY_NAME> <xsl:value-of select="$REMAP_SCHEMAN10"/> </PROXY_NAME> </xsl:when> <xsl:otherwise> <xsl:copy> <xsl:apply-templates select="@*|node()"/> </xsl:copy> </xsl:otherwise> </xsl:choose> </xsl:template> </xsl:stylesheet>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de