topic Re: Unix command not working properly in Application Development and Automation Discussions

Unix command not working properly

Former Member — Mon, 22 Jun 2009 09:16:37 GMT

Hi All,

I am using Unix command to concatenate all the child files into one target file.

I have the child filenames in one internal table. So, I am looping on that table and concatenating each file with the target file in each iteration as shown below.

LOOP AT t_childjobs_files INTO e_childjobs_files.

    CONDENSE e_childjobs_files-file.

    OPEN DATASET e_childjobs_files-file FOR INPUT IN TEXT MODE ENCODING DEFAULT.

    IF sy-subrc EQ 0.

*Command to concatenate the child file into main file
      CONCATENATE 'cat '
                  e_childjobs_files-file
                  ' >> '
                  p_file
             INTO w_command
RESPECTING BLANKS.

      CONDENSE w_command.

      CALL 'SYSTEM' ID 'COMMAND' FIELD w_command.

      MESSAGE s025 WITH sy-subrc.

      DELETE DATASET e_childjobs_files-file.

    ENDIF.

    CLEAR: w_command,
           e_childjobs_files.

  ENDLOOP.

But, the above piece of code is working fine only in debugging mode, but not in foreground/background mode. Also, the sy-subrc value of the ABAP statement which processes the unix command is 0.

Could you please let me know what could be the problem? It looks strange for me.

Thanks,

Babu Kilari

Re: Unix command not working properly

Former Member — Mon, 22 Jun 2009 09:24:46 GMT

replace the below code with

CALL 'SYSTEM' ID 'COMMAND' FIELD w_command.

the below code.

Check the it_return what is the message you are getting, instead of sy-subrc.

data: begin of it_return occurs 0,
        line(400),
      end of it_return.

  call 'SYSTEM' id 'COMMAND' field w_command
                id 'TAB'    field  it_return[].

Re: Unix command not working properly

former_member226519 — Mon, 22 Jun 2009 09:34:49 GMT

I once solved the problem by defining the command in SM69 and execute it in my report with fm SXPG_COMMAND_EXECUTE

Re: Unix command not working properly

Former Member — Mon, 22 Jun 2009 09:39:14 GMT

Hi Vijay.

I tried the way you suggested. But, it is still not working.

Sy-subrc value is 0.

Thanks,

Babu Kilari

Re: Unix command not working properly

Former Member — Tue, 23 Jun 2009 03:35:28 GMT

Hi,

The problem is Unix command is getting executed properly. But, as I am deleting the file in the next step, the OS is not able to find the file and hence the results are nothing.

I removed the Delete statement and it is working fine. But, the problem is how would I know that the merging of the files is done completely?

On what basis would I know that it has finished off copying the complete source file into the target file?

Thanks,

Babu Kilari

Re: Unix command not working properly

Former Member — Tue, 23 Jun 2009 04:33:15 GMT

call 'SYSTEM' id 'COMMAND' field w_command
                id 'TAB'    field  it_return[].

Check the it_return, First try to see what is there inside that ( Don't depend on Sy-subrc )

Success or failure you can get the complete information inside the it_return.

Re: Unix command not working properly

Former Member — Tue, 23 Jun 2009 04:45:03 GMT

Hi Vijay,

Thanks for the reply.

call 'SYSTEM' id 'COMMAND' field w_command
                id 'TAB'    field  it_return[].

Now, the command is getting executed, but it_return[] has nothing in it.

It is INITIIAL.It has no records...

Does that mean we will always have to use it as per above statement ?

One more question here is, I have seen few more example which has code written in the following way

call 'SYSTEM' id 'COMMAND' field w_command
                id 'TAB'    field  it_return-*sys*.

What does sys mean? Also when you declare it using the above statement the internal table should always be of type with header line. But, internal table declaration with header line is obsolete in ECC6.0 right?

Please give me some hints or suggestions on this? Also, I have not got F1 help on these commands.

I tried to search in SDN to get good blogs/stuff. But, I couldnt find any. If you have some pointers please

post the same. Will be helpful for me.

Thanks in advance.

Babu Kilari

Re: Unix command not working properly

Former Member — Tue, 23 Jun 2009 09:15:20 GMT

I just provided the sample. for ECC environment you need to declare with out header.

types: begin of t_return ,
        line(400),
      end of t_return.

 data: it_return type STANDARD TABLE OF t_return.

  call 'SYSTEM' id 'COMMAND' field w_command
                id 'TAB'    field  it_return.

it_return-sys considers the body of the internal table incase of internal table declared with header line.

it_return-sys is equivalent to it_return[] ( when you declare internal table with header line ) or

it_return-sys is equivalent to it_return ( when you declare the internal table with out header line).