topic Re: about insert statement . in Application Development and Automation Discussions

about insert statement .

Former Member — Mon, 21 May 2007 23:03:59 GMT

Hi,

i need to insert 10,00,000 records into one table from one another table.

i have used insert statement like

insert <Database table> from <internal table>.

I want to know it will insert this much record or is there any chance of dump

because of the size of the record.

thanks,

jack

Re: about insert statement .

Former Member — Mon, 21 May 2007 23:06:46 GMT

hi,

u might get dump error for time out. as it takes lot of time...

try to insert in different number of amount.. not as in 1 time.

Regards

SAB

Re: about insert statement .

Former Member — Mon, 21 May 2007 23:12:47 GMT

Thanks for reply.

How can i divide my internal table .?

thanks,

Jack

Re: about insert statement .

Former Member — Mon, 21 May 2007 23:24:13 GMT

10,000.00 does not matter, you can insert as many depends on ur database buffer.

If you use insert command and you may get dump because if you are trying to insert existing record.

so better to use modify command.I will recommend try to run the program in background.

modify dbtable from table int_table.

Thanks

Sesh

Message was edited by:

Seshu Maramreddy

Re: about insert statement .

Former Member — Mon, 21 May 2007 23:24:49 GMT

Hi,

This may give a dump due to lack of memory owing to huge number of records.

I would suggest you to fetch data from the table in chunks.

Create a loop until there are any more records in the table.

Use UP TO .. ROWS while fetching data from the table into internal table. Then insert these records from internal table into database table.

Code will look like:

DO.

SELECT * INTO ITAB1

UPTO 40000 ROWS

FROM TAB1.

IF SY-SUBRC = 0.

INSERT TAB2 FROM ITAB1.

ELSE.

EXIT.

ENDIF.

ENDDO.

Hope this helps.

Re: about insert statement .

Former Member — Mon, 21 May 2007 23:29:21 GMT

If you are able to get 1 million records into an internal table without getting a runtime error, then inserting them into the DB table should not be a problem. If you are getting runtime error getting 1 million records into your internal table, you should think about running it in the background. You may also encounter issue with the maximum setting your basis team did for internal table memory.

Try it and you will know.