Re: Unable to CPYSPLF

On 30/07/2008, at 4:18 AM, Albert York wrote:

I am trying to copy a spool file to a flat file that I created in QTEMP but I get the message: must be a double-byte character set (DBCS) file.

Indicates the spooled file must contain (or at least be capable of containing) DBCS data.

Is there a way to get around this or to create a double-byte character set file in QTEMP?

Yes. Specify IGCDTA(*YES) on the CRTPF command. This keyword is present only on DBCS versions of the OS. All versions of OS/400 from VRM530 and above are inherently DBCS. To make your code work on all versions simply retrieve the QIGC system value. If set to 1 then add IGCDTA(*YES) to the CRTPF command string.

I have been using CPYSPLF for years but this is the first time I have encountered this.

Then you've either been lucky or living in an isolated world such as the USA. Once you get the CPYSPLF working you will likely have another learning experience due to the position of data in the spooled file being slightly different on a DBCS system from an SBCS system. Easy enough to code for but does make the code more complex than might initially be expected.

Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------