Format Data (FMTDTA)

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

The Format Data (FMTDTA) command processes a series of sort specifications stored in a source file member.

For information on defining sort specifications, go to the IBM Publications Center web page and search for the Sort User's Guide and Reference manual.

Top

Parameters

Keyword Description Choices Notes
INFILE Input file Values (up to 8 repetitions): Element list Required, Positional 1
Element 1: File Qualified object name
Qualifier 1: File Name
Qualifier 2: Library Name, *CURLIB, *LIBL
Element 2: Member Name, *FIRST
OUTFILE Output file Element list Required, Positional 2
Element 1: File Qualified object name
Qualifier 1: File Name
Qualifier 2: Library Name, *CURLIB, *LIBL
Element 2: Member Name, *FIRST
SRCFILE Source file Qualified object name Optional, Positional 3
Qualifier 1: Source file Name, QFMTSRC
Qualifier 2: Library Name, *CURLIB, *LIBL
SRCMBR Source member Name, *FIRST Optional, Positional 4
PRTFILE Print file Qualified object name Optional, Positional 5
Qualifier 1: Print file Name, QSYSPRT
Qualifier 2: Library Name, *LIBL, *CURLIB
OPTION Options: Values (up to 8 repetitions): *CHK, *NOCHK, *PRT, *NOPRT, *DUMP, *NODUMP, *NOSECLVL, *SECLVL Optional, Positional 6
PGMDATE Program date: Date, *CURRENT Optional
Top

Input file (INFILE)

Specifies up to eight names for files that are to be used as input. One member name can be specified for each file name. This is a required parameter.

Element 1: File

Qualifier 1: File

name
Specify the name of the file that is to be used as input.

Qualifier 2: Library

*CURLIB
The current library will be used. If you have not specified a current library, QGPL will be used.
*LIBL
The system searches the library list to find the library where the file is located.
name
Specify the name of the library of the input file.

Element 2: Member

*FIRST
The first member in the file is to be used as input.
name
Specify the name of the database file member to be used.
Top

Output file (OUTFILE)

Specifies the file and file member to be used for output. Both the file and member must exist before the command is run. This is a required parameter.

Element 1: File

Qualifier 1: File

name
Specify the name of the output file to be used.

Qualifier 2: Library

*CURLIB
The current library will be used. If you have not specified a current library, QGPL will be used.
*LIBL
The system searches the library list to find the library where the file is located.
name
Specify the name of the library of the output file.

Element 2: Member

*FIRST
The first member in the file is to be used for output.
name
Specify the name of the member in the output file that is to be used for output.
Top

Source file (SRCFILE)

Specifies the source file containing the sort specifications to be run. The specified database file must have the attributes of a source file.

Qualifier 1: Source file

QFMTSRC
The IBM-supplied source file QFMTSRC contains the sort specifications.
name
Specify the name of the source file that contains the sort specifications.

Qualifier 2: Library

*LIBL
The system searches the library list to find the library where the source file is located.
*CURLIB
The current library will be used. If you have not specified a current library, QGPL will be used.
name
Specify the name of the library that contains the source file.
Top

Source member (SRCMBR)

Specifies the name of the source file member containing the sort specifications to be run.

*FIRST
The first member of the source file containing the sort specifications is to be run.
name
Specify the name of the member of the source file containing the sort specifications to be run.
Top

Print file (PRTFILE)

Specifies the printer device file to which the print data is to be sent.

Qualifier 1: Print file

QSYSPRT
The data is to be printed by the system printer.
name
Specify the name of the printer device file that is to print the data.

Qualifier 2: Library

*LIBL
The system searches the library list to find the library where the file is located.
*CURLIB
The current library will be used. If you have not specified a current library, QGPL will be used.
name
Specify the name of the library that contains the file.
Top

Options: (OPTION)

Specifies the sequence checking and printing options to be used while the sort utility is running.

You can specify 8 values for this parameter.

*CHK
The sort specifications are to be sequence-checked.
*NOCHK
The sort specifications are not to be sequence-checked.
*PRT
The sort specifications and any error or informational messages are to be printed.
*NOPRT
The sort specifications and any error or informational messages are not to be printed.
*NODUMP
The internal tables used for problem analysis are not to be printed.
*DUMP
The internal tables used for problem analysis are to be printed.
*NOSECLVL
Suppresses the printing of second level text for errors detected during compilation.
*SECLVL
Prints second level text for errors detected during compilation.
Top

Program date: (PGMDATE)

Specifies the date that can be used with factor 2 as a keyword in record specifications.

*CURRENT
Use the current system date when the command is run.
date
Specify the date in the format specified by system value QDATFMT. If date separators are used, they must match system value QDATSEP.
Top

Examples

None
Top

Error messages

None

Top