topic Re: Issues with Open Dataset in Application Development and Automation Discussions

Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:48:06 GMT

I am using the following to open a file:

  OPEN DATASET p_file FOR INPUT IN LEGACY TEXT MODE.

and no matter what file I try to open it fails. I also tried using:

  OPEN DATASET p_file FOR INPUT IN TEXT MODE ENCODING DEFAULT.

but I have the same issues. I have verified that p_file contains the filename that I am retrieving. I am getting the filename by using the following on help request for the file:

CALL FUNCTION 'KD_GET_FILENAME_ON_F4'
    CHANGING
      file_name     = p_file
    EXCEPTIONS
      mask_too_long = 1
      OTHERS        = 2.

Do you have any ideas?

Regards,

Aaron

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:49:50 GMT

It could be a Authorisation Issue. Does the user have authorization to open that file. U can check thru AL11 also.

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:49:58 GMT

Hi Aaron,

What is the SY-SUBRC value after the OPen dataset statement?

Regards,

Ravi Kanth Talagana

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:50:52 GMT

sy-subrc = 8.

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:51:38 GMT

Aparna, I was thinking the same but I am the author of the files and my SAP username has SAP_ALL.

Re: Issues with Open Dataset

former_member156446 — Wed, 11 Jun 2008 17:52:31 GMT

Hi file path and the file name are case sensitive.. check that..

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:53:48 GMT

The authorization checked in this case is at the Directory (OS level). You SAP authorization doesnt matter. THe directory you are accessing should have the security setting to allow you to write/read files.

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:54:31 GMT

have you tried


OPEN DATASET p_file FOR INPUT IN TEXT MODE.

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:54:50 GMT

Jackandjay, I am not doing anything with the filename so it has to be in the correct case.

It is possible to use this command to open a file that is not on the application server correct? If not then that is the issue. All of these files are on my laptop.

Regards,

Aaron

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:55:43 GMT

OK, I looked and the directory I am pulling this from isn't in the list. I suppose that is my issue?

Aaron

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:56:19 GMT

sy-subrc Description

0 File was opened.

8 Operating system could not open file

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 17:57:23 GMT

"All of these files are on my laptop."

Use FM GUI_UPLOAD

OPEN/READ/etc are for application server.

Edited by: Paul Chapman on Jun 11, 2008 1:57 PM

Re: Issues with Open Dataset

Former Member — Wed, 11 Jun 2008 18:08:50 GMT

'KD_GET_FILENAME_ON_F4' is used to get file names which are on desktop where as OPEN DATASET is used to open the files on Application server.

As you are mentioning your files on your laptop, then you need to use GUI_UPLOAD..