topic Re: read a file from application server in Application Development and Automation Discussions

read a file from application server

SwarnaliBasu — Mon, 17 Aug 2009 09:13:58 GMT

i want to read a file from application server using read dataset. for that i have written the code as

select * from zbdclog INTO CORRESPONDING FIELDS OF TABLE i_bdclog

where RICEFID = p_ricef

and username = p_user.

if sy-subrc = 0.

loop at i_bdclog into wg_bdclog.

fname = wg_bdclog-filepath.

OPEN DATASET fname FOR output IN TEXT MODE ENCODING DEFAULT.

IF sy-subrc = 0.

READ DATASET fname INTO wg_bdclog1-filepath.

append wg_bdclog1 to i_bdclog1.

ENDIF.

CLOSE DATASET fname.

endloop.

endif.

can anyone tell me where is the problem as the values of sy-subrc = 8, so its not getting inside the loop.

Re: read a file from application server

SuhaSaha — Mon, 17 Aug 2009 09:18:08 GMT

Hello Swarnali.

select * from zbdclog INTO CORRESPONDING FIELDS OF TABLE i_bdclog
where RICEFID = p_ricef
and username = p_user.
IF sy-subrc = 0.
* Do porcessing
ENDIF.

If this sy-subrc is failing goto SE16 & check if there is any data in the table zbdclog for

RICEFID = p_ricef and username = p_user

BR,

Suhas

Re: read a file from application server

former_member404244 — Mon, 17 Aug 2009 09:19:22 GMT

HI,

Check the data base table for the entries

AS u want to read the data from application server u need to write like this

OPEN DATASET <DATASET NAME> for INPUT in text mode endoing default.

OUTPUT->To write into the application server

INPUT->To read from application server.

Regards,

Nagaraj

Re: read a file from application server

Former Member — Mon, 17 Aug 2009 09:20:15 GMT

Hi,

Please check if there are any corresponding records available for your input that you have used in the select query i.e the ricefid and username.

And moreover, to read data from the application server, you use something like this


OPEN DATASET P_FNAME2 FOR INPUT IN BINARY MODE.
  READ DATASET P_FNAME2 INTO WA_SALESDETAILS.
  APPEND WA_SALESDETAILS TO T_SALESDETAILS.
  CLEAR WA_SALESDETAILS.
CLOSE DATASET P_FNAME2.

Edited by: Nitwick on Aug 17, 2009 2:50 PM

Re: read a file from application server

Former Member — Mon, 17 Aug 2009 09:21:05 GMT

Hi,

Check in table zbdclog whether any entries exist matching values of p_ricef and p_user.

Regards,

Ankur Parab

Re: read a file from application server

kesavadas_thekkillath — Mon, 17 Aug 2009 09:21:43 GMT

You can use transaction CG3Y

Re: read a file from application server

SwarnaliBasu — Mon, 17 Aug 2009 09:22:08 GMT

i have checked, records are available, the second sy-subrc is failing, i,e. its not going to read dataset

Regards

Swarnali

Re: read a file from application server

former_member404244 — Mon, 17 Aug 2009 09:24:34 GMT

HI,

Did u try to change ur code as i suggested

AS u want to read the data from application server u need to write like this

OPEN DATASET <DATASET NAME> for INPUT in text mode endoing default.

OUTPUT->To write into the application server

INPUT->To read from application server.

Regards,

Nagaraj

Re: read a file from application server

SwarnaliBasu — Mon, 17 Aug 2009 09:24:39 GMT

even if i use FOR INPUT , still i am getting this error, please help

Re: read a file from application server

Former Member — Mon, 17 Aug 2009 09:24:41 GMT

Hi,

Change the open dataset statement and check


OPEN DATASET fname FOR output IN TEXT MODE ENCODING DEFAULT.   "previous


OPEN DATASET fname FOR INPUT IN TEXT MODE ENCODING DEFAULT.  "corrected

Regards,

Vik

Re: read a file from application server

SwarnaliBasu — Mon, 17 Aug 2009 09:25:51 GMT

i used for input , still the sy-subrc value is 8 just before the read dataset

Re: read a file from application server

kesavadas_thekkillath — Mon, 17 Aug 2009 09:25:59 GMT

Also check whether you have authorization for reading,writing etc

Re: read a file from application server

Former Member — Mon, 17 Aug 2009 09:26:17 GMT

Hi,

I think there is a problem in ur select query... ur saying select * and putting those in CORRESPONDING FIELDS..... Check the declaration or ur internal table..

AND

Check the declaration of the field FNAME

DATA : FNAME TYPE STRING.

Re: read a file from application server

Former Member — Mon, 17 Aug 2009 09:26:27 GMT

Hi,

Do you want to read data from the application server. Then you gotto use the syntax

OPEN DATASET P_FNAME FOR INPUT IN BINARY MODE.

OUTPUT is for writing data into application server. Your file wouldnt have been existing in the application server. So it is possibly returning a 8 for the sy-subrc.

Re: read a file from application server

Former Member — Mon, 17 Aug 2009 09:26:46 GMT

Use

OPEN DATASET fname FOR INPUT IN TEXT MODE ENCODING DEFAULT.

Re: read a file from application server

Former Member — Mon, 17 Aug 2009 09:27:02 GMT

Hi,

After the select statement, check if i_bdclog -filepath has a valid application server file path.

Re: read a file from application server

SuhaSaha — Mon, 17 Aug 2009 09:29:14 GMT

Hello,

Quick check if the filepath exists in AL11. If yes, then go to the next lines

Just before the OPEN DATASET statement you can call the auth. obj S_DATASET (or the FM: AUTHORITY_CHECK_DATASET).

I think you donot have the access to read/write files from the folder.

BR,

Suhas

Edited by: Suhas Saha on Aug 17, 2009 11:31 AM

Re: read a file from application server

SwarnaliBasu — Mon, 17 Aug 2009 09:29:57 GMT

i have used IN BINARY MODE as well as i checked whether it has a valid filepath, but still i m getting the sy-subrc = 8.

Re: read a file from application server

Former Member — Mon, 17 Aug 2009 09:30:21 GMT

Hi,

Check the mode in which you are trying to open the file. Please do a F1 on the modes. See if it works with BINARY MODE. As suggested, try to use ENCODING DEFAULT addition to the OPEN DATASET.

Re: read a file from application server

SwarnaliBasu — Mon, 17 Aug 2009 09:31:52 GMT

before this i have used to create a file in application server and it worked fine so i think i have the authrosation, this is nt the problem, any other advice?