jdbc structure

[Former Member]

Hi

we use a structure in sender comm channel only ie

< mesage name>

<statement name>

<db tablename action= >

<table realtable name>

<access>

col1--

</access>

while we dont use it in recieverside,what is the the reason for it.

[nisarkhan_n · Accepted solution]

We also use in the JDBC Receiver : the strucutre looks some thign like this

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_JDBCRecords xmlns:ns0="https:
camxi_FiletoJDBC"><STATEMENTNAME><Test action="INSERT">

<TABLE>SAP_MATERIAL</TABLE>

<access>

<MATNO>13</MATNO>

<MATYPE>13</MATYPE>

</access>

</Test></STATEMENTNAME></ns0:MT_JDBCRecords>

without this strucutre you cannot insert into DATABSE..check some blogs for more details

<STATAEMENTNAME>

<TEST action "INSERT"> (attribute)

and so on....

[Former Member]

Hi Raghu,

The structure which u mentioned is for Receiver ....

In Receiver JDBC adapter we dont have the provision to mention the things like create or insert...Table name

In sender adapter we have that facility to use

This structures are ment like that

JDBC Receiver

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards

Seshagiri

[nisarkhan_n]

Seshagiri

"In Receiver JDBC adapter we dont have the provision to mention the things like create or insert...Table name"

we do have the provision we need to pass these information as constant "action INSERT" and also table name"TableName" .

without mentioning these details D/B will not get updated.

[justin_santhanam]

Nisar,

It's not mandatory to have INSERT/UPDATE constants. I can also have SQL_DML isn't it?

raj.

[Former Member]

Hi Khan,

What iam saying is these details like mentioning the Table name and the Action-=INSERT are not available in Sender JDBC Adapter while creating the CC

Thats all abt my reply

Regards

Seshagiri

[rodrigoalejandro_pertierr]

follow this link to solve your issue

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm