Copy To PC Document (CPYTOPCD)

Where allowed to run: All environments (*ALL)
Threadsafe: No 		Parameters
Examples
Error messages

The Copy To PC Document (CPYTOPCD) command copies a member from a system database file to a PC document in a folder.

Do not precede an entry with an asterisk unless that entry is a "special value" that is shown (on the display itself or in the help information) with an asterisk.

 

Error messages for CPYTOPCD

*ESCAPE Messages

IWS1612

Member &1 not copied to PC document.

Top

 

Parameters

Keyword Description Choices Notes
FROMFILE From file Qualified object name Required, Positional 1
Qualifier 1: From file Name
Qualifier 2: Library Name, *LIBL, *CURLIB
TOFLR To folder Character value Required, Positional 2
FROMMBR From member Name, *FIRST Optional, Positional 3
TODOC To document Character value, *FROMMBR Optional, Positional 4
REPLACE Replace document *NO, *YES Optional, Positional 5
TRNTBL Translate table Single values: *DFT, *NONE
Other values: Qualified object name 		Optional
Qualifier 1: Translate table Name
Qualifier 2: Library Name, *LIBL, *CURLIB
TRNFMT Format of PC data *TEXT, *NOTEXT Optional
TRNIGC DBCS code page *DFT, *JPN, *CHT, *BG5, *CHS, *KOR, *KSC, *SCGS, *NONE Optional
RCDFMT Record format Name, *ALL Optional

Top

 

From file (FROMFILE)

Specifies the name and library of the database file you are copying data from. The file can be either a physical file or a logical file.

This is a required parameter.

The possible library values are:

*LIBL

The library list is used to locate the database file.

*CURLIB

The current library for the job is used to locate the database file. If no current library entry exists in the library list, QGPL is used.

library-name

Specify the library where the database file is located.

If this file is a source file and the records are being translated from EBCDIC to ASCII, the line number and date are removed when the records are written in the PC document.

Top

 

To folder (TOFLR)

Specifies the name of the folder that contains the PC document being copied to.

The name can be a fully qualified path name of the form:

The path name can be up to 63 characters in length. All folders in the path must exist.

This is a required parameter.

Top

 

From member (FROMMBR)

Specifies the name of the member that is copied.

*FIRST

The first member of the file is copied.

member-name

Specify the name of the member that is copied.

Top

 

To document (TODOC)

Specifies the name of the PC document in the folder to contain the copied database file member. If the document does not exist, it is created.

*FROMMBR

The name of the PC document is the same as the member name.

document-name

Specify a valid document name which has the form:

  • filename.extension

The filename can be from 1 to 8 characters, and the extension can be from 1 to 3 characters.

Top

 

Replace document (REPLACE)

Specifies if an existing document is replaced by the copy operation.

*NO

If a document of this name already exists in the folder specified by the To folder prompt (TOFLR parameter), the copy is not performed.

*YES

If a document of this name already exists in the folder specified by the To folder prompt (TOFLR parameter), it is replaced by the database file member that is copied.

Top

 

Translate table (TRNTBL)

Specifies if translation is performed and, if so, the name of the translation table used to translate the data from EBCDIC to ASCII.

For a user defined double-byte character set, this parameter also specifies if translation is performed and, if so, which translation table is used for single-byte translation.

The format of the records in the PC document is handled by the Format of PC data prompt (TRNFMT parameter),

*DFT

The default translation table is used.

translation-table-name

Specify the name and library of the translation table.

The possible library values are:

*LIBL

The library list is used to locate the table.

*CURLIB

The current library for the job is used to locate the table. If no current library entry exists in the library list, QGPL is used.

library-name

Specify the library where the table is located.

*NONE

No translation from EBCDIC to ASCII is performed. The records are copied to the PC document as fixed-length records. There are no ASCII carriage return, line feed, or end of file characters added to the PC document. The length of these fixed length records is the same as the length of the records in the database file member.

Top

 

Format of PC data (TRNFMT)

Specifies the format the records in the PC document are to have.

This parameter is not valid if *NONE is specified on the Translate table prompt (TRNTBL parameter).

*TEXT

The records in the PC document will be written in standard DOS ASCII variable length format. The ASCII carriage return and line feed characters are added to the end of each record, and the ASCII end of file character is added to the end of the PC document.

*NOTEXT

The records in the PC document will be fixed length records. The length of the records in the database file is used for the length of the records in the PC document.

Top

 

DBCS code page (TRNIGC)

Specifies the double-byte character set used for translation. Unless overridden by the Translate table prompt (TRNTBL parameter), this parameter also specifies the single-byte translation table.

*DFT

The default country or region's double-byte character set.

*JPN

IBM Japanese.

*CHT

IBM Traditional Chinese.

*BG5

Taiwan Industry standard (BIG-5).

*CHS

IBM Simplified Chinese.

*KOR

IBM Korean (KS).

*KSC

Korean Industry standard.

*SCGS

The People's Republic of China National standard (GB).

*NONE

No double-byte translation is performed.

Top

 

Record format (RCDFMT)

Specifies the record format(s) of records to be copied. The possible values are:

*ALL

All records (of all record formats) in the database file are to be copied.

record-format-name

Specify the name of a record format if you want only records with that specific record format to be copied.

Top

 

Examples

None

Top

Error messages

*ESCAPE Messages

IWS1612

Member &1 not copied to PC document.

Top