Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to over write a file on server using Dataset

former_member295881
Contributor
0 Likes
483

Hello Experts,

Iu2019ve trying to write a code to fetch data in my program and create a file on server. My program work fine. However every time I run my program it append data at the end of the tile which it created 1st time. I donu2019t want this to happen. I want to new record to print on this file or in other words I want it to over write the file. Here is my code of dataset part.

-


open dataset file for appending in text mode encoding default.

if sy-subrc ne 0.
  write:/ 'File Opening/Creation Error'.
    exit.
endif.


loop at ivbrk.
  clear record.
    move ivbrk-headr to record+1(1).
    move ivbrk-vbeln to record+3(10).
    move ivbrk-waerk to record+15(5).
    move ivbrk-knumv to record+22(10).
    move ivbrk-fkdat to record+34(8).
    move ivbrk-kunrg to record+43(10).
    move ivbrk-kunag to record+54(10).
      transfer record to file.

    loop at ivbrp where vbeln = ivbrp-vbeln.
     clear items.
      move ivbrp-items to items+1(1).
      move ivbrp-posnr to items+3(6).
      move ivbrp-fkimg to items+11(13).
      move ivbrp-vrkme to items+25(3).
      move ivbrp-meins to items+30(3).
      move ivbrp-ntgew to items+34(15).
      move ivbrp-brgew to items+50(15).
      move ivbrp-gewei to items+66(3).
        transfer items to file.
    endloop.
endloop.

close dataset file.

-


Can please somebody tell me what change I should make to over write on this file?

Thanks a lot in advance.

Moderator message - Please use code tags around your code

Edited by: Rob Burbank on Jan 12, 2010 5:08 PM

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
455

Try using this:

open dataset file for output in text mode encoding default.

Hello Experts,

Iu2019ve trying to write a code to fetch data in my program and create a file on server. My program work fine. However every time I run my program it append data at the end of the tile which it created 1st time. I donu2019t want this to happen. I want to new record to print on this file or in other words I want it to over write the file. Here is my code of dataset part.

-


open dataset file for appending in text mode encoding default.

if sy-subrc ne 0.
  write:/ 'File Opening/Creation Error'.
    exit.
endif.


loop at ivbrk.
  clear record.
    move ivbrk-headr to record+1(1).
    move ivbrk-vbeln to record+3(10).
    move ivbrk-waerk to record+15(5).
    move ivbrk-knumv to record+22(10).
    move ivbrk-fkdat to record+34(8).
    move ivbrk-kunrg to record+43(10).
    move ivbrk-kunag to record+54(10).
      transfer record to file.

    loop at ivbrp where vbeln = ivbrp-vbeln.
     clear items.
      move ivbrp-items to items+1(1).
      move ivbrp-posnr to items+3(6).
      move ivbrp-fkimg to items+11(13).
      move ivbrp-vrkme to items+25(3).
      move ivbrp-meins to items+30(3).
      move ivbrp-ntgew to items+34(15).
      move ivbrp-brgew to items+50(15).
      move ivbrp-gewei to items+66(3).
        transfer items to file.
    endloop.
endloop.

close dataset file.

-


Can please somebody tell me what change I should make to over write on this file?

Thanks a lot in advance.

Moderator message - Please use code tags around your code

Edited by: Rob Burbank on Jan 12, 2010 5:08 PM

2 REPLIES 2
Read only

Former Member
0 Likes
455

Hey zero:

open dataset file for appending in text mode encoding default.

Probably because you're opening it for appending.

Rob

Read only

Former Member
0 Likes
456

Try using this:

open dataset file for output in text mode encoding default.