DB Datatype structure ?

[Former Member]

Hello guys writing to a DB just confused over the structure of the DB DT ? please suggest

Reddy

[MichalKrawczyk · Accepted solution]

hi,

here are the document formats that you can use with the receiver jdbc adapter

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

you cna also have a look at this weblog:

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

to see how it's done

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member · Accepted solution]

Thanks for the blog and the help link : well i am looking to insert multiple records at the same time , the blog as i see only talks about one record set at a time ?

Reddy

[MichalKrawczyk · Accepted solution]

hi,

the access block can have many elements

Regards,

michal

[moorthy · Accepted solution]

Hi Bujji,

just change the occurence of the "Statement "in your JDBC insert to 0 to unbounded and it should work fine.

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

Thanks,

Moorthy

[Former Member · Accepted solution]

Thanks i have the following format now :

Structure ..................Occurence

DT_Name

..Insert1................... 1

.....TableName...............1

.....Action..................required

........Access...............1

..........<Col1>.............1

..

..

........Key1.................1

..

Etc

NOw should i make Insert1 as unbounded or Access as unbounded? and since i am using Async Push to DB No need of BPM

Please also advice on multiple keys case scenario

Reddy

Message was edited by: Bujji Reddy

[moorthy · Accepted solution]

Hi,

No need of BPM in this case..Check this thread-

Thanks,

Moorthy

[Former Member · Accepted solution]

thanks , points awarded for your helpful answer.

i.e. now insert1 should be unbounded ?

thanks

Reddy

[MichalKrawczyk · Accepted solution]

hi,

why not listen to my replay?

use the access with unbounded - that's all

(like in my first replay to your thread)

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>