Dear all,

I have found a sample of an embedded SQL query, and I try to use it in
my JDBC driver on the Subscriber channel. But I receive the following
error: -Code(-9038) Element <jdbc:statement> found under <input> is not
allowed.-

Here is the operation:

-<nds dtdversion="3.5" ndsversion="8.x">
<input>
<jdbc:statement xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:sql>SELECT CDUnitID FROM dbo.CD_LegalEntityData WHERE
CostcenterCode = '113_1' AND LegalCustomerID = '005'</jdbc:sql>
</jdbc:statement>
</input>
</nds>-

I have attached the traces.

Could someone please help me ?

Thank you in advance.

NB: IDM v3.6 - SQL Server 8.0.2050 - Driver JDBC


+----------------------------------------------------------------------+
|Filename: Traces.txt |
|Download: http://forums.novell.com/attachment....achmentid=3439 |
+----------------------------------------------------------------------+

--
marieno
------------------------------------------------------------------------
marieno's Profile: http://forums.novell.com/member.php?userid=18876
View this thread: http://forums.novell.com/showthread.php?t=388259