topic Re: Read dataset problem in Application Development and Automation Discussions

Read dataset problem

Former Member — Fri, 03 Jul 2009 14:04:46 GMT

Hi,

I have a dataset and want to read this dataset data into an attachment itab, however i see that i write all of data into dataset

but i could not read all data into attachment.

What could be the reason?

In sm69 trans i see that file is correctly, even there are blanks lines, written but when tried to read the same file,

i just can get the half of data or a little more.

Thanks.

Re: Read dataset problem

Former Member — Fri, 03 Jul 2009 14:11:26 GMT

do you have what is the size of the dataset you are writing out to?

is it big enough?

Re: Read dataset problem

Former Member — Fri, 03 Jul 2009 14:15:59 GMT

How you are doing it?

Are you doing like

data: rec(5000).

open dataset file1 for input in text mode.

if sy-subrc eq 0.

do.

read dataset file1 into rec.

if sy-subrc eq 0.

else.

exit.

endif.

enddo.

endif.

Edited by: Sam m on Jul 3, 2009 4:19 PM

Re: Read dataset problem

Former Member — Fri, 03 Jul 2009 14:18:03 GMT

Hi,

Please check while opening the file, whether the file is opened properly or not.

I mean the SY-SUBRC = 0, after the OPEN DATASET command, it indicates that the file is opened properly for reading.

Lets say if it not equal to 0 here, then may be file is not existing or no authorization etc..

Now in degugging check the contents in the internal table, whether it got populated or not properly.

If everything is correct here, then the problem could be, after populating the final internal table, while downloading the data, some thing must have done incorrectly.

If the file data is more, then while transferring it to intenal table itself will give you the dump.

Regards,

Nangunoori.

Re: Read dataset problem

Former Member — Fri, 03 Jul 2009 14:19:33 GMT

Hi,

it is a file,

data: filename type string.

and used it like that:

filename becomes : /tmp/03072009.txt

open dataset filename for output in TEXT MODE ENCODING UTF-8.

and every encoding statement i have tried:

open dataset filename for output in TEXT MODE ENCODING UTF-8.

"legacy text mode.

"LEGACY text mode."

"ENCODING NON-UNICODE."UTF-8.

Here is ok, no problem in writing into file.

Problem is at reading the file:

and attch is like that:

data : attch like SOLISTI1 occurs 10 with header line.

open dataset filename for INPUT in BINARY MODE.
                       "TEXT MODE ENCODING UTF-8.
                      "binary mode.
                      "ENCODING  UTF-8 
 refresh attch.
 do.
  clear attch.
  read dataset filename into attch.
  if sy-subrc <> 0.
    CONCATENATE attch con_cret INTO attch.
   append attch.
   exit.
  endif.
  CONCATENATE attch con_cret INTO attch.
  append attch.
 enddo.

Thanks.

Re: Read dataset problem

Former Member — Fri, 03 Jul 2009 14:27:42 GMT

Try:

OPEN DATASET filename FOR INPUT IN TEXT MODE ENCODING DEFAULT.
REFRESH attch.
DO.
  CLEAR attch.
  READ DATASET filename INTO attch.
  IF sy-subrc = 0.
    CONCATENATE attch con_cret INTO attch.
    APPEND attch.
  ELSE.
    EXIT.
  ENDIF.
ENDDO.

Rob