Format Data (FMTDTA)
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.
| 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 |
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.
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.
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.
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.
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.
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.
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.