On 7/28/12 2:56 AM, raktimb wrote:
>
> Hello everyone,
>
> I have a JDBC Driver connected to MS SQL Server. From Subscriber
> Command Transformation, I am sending a SQL Query to MS SQL Server. In
> Input Transformation I am getting the *jdbc:result-set* document. I am
> not able to get those informations from that document to local variable.
> Here is the input:
>
>
> Code:
> --------------------
> <input>
> <jdbc:statement event-id="0" xmlns:exsl="http://exslt.org/common" xmlns:jdbc="urn:dirxml:jdbc">
> <jdbc:sql>SELECT UNIT_NAME FROM T_WF_BU</jdbc:sql>
> </jdbc:statement>
> </input>
> --------------------
>
>
> And this the output in Input Transformation:
>
>
> Code:
> --------------------
> <output>
> <jdbc:result-set event-id="0" jdbc:number-of-rows="27">
> <jdbc:row jdbc:number="1">
> <jdbc:column jdbc:name="UNIT_NAME" jdbcosition="1" jdbc:type="java.sql.Types.VARCHAR">
> <jdbc:value>Supplier Warehouse</jdbc:value>
> </jdbc:column>
> </jdbc:row>
> <jdbc:row jdbc:number="2">
> <jdbc:column jdbc:name="UNIT_NAME" jdbcosition="1" jdbc:type="java.sql.Types.VARCHAR">
> .................................................. ................
> --------------------
>
>
> Tank you verymuch....
>
>


From a stylesheet or from a policy? It would help if you posted what
you have so far so we could just fill in the missing piece.

--
Shon