topic Re: READ DATASET in Application Development and Automation Discussions

READ DATASET

Former Member — Mon, 20 Aug 2007 10:46:20 GMT

uploaded into SAP. When tried to open and read the flat file using OPEN DATASET and READ DATASET commands,

the Sy-subrc value returned is 8 and the error message 'the specified file not found' is displayed. We checked the path and

the file is in the correct location. What is missing?

Re: READ DATASET

Former Member — Mon, 20 Aug 2007 11:13:15 GMT

File names and paths are case sensitive in a lot of server operating systems - check that yours is correct in this aspect.

Also see if you can find / display the dataset in AL11 - could be permissions for the file are not correct.

Andrew

Re: READ DATASET

Former Member — Fri, 24 Aug 2007 10:10:58 GMT

Hi Rahul

Before data can be processed , a file need to be opened.

open dataset <file name> for < input / output / appending >

in < text mode / binary mode>

Processing a file involves reading the file or writing on to the file transfer.

read dataset <file name> into < field>

Each read will get one record from the dataset . In binary mode it reads the length of field and in text mode it reads each line.

If the program attempts to read a record that do not exist ,then it will show an error.

So it is the error in mode( text mode or binary mode)

Manas

If useful donot forget to reward me

Re: READ DATASET

Former Member — Fri, 24 Aug 2007 12:11:02 GMT

OPEN DATASET p_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

*--- Display error messages if any.

IF sy-subrc NE 0.

MESSAGE e001(zsd_mes).

EXIT.

ELSE.

*---Data is downloaded to the application server file path

LOOP AT it_tab2 INTO wa_tab2.

TRANSFER wa_tab2 TO p_file.

ENDLOOP.

ENDIF.

*--Close the Application server file (Mandatory).

CLOSE DATASET p_file.

Re: READ DATASET

varma_narayana — Mon, 27 Aug 2007 08:04:36 GMT

Hi..Sharma..

you can print the Exact message why the File is not opened using this code:

PARAMETERS : P_DSN(40) DEFAULT 'TEMP.TXT'.

DATA : V_MSG TYPE STRING.

OPEN DATASET P_DSN FOR INPUT

IN TEXT MODE ENCODING DEFAULT

MESSAGE V_MSG. "Returns the Actual message why the file not opened

if sy-subrc ne 0.

Message v_msg type 'E'.

Else.

<<<<< do the Processing here>>>>

Endif.

<b>Reward if Helpful</b>