on 03-22-2012 10:17 AM
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
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks all,Its working now
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
have the structure as in the link suggested by simone.
in table field have the value with complete tablename including database name with . separator
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
First check in Data base Table exissts or not, enter correct table name for Table field in Target side.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.