topic Re: OPEN DATASET in Application Development and Automation Discussions

OPEN DATASET

Former Member — Thu, 23 Jun 2005 11:55:00 GMT

Hello all,

I am facing a problem in OPEN DATASET.

I need to download a .TXT file on the application server.

Desired format is to download each record in new line. for example:

0110432191852710 20021213

0110432191854710 20021213

I have used:

OPEN DATASET p_daf FOR OUTPUT in text mode.

LOOP AT g_t_itab.

TRANSFER g_t_itab TO p_daf.

CLEAR:g_t_itab. ENDLOOP.

CLOSE DATASET p_daf.

But I get a single stream of data in my text file. The records are separated by a special character ( a Black box ) - I open the .TXT file in <b>NOTEPAD</b>

Is this behaviour normal? Else how do I download the records in different lines as a text file on Application server?

Thanks in advance.

Regards, Murugesh AS

Message was edited by: Murugesh Arcot

Re: OPEN DATASET

Former Member — Thu, 23 Jun 2005 12:02:57 GMT

Hi,

You can use the syntax

OPEN DATASET <dsn> [FOR ....] [IN ... MODE] AT POSITION <pos>.

This statement opens the file <dsn>, and prepares it for reading or writing from position <pos>. <pos> is the number of bytes from the beginning of the file. It is not possible to specify a position before the beginning of the file.

Hope this may help you.

Thanks&Regards

Ruthra.R

Re: OPEN DATASET

Former Member — Thu, 23 Jun 2005 12:30:38 GMT

Hi Muruesh,

Please chek this link:

It might help you.

Regards,

Anjali

Re: OPEN DATASET

Former Member — Thu, 23 Jun 2005 13:37:56 GMT

You haven't included your endloop statement. It has to be before the close statement.

Rob

Re: OPEN DATASET

andreas_mann3 — Thu, 23 Jun 2005 13:50:28 GMT

Hi Murugesh,

your coding is ok.

perhaps try to omit ending .txt in your file name

what is when you reload your saved file with sap ?

-> try another text editor e.g. ultra edit

regards Andreas

Re: OPEN DATASET

Former Member — Thu, 23 Jun 2005 13:55:56 GMT

What are you using to look at the file? Sounds like you have something that doesn't understand unix-style newlines. There is absolutely no reason why that code of yours shouldn't work.

Re: OPEN DATASET

Former Member — Thu, 23 Jun 2005 14:14:22 GMT

Hello Andreas, Nathan and others,

Thanks for your response.

As Andreas suggested, I uploaded the same in SAP and it works fine.

Well I have not explained the requirement. We have different SAP systems and the data is downloaded in .txt from each system and a java utility uploads this data into the BW system.

This system/interface is in place now and SAP system on which I am working will be giving data to BW system.

Regards, Murugesh AS

Re: OPEN DATASET

FredericGirod — Thu, 23 Jun 2005 14:18:16 GMT

If you transfer data from unix to windows computer you have to modify the return code. You do this with ftp when you select ascii transfer.

Maybe look your java utility for text transfer instead of binary transfer

Frédéric

Re: OPEN DATASET

Former Member — Thu, 23 Jun 2005 15:40:41 GMT

Hi Murugesh,

WHy dont you try using split command when moving the file.

Let me know if you have any questions still. Put split and go for F1, you will know the syntax.

Thanks,

Bhavana

Re: OPEN DATASET

Former Member — Tue, 28 Jun 2005 12:12:09 GMT

Hello Andreas and Nathan,

The Interface works fine with the downloaded file from Unix bases SAP system too without any changes.

Thanks for the help.

Best Regards, Murugesh AS