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....


--
raktimb
------------------------------------------------------------------------
raktimb's Profile: http://forums.novell.com/member.php?userid=129794
View this thread: http://forums.novell.com/showthread.php?t=458341