cancel
Showing results for 
Search instead for 
Did you mean: 

jdbc receiver structure

sahana_ps
Participant
0 Kudos

hi all,

My jdbc receiver structure looks like this

mt_name

   Statement  

      MOC  

         action (UPDATE)

         access

            CER_NO

         KEY

             MOC_NO

i am getting error like table/view does not exist ,when trying to update this table....I faced same problem while reading from this table

but when i added schema name in front of table name(PSMRT.MOC) in sql query it worked fine...

but now unable to write into this table

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The receiver structure need to look like this:

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

You need to have a "TableName" field, like following:

  <StatementName1>

<dbTableName action=”UPDATE”>

    <table>Package.realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

  </StatementName1>

Answers (5)

Answers (5)

sahana_ps
Participant
0 Kudos

thanks all,Its working now

Former Member
0 Kudos

mt_name

   Statement  

      MOC  

         action (UPDATE)

         access

            CER_NO

         KEY

             MOC_NO

first

u need to check database table name exists otr not and check below screen of Receiver jdbc Structure:

Former Member
0 Kudos

have the structure as in the link suggested by simone.

in table field have the value with complete tablename including database name with . separator

iaki_vila
Active Contributor
0 Kudos

I suppose that you have test the right permissions of your user to write in that table. Have you tried with the statement

action= UPDATE_INSERT

May be the where condition doesn't get in any register.

Regards.


rajasekhar_reddy14
Active Contributor
0 Kudos

First check in Data base Table exissts or not, enter correct table name for Table field in Target side.