Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Horacio - very interesting. My first attempts at using a table as source
for the INSERT failed. But if you got it working, I'll have to give it
another shot.
Hashed table works, you say? Mine was standard, or sorted, I think. It was
an inherited job.
ABAPxxxGoddess, I'll feed back. If we can get EXEC SQL to work with itabs,
it will be very cool for both of us. Watch this space.
| | | ---------------Original Message---------------
From: horacio zapettini
Sent: Monday, October 04, 2010 7:10 AM
Subject: Bulk insert SQL command to transfer data from SAP to Oracle - CL_SQL_CONNECTION
Hi.
Sorry because I was off the office last week. Didn't read any mails ...
native sql -> exec sql
BTW you have to configure an entry in dbcon and have to meet certain requisites mentioned in an oss note before you can successfully run exec sql.
what do I have in mind?
as simple as select field list from saptable into a hashed table.
loop at that hashed table
exec sql
insert your table from :wa_hashed table
endexec.
endloop.
I don't know any other method and this method works fine and fast enough for me...
put it this way: using this method, I've read 20 tables with a million rows in total and saved the all those records into custom tables in sap (i.e. some have a few hundreds, some have more than 500000 rows) and all the time needed is less than a couple of minutes... (really a short time). |
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Related Content Most Popular White Papers
In the Spotlight  _.____.__ |
Mark as helpful
