Copy From PC Document (CPYFRMPCD)

The Copy From PC Document (CPYFRMPCD) command copies the data in a PC document to a system database file.

Note: 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 CPYFRMPCD

*ESCAPE Messages

IWS1603
PC document copied to file with &6 truncated records.
IWS1611
PC document &1 not copied.

Parameters

Keyword Description Choices Notes
FROMFLR From folder Character value Required, Positional 1
TOFILE To file Qualified object name Required, Positional 2
Qualifier 1: To file Name
Qualifier 2: Library Name, *LIBL, *CURLIB
FROMDOC From document Character value Required, Positional 3
TOMBR To member Name, *FIRST, *FROMDOC Optional, Positional 4
MBROPT Replace or add records *REPLACE, *ADD 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
IGCSOSI Insert DBCS SO/SI *YES, *NO Optional

From folder (FROMFLR)

Specifies the name of a folder containing the PC document that is copied. This parameter can also specify the name of a folder path in the form:

The path name can be up to 63 characters in length.

This is a required parameter.

To file (TOFILE)

Specifies the name and library of the physical database file that you are copying the PC document to.

If this file is a source file and you choose to translate the PC document, a sequence number is added and a system date of zeroes is added as it is copied to the 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.

From document (FROMDOC)

Specifies the name of the PC document that is copied. The name has the following format:

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

This is a required parameter.

To member (TOMBR)

Specifies the name of the member to contain the copied PC document. If no member is specified, the first member of the file is the member that is copied to. If the member does not exist, it is created.

*FIRST
The PC document is copied to the first member.
*FROMDOC
The member being copied to has the same name as the PC document. (The PC document name must be a valid system member name.)
member-name
Specify the member name that the PC document is copied to.

Replace or add records (MBROPT)

Specifies if the copied records are added to or replace the existing records in the physical file.

*REPLACE
The copied records replace the existing records in the physical file member.
*ADD
The copied records are added to the existing records in the physical file member.

Translate table (TRNTBL)

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

Note: 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.

*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 ASCII to EBCDIC is performed. Data is copied byte for byte.

Format of PC data (TRNFMT)

Specifies the format of the records in the PC document.

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

*TEXT
The PC document records in standard DOS ASCII variable length format are transformed to the fixed length format of the database file. The carriage return, line feed, and end of file characters are removed. Imbedded tab characters are expanded to blanks, and the record is padded with EBCDIC blanks to fill out the fixed length format.
*NOTEXT
The records in the PC document are considered fixed length records of the same length as the physical database file records they are copied to.

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.

Insert DBCS SO/SI (IGCSOSI)

Specifies if shift-out and shift-in characters are inserted during translation. This parameter is valid only for double-byte character set users. This parameter is not valid if *NONE is specified on the Translate table prompt (TRNTBL parameter).

*YES
Shift-out and shift-in characters are inserted during translation.
*NO
Shift-out and shift-in characters are not inserted during translation.

Examples

None

Error messages

*ESCAPE Messages

IWS1603
PC document copied to file with &6 truncated records.
IWS1611
PC document &1 not copied.