Skip to Content
author's profile photo Former Member
Former Member

Database to File

Hello All,

My interface requirement ordernumber is comming from file adapter.order1 order2 order3 etc... in database corresponding order1 order2 etc.. information is stored in DB2 database. based on order1 or order2 we are sending corresponding information from database to destination file system. Can anyone suggest me how can i do. What are the steps inveloved in the interface.

Thanks&Regards

Venkat

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jun 17, 2008 at 07:50 PM

    Hi venkat,

    YOu have to write look up UDFs in your scenarios.

    http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/6e62f30cbe9e44977c78dbdc7a6b27/frameset.htm

    Regards,

    ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 03:57 AM

    Hi Venkat,

    u can go with the UDF functoin or with the lookups

    pls do this links on jdbc lookups

    /people/jin.shin/blog/2008/02/15/sap-pi-71-mapping-enhancements-series-graphical-support-for-jdbc-and-rfc-lookups

    /people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

    ********************pls do chk this*********************************

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/20ab7ccf-e78a-2a10-71b4-80fc764bafb0

    http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

    if found worth pls do the req

    Thanx

    Sampath

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 04:44 AM

    Hey,

    go for JDBC lookup.

    1) /people/alessandro.guarneri/blog/2006/03/27/sap-xi-lookup-api-the-killer

    2)/people/sravya.talanki2/blog/2005/12/21/use-this-crazy-piece-for-any-rfc-mapping-lookups

    rewards points if useful.

    regards,

    Milan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.