Copy From PC Document (CPYFRMPCD)
Where allowed to run: All environments (*ALL)
Threadsafe: NoParameters
Examples
Error messagesThe Copy From PC Document (CPYFRMPCD) command copies the data in a PC document to a system database file.
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.
Top
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 nameOptional 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
Top
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:
- folder1/folder2/folder3/.../foldern
The path name can be up to 63 characters in length.
This is a required parameter.
Top
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.
Top
From document (FROMDOC)
Specifies the name of the PC document that is copied. The name has the following format:
- filename.extension
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.
Top
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.
Top
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.
Top
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.
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.
Top
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.
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
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.
Top
Examples
None
Top
Error messages
*ESCAPE Messages
- IWS1603
- PC document copied to file with &6 truncated records.
- IWS1611
- PC document &1 not copied.
Top