Converting the UK Sterling Symbol Correctly when Downloading Reports - Support

Converting the UK Sterling Symbol Correctly when Downloading Reports

From Support

Jump to: navigation, search
If you have a question or seek clarification, please call Technical Support.

Problem:

When using the WinSpool/400 product on an AS/400 system in the UK/England, the Sterling (£) symbol downloads as a Dollar Sign ($). What can the user to resolve this problem ?

Solution:

1.) Download and install V3.26 or later of the WinSpool/400 library (WINSPOOL) from the RJS Software Systems web site. To determine the version of your WINSPOOL library use the following command: DSPDTAARA DTAARA(WINSPOOL/VERSION)

2.) After installing the new WINSPOOL library, re-enter all the AS/400 access codes.

3.) Sign on to the AS/400 and add the WINSPOOL library to your library list using the following command: ADDLIBLE WINSPOOL

4.) Run the following command to tell WinSpool/400 to use a DDS created work file: WSPLUSEDDS OPTION(*SET) USEDD(*YES)

5.) Run the following command to tell WinSpool/400 to use CCSID 285 when converting report data: WSPLCCSID OPTION(*SET) CCSID(285)

6.) Re-start the AS/400 FTP server before using these settings. This clears out an WinSpool/400 work files in library QTEMP for the AS/400 FTP server.

Listed below are the commands for re-starting the AS/400 FTP server: ENDTCPSVR *FTP <wait 30 seconds> STRTCPSVR *FTP

From now on, all reports downloaded via WinSpool/400 or any of the RJS automated download products should use CCSID 285 and the Sterling should get correctly downloaded in the report.

Personal tools