topic Re: Database Download in Application Development and Automation Discussions

Database Download

Former Member — Mon, 16 Apr 2007 05:37:14 GMT

Hi,

I wanted to download all the data from database table to file with field name.

Anybody will suggest me the code.

Re: Database Download

Former Member — Mon, 16 Apr 2007 05:40:32 GMT

Hi neha,

Use Extract the data into some internal table with all the required fields then use GUI_DOWNLOAD Function module if u want to download into presentation server , if u want to download in appl server then use open dataset, transfer and close dataset.

Regards,

Shafi

Re: Database Download

Former Member — Mon, 16 Apr 2007 05:43:14 GMT

i given this syntax check this

OPEN DATASET [DATASET NAME] FOR [OUTPUT / INPUT / APPENDING]

IN [BINARY / TEXT] MODE

AT POSITION [POSITION]

MESSAGE [FIELD]

READ DATASET [DATASET NAME] INTO [FIELD]

DELETE DATASET [DATASET NAME]

CLOSE DATASET [DATASET NAME]

TRANSFER [FIELD] TO [DATASET NAME]

regards

praveen

Re: Database Download

Former Member — Mon, 16 Apr 2007 05:54:01 GMT

Hai,

Follow these steps:

Step 1:First declare an internal table of Database table type like:

Data:

begin of itab occurs 0.

include structure database_tabe_name.

data:

end of itab.

Step2:

Write a select query to retrive all dbtable data into otab.

Select *

from db_table

into table itab.

Step 3:

Call FM GUI_DOWNLOAD by passing itab and mensioning the FILE PATH and FILE NAME.

Hope now you can get all the data into your file.

Reward points if it helps you.

Regds,

Rama chary.Pammi