Skip to Content

Insert Bulk record in Powerbuilder

My flat file contain 75000 records. I need to insert all file records into database through Powerbuilder.

Using importfile function imported records into datawindow. once I used dw.update() its take 3-4 Hrs.

Please let me how to insert to record in minimum time ?

Add comment
10|10000 characters needed characters exceeded

  • Thank you for visiting SAP Community to get answers to your questions. I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. For example, you can outline what steps you took to find answers (and why they weren't helpful), share screenshots of what you've seen and done, and so on. The more details you provide, the more likely it is that members will be able to assist you.

    Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question).

    --Jerry

1 Answer

  • Posted on Jan 15 at 09:12 PM

    The DataWindow performs operations row by row so it is not an efficient way to bulk load data. You really want to try to push that work to the database which will likely have bulk loading capabilities. For example, the SQL Anywhere LOAD TABLE is designed for bulk loading of data. There will be similar capabilities in most databases.

    Add comment
    10|10000 characters needed characters exceeded