Novell Identity Manager 3.6.0
Novel eDiR 8.8 SP3
JDBC driver *(PUBLISHER) only. trigerless *


I wan to achieve this as following:

My JDBC dirver sychronize a Users from *"Table-A"* from the database.
On each publishing event, I read title-column info from *"Table-B"
*based on the user-id i got from the *"Table-A."*

This is done on the _Publisher_Input_trnasformation._

When i query the "Table-B" for that column. I get different rows back.

<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20080710_0850" instance="PERSON"
version="3.5.2">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<jdbc:result-set event-id="0" jdbc:number-of-rows="2">
<jdbc:row jdbc:number="1">
<jdbc:column jdbc:name="ID_USER_Title" jdbcosition="1"
jdbc:type="java.sql.Types.INTEGER">
<jdbc:value>14</jdbc:value>
</jdbc:column>
</jdbc:row>
<jdbc:row jdbc:number="2">
<jdbc:column jdbc:name="ID_USER_Title" jdbcosition="1"
jdbc:type="java.sql.Types.INTEGER">
<jdbc:value>15</jdbc:value>
</jdbc:column>
</jdbc:row>
</jdbc:result-set>
<status event-id="0" level="success"/>
</output>
</nds>



Then i do for-each to read each of these rows.

I ACTUALLY WANT TO SEND THIS INFO FROM PUBLISHER ITP TO THE COMMAND
TRANSFORMATION ON PUBLISHER AS NODESET SO I WAS WONDERING HOW TO PASS
THIS INFO TO THE COMMAND TRANSFORMATION ????



This rules on PUB ITP should work on each type of operations.
Add,modify,delete.


On the Command transformation, I will do "Group membership updates" and
other attribute Updates based on the number of IDs i have in this
NodeSet.

For-each will be I guess.



Regards,
Maqsood.


--
love anything that talks binary!
------------------------------------------------------------------------
belaie's Profile: http://forums.novell.com/member.php?userid=4368
View this thread: http://forums.novell.com/showthread.php?t=383078