Converting CCSID Correctly when Downloading Reports
From Support
| If you have a question or seek clarification, please call Technical Support. |
Problem:
When using the WinSpool/400 product on an AS/400 system, how can users download reports with DBCS data or special characters.
Some users who have double byte reports are getting a CPF3311 error "Copy request failed for file WINOUTQ in QTEMP".
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)
- Note: If you have V3.26 or newer of the WINSPOOL library, there is no need to reinstall the AS/400 library.
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 create its work files with the IGCDTA parameter = *YES.
CHGDTAARA DTAARA(WINSPOOL/WSPLDBCS) VALUE(*YES)
5.) Stop your FTP server using the following command:
ENDTCPSVR SERVER(*FTP)
- Note: Wait 15 seconds before going to Step 6.
6.) Restart your FTP server using the following command:
STRTCPSVR SERVER(*FTP)
- Note: Steps 5 & 6 make sure that all temporary files created in library QTEMP for the FTP server get cleared out and reset.
Now when WinSpool/400 creates all temporary download files the product will set the IGCDTA parameter = *YES when creating physical files.
7.) If you have a different CCSID on your system other than 65535, run the following command to tell WinSpool/400 to use the selected CCSID value. From now on, all reports downloaded via WinSpool/400 or any of the RJS automated download products should use the selected CCSID value when downloading and converting reports.
Example:
WSPLCCSID OPTION(*SET) CCSID(285)
The above example uses CCSID 285 when converting report data. Use your local CCSID value.
Note: If you don't know your systems CCSID value, run the following AS/400 command to display the setting:
DSPSYSVAL SYSVAL(QCCSID)
