JDBC RECEIVER update elment value to NULL

[Former Member]

Hello guys,

I am using JDBC Receiver Document Format for execute UPDATE parameter in my table from MS SQL SERVER 2008 database.

Samebody know how can i update the element value to NULL value?

Example:

<StatementName>

<dbTableName action="UPDATE_INSERT">

<table>tb_Material</table>

<access>

<cdDoc>1</cdDoc>

<cdMaterial>32395</cdMaterial>

<nmMaterial>KIT LOUNGE MUSIC CD'S C/09. - x salada</nmMaterial>

<idSituacao>1</idSituacao>

<DtAtualizacao></DtAtualizacao> I need set this element with NULL value.

</access>

<key>

<cdMaterial>32395</cdMaterial>

</key>

</dbTableName>

</StatementName>

Can anybody help me, please?

Thanks.

[stefan_grube · Accepted solution]

In the receiver channel you can decide whether an empty element will be interpreted as null or empty string in database.

[VijayKonam]

Did you try removing the element from the receiver data type? Just a thought.

VJ