Copy Spooled File (CPYSPLF)

The Copy Spooled File (CPYSPLF) command copies the data records in the specified spooled file to a user-defined physical database file. This conversion allows the use of spooled files in applications using microfiche, data communications, or data processing. Print lines that are all blank are not copied. When you copy a spooled file to a physical file, certain information is lost or changed. For example:

Graphics data is lost.
Bar code data is lost.

Parameters

Keyword	Description	Choices	Notes
FILE	Spooled file	Name	Required, Positional 1
TOFILE	To data base file	Qualified object name	Required, Positional 2
	Qualifier 1: To data base file	Name
	Qualifier 2: Library	Name, LIBL, CURLIB
JOB	Job name	Single values: * Other values: Qualified job name	Optional
	Qualifier 1: Job name	Name
	Qualifier 2: User	Name
	Qualifier 3: Number	000000-999999
SPLNBR	Spooled file number	1-999999, ONLY, LAST, *ANY	Optional
JOBSYSNAME	Job system name	Name, ONLY, CURRENT, *ANY	Optional
CRTDATE	Spooled file created	Single values: ONLY, LAST Other values: Element list	Optional
	Element 1: Creation date	Date
	Element 2: Creation time	Time, ONLY, LAST
TOMBR	To member	Name, *FIRST	Optional
MBROPT	Replace or add records	REPLACE, ADD	Optional
CTLCHAR	Control character	NONE, FCFC, PRTCTL, S36FMT	Optional
CHLVAL	Channel values	Single values: NORMAL Other values (up to 12 repetitions): Element list*	Optional
	Element 1: Channel	1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
	Element 2: Line	1-255

Top

To data base file (TOFILE)

Specifies a user-defined physical database file to which the spooled records will be copied. If this file does not exist at the time of the copy, the copy will fail.

This is a required parameter.

Qualifier 1: To data base file

name: Specify the file name of the physical file to receive the copy.

Qualifier 2: Library

*LIBL: All libraries in the library list for the current thread are searched until the first match is found.

*CURLIB: The current library for the job is used to locate the file. If no current library entry exists in the library list, QGPL is used.
name: Specify the name of the library where the file is located.

Job name (JOB)

Specifies the job that created the spooled file whose data records are to be copied.

Single values

*: The job that issued this command is the job that created the spooled file.

Qualifier 1: Job name

name: Specify the name of the job that created the spooled file.

Qualifier 2: User

name: Specify the user name that identifies the user profile under which the job is run.

Qualifier 3: Number

000000-999999: Specify the system-assigned job number.

Spooled file number (SPLNBR)

Specifies the number of the spooled file, from the job whose data records are to be copied.

*ONLY: Only one spooled file in the job has the specified file name; therefore, the number of the spooled file is not necessary.

*LAST: The spooled file with the highest number and the specified file name is used.

*ANY: The spooled file number is not used to determine which spooled file is used. Use this value when the job system name parameter or the spooled file create date and time parameter is to take precedence over the spooled file number when selecting a spooled file.

1-999999: Specify the number of the spooled file whose data records are to be copied.

Job system name (JOBSYSNAME)

Specifies the name of the system where the job that created the spooled file (JOB parameter) ran. This parameter is considered after the job name, user name, job number, spooled file name, and spooled file number parameter requirements have been met.

*ONLY: There is one spooled file with the specified job name, user name, job number, spooled file name, spooled file number, and spooled file create date and time.
*CURRENT: The spooled file created on the current system with the specified job name, user name, job number, spooled file name, spooled file number, and create date and time is used.
*ANY: The job system name is not used to determine which spooled file is used. Use this value when the spooled file create date and time parameter is to take precedence over the job system name when selecting a spooled file.
name: Specify the name of the system where the job that created the spooled file ran.

Spooled file created (CRTDATE)

Specifies the date and time the spooled file was created. This parameter is considered after the job name, user name, job number, spooled file name, spooled file number, and job system name parameter requirements have been met.

Single values

*ONLY: There is one spooled file with the specified job name, user name, job number, spooled file name, spooled file number, and job system name.
*LAST: The spooled file with the latest create date and time of the specified job name, user name, job number, spooled file name, spooled file number, and job system name is used.

Element 1: Creation date

date: Specify the date the spooled file was created.

Element 2: Creation time

*ONLY: There is one spooled file with the specified job name, user name, job number, spooled file name, spooled file number, job system name, and spooled file create date.
*LAST: The spooled file with the latest create time of the specified job name, user name, job number, spooled file name, spooled file number, job system name, and spooled file create date is used.
time: Specify the time the spooled file was created.

To member (TOMBR)

Specifies the name of the file member that receives the copied records.

*FIRST: The first member of the specified file is used.

name: Specify the name of the member of the physical file. If this member does not exist, a member is created and the copy continues.

Control character (CTLCHAR)

Specifies which print control characters (if any) are to replace the spooled file's internal print control characters.

*NONE: No print control characters are created.
*FCFC: Specifies that the first character of every record contains one of the ANSI forms control codes listed in the CL Reference manual. This option may be useful for microfiche production.
*PRTCTL: Specifies that the first four characters of every record contains skip- and space-before values useful in high-level language programs. This code can be viewed as SSSL, where SSS is the skip-before line value and L is the space-before value.
*S36FMT: Specifies that the format of the records to be copied to a database file is the same as that created on the IBM System/36 for COPYPRT. This value is not allowed for spooled files which exist on primary or secondary auxiliary storage pools.

Channel values (CHLVAL)

Specifies a list of channel numbers with their assigned line numbers. Specify this parameter only if *FCFC is specified on the Control character (CTLCHAR) parameter). Channel number refers to a method of determining skipping for reports. Each assigned channel must have a corresponding line number to provide the correct positioning on a report.

Single values

*NORMAL: Indicates channel 1 is the only assigned channel number. The assigned line number for channel 1 is line 1.

Other values (up to 12 repetitions)

Element 1: Channel

channel-number: Specify which channels are used to control skipping on a report. The only valid values for this parameter are 1 through 12. Each channel number can be specified only once per Copy Spooled File (CPYSPLF) command.

Element 2: Line

1-255: The line number assigned for the channel number in the same list. The range of valid line numbers is 1 through 255. Each line number can be specified only once per Copy Spooled File (CPYSPLF) command.

Examples

Example 1: Replacing Data

CPYSPLF   FILE(QPRINT)  JOB(PAYROLL01)  SPLNBR(4)
          TOFILE(MYFILE)  TOMBR(MYMBR)  CTLCHAR(*PRTCTL)

In this example, file QPRINT (which is the fourth file produced by job PAYROLL01) is copied to member MYMBR of physical file MYFILE (which resides in a library found by searching the library list). The newly copied data replaces all old data in the member because all old records have been cleared. The 4-byte print control code is created.

Example 2: Adding Data

CPYSPLF   FILE(QPRINT)  TOFILE(MYLIB/MYFILE)  JOB(PAYROLL02)
          MBROPT(*ADD)  CTLCHAR(*FCFC)  CHLVAL((1 3) (4 15))

In this example, file QPRINT (the only file of that name left in job PAYROLL02) is copied to the first member of the physical file found in library MYLIB. The newly copied data is added to data existing in the member. The FCFC 1-byte print control character is used and takes advantage of the assigned channel values in formatting the output. The assigned channel values as specified on the command are as follows:

Line 3 assigned to channel 1
Line 15 assigned to channel 4

Error messages

*ESCAPE Messages

CPF2207: Not authorized to use object &1 in library &3 type *&2.
CPF3207: Member not added. Errors occurred.
CPF3303: File &1 not found in job &5/&4/&3.
CPF3309: No files named &1 are active.
CPF3311: Copy request failed for file &6 in &7.
CPF3330: Necessary resource not available.
CPF3340: More than one file with specified name found in job &5/&4/&3.
CPF3342: Job &5/&4/&3 not found.
CPF3343: Duplicate job names found.
CPF3344: File &1 number &8 no longer in the system.
CPF338A: Control character *S36FMT not allowed.
CPF3394: Cannot convert spooled file data.
CPF3429: File &1 number &7 cannot be displayed, copied, or sent.
CPF3482: Copy request failed. Spool file &1 is open.
CPF3483: Copy request failed for file &6 in &7.
CPF3486: CHLVAL parameter value not valid.
CPF3492: Not authorized to spooled file.
CPF3493: CTLCHAR parameter not correct for file &1.
CPF3499: Records in file &1 preceded all assigned channel values.
CPF5812: Member &3 already exists in file &1 in library &2.
CPF9812: File &1 in library &2 not found.
CPF9837: Attempt made to override file &1 to MBR(*ALL).
CPF9845: Error occurred while opening file &1.
CPF9846: Error while processing file &1 in library &2.