topic Re: Generating Unicode Files in Application Development and Automation Discussions

Generating Unicode Files

Former Member — Thu, 03 Nov 2005 20:12:59 GMT

Does anyone know how to create a unicode file using PL/SQL? I must generate labels and not all the locations are on SAP. So I download a file from SAP (4.7 non-unicode) and need to send only certain records to a vendor in China.

Thanks in advance

Re: Generating Unicode Files

christian_wohlfahrt — Fri, 04 Nov 2005 07:52:02 GMT

Hi Colleen!

To create files on application servers, you can use the statements open dataset / transfer / close dataset.

In your case this could look like:

OPEN DATASET file FOR OUTPUT IN TEXT MODE ENCODING UTF-8. 
TRANSFER `1234567890` TO file. 
CLOSE DATASET file.

Regards,

Christian

Re: Generating Unicode Files

Former Member — Fri, 04 Nov 2005 19:14:50 GMT

Hi Christian,

Do you know if with PL SQL I can generate a unicode file?

Thanks!

Re: Generating Unicode Files

christian_wohlfahrt — Sat, 05 Nov 2005 19:28:16 GMT

What is PL/SQL? For me SQL spells standard query language and just helps to get data - up to here no data (file) output is defined.

Re: Generating Unicode Files

Former Member — Mon, 07 Nov 2005 15:17:40 GMT

I need to do is send that file from Unix to file server. It appears that the file is being corrupted. The trademark and register symbols is being converted.

Re: Generating Unicode Files

christian_wohlfahrt — Mon, 07 Nov 2005 16:23:28 GMT

Hi Colleen!

Glad to hear, you solved already most parts.

Let's go into details:

- Are you sure, your file displayer is handling UTF-8 correctly?

- Are files on application server (Unix) and file server identical (not only total size, but every byte)?

- Is UTF-8 correct codepage, or do you need a different codepage version?

I don't believe there is a problem with the UTF-8 codepage itself, but if you just have problems with two characters: you might replace them with substitution values in file preparation.

Regards,

Christian