How Can I Solve Dump Due To Insufficient Memory

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View How Can I Solve Dump Due To Insufficient Memory as PDF for free.

More details

  • Words: 230
  • Pages: 2
How can I solve dump due to insufficient memory (SELECT)? I am using a SELECT query on a database table. Since the number of records in the table is very large, the program dumps due to insufficient memory. How can I solve this? In this case you could use the PACKAGE SIZE addition in the SELECT query to process in limited amount of data, thus avoiding the memory overloads. Eg:

SELECT * FROM INTO TABLE itab PACKAGE SIZE .

IF sy-subrc EQ 0. \*" Process the n records ENDIF.

ENDSELECT. tables : mara. data : it_mara like mara occurs 0 with header line. select * from mara into table it_mara package size 100000000. endselect. loop at it_mara. write : / sy-tabix, it_mara-matnr. endloop.

How can I convert numerals into the corresponding text? Use the Function Module SPELL_AMOUNT to convert the integer into text.

DATA v_int TYPE i VALUE '1000'. DATA words LIKE SPELL. CALL FUNCTION 'SPELL_AMOUNT' EXPORTING AMOUNT = v_int LANGUAGE = SY-LANGU IMPORTING IN_WORDS = words.

WRITE words-word. DATA words LIKE SPELL. " SPELL IS A STRUCTURE CALL FUNCTION 'SPELL_AMOUNT' EXPORTING AMOUNT = 1111 * CURRENCY ='' * FILLER ='' LANGUAGE = SY-LANGU IMPORTING IN_WORDS = WORDS EXCEPTIONS NOT_FOUND =1 TOO_LARGE =2 OTHERS =3 . IF sy-subrc = 0. WRITE : / 'SUCCESFULLY CONVERTED TO WORDS'. ENDIF. WRITE : / '1111 IN WORDS IS : ' , WORDS-WORD.

Related Documents

How To Problem Solve
June 2020 11
How Can I Motivate
October 2019 31
How To Solve Rubik Cube
October 2019 14
How Can I Jump
November 2019 25
01 How To Solve Problems
November 2019 14