How to pass the table name in receiver jdbc adapter

[Former Member]

Hi All,

Can any one suggest me to pass table through receiver communication channel.I am trying to give table in receiver channel instead of giving table name in receiver jdbc data type structure( generally we follow standard document format for receiver jdbc adapter).We have one parameter in receiver jdbc adapter to pass the table name,using that i am trying to pass table name.If I pass table in receiver comm channel then how can I construct data type stucture for receiver jdbc adapter.

Regards

Pullarao

[VijayKonam]

Use XML SQL strucuture. You can map the table name to this strucuture at run time.

Check the receiver jdbc adapter help at help.sap.com.

VJ

[former_member184619]

hi Pullarao,

I am not sure that can pass the table name in receiver JDBC adapter...

But you can check this parameter "databse" ( not sure on how to use) under Processing tab

check this for more:

http://help.sap.com/saphelp_nw70/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

But the structure for receiver JDBC data type must have a fixed schema i.e. we have to pass the table name in that otherwise it will trough an error

check this:

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Sachin

Edited by: Sachin Dhingra on Jan 10, 2008 4:47 PM