Copy data between two tables using cursor

former_member297013 — Fri, 18 Nov 2016 10:54:18 GMT

Hello,

I have two tables in SAP (DB2 database). Table 1 contains 100 fields. Table 2 contains all the fields from Table 1 except 10 fields.

I need to do a straight copy from Table 1 to Table 2 for corresponding fields. I need to copy around 1 billion records. What is the best way to do so. I don't need to read the data in ABAP layer.

Thanks in advance

Re: Copy data between two tables using cursor

RaymondGiuseppi — Fri, 18 Nov 2016 13:02:44 GMT

You should post also in a DB2 forum, for native SQL statements like

  INSERT INTO YOURLIB.TARGET
     (FIELD1, FIELD2, FIELD3, ... FIELD90)
  SELECT FIELD1, FIELD2, FIELD3, ... FIELD90
    FROM YOURLIB.SOURCE

(or create some view on the bigger table with fields of the smaller one to use in the SELECT part)

Else, in Abap, look in forum for samples of parallelization or cursor, calling for insert of batches of records in another task, there are already many samples.

Regards,
Raymond

topic Copy data between two tables using cursor in Application Development and Automation Discussions

Copy data between two tables using cursor

Re: Copy data between two tables using cursor