Data in Application server is getting truncated

[Former Member]

HI,

when sending data to application server using Open dataset at point data is getting truncated.

Please let me what should be done to oercome this.

[Former Member]

Hi Avinash,

The problem seems to be in TRANSFER command.

Please check specifying LENGTH while TRANSFER.

Thanks

Shital

[Former Member]

Hi,

The application server file shows 512 characters in a line even though the rest characters are available. The data is not truncated. It is available there.To check read the same dataset and download the contents in a notepad. U will get all the data.

Thank you.

<removed_by_moderator>

[Former Member]

I'm trying to download to excel sheet using the options provided in menu options of application server. It's downloading what it is showing (i.e. incomplete data)

My requirement is send the tab sepereated data to application server and form there they can download to excel sheet depending on there requirement.

Please help me out in this

[Former Member]

Hi,

U can create a small program with the READ DATASET syntax in it.Use GUI_DOWNLOAD for downloading in the excel sheet.

Reward points if gound useful.

Check the sample program to doenload in Notepad. The data shown is 512 chracters but in the notepad u will get 1000 characters.

DATA : l_string TYPE string,

con TYPE c LENGTH 10 VALUE 'AAAAAAAAAA',

temp TYPE c LENGTH 4 VALUE 'temp',

len TYPE i VALUE 1000.

DATA : itab LIKE TABLE OF l_string.

DO 100 TIMES.

CONCATENATE l_string con INTO l_string.

ENDDO.

OPEN DATASET temp FOR OUTPUT IN LEGACY TEXT MODE IGNORING CONVERSION ERRORS.

TRANSFER l_string TO temp LENGTH len.

CLOSE DATASET temp.

CLEAR l_string.

OPEN DATASET temp FOR INPUT IN LEGACY TEXT MODE IGNORING CONVERSION ERRORS.

READ DATASET temp INTO l_string.

APPEND l_string TO itab.

CLOSE DATASET temp.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = 'C:\Documents and Settings\srrao\Desktop\temp.txt'

filetype = 'ASC'

TABLES

data_tab = itab.

IF sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

<removed_by_moderator>

Edited by: Julius Bussche on Aug 27, 2008 4:26 PM

[Former Member]

Got the answer

[Former Member]

Hi Avinash,

I have a similar problem as well, can you let me know how did the issue get resolved.

Thanks in Advance,

Praveen