Menu item 40: Export DB/2 file(s) (Part 3)

HTML (HTML Options) This parameter only applies if TOFMT(*HTML) is selected and controls several aspects of HTML file creation from the database file.
This parameter contains 9 elements:

The value *DFT (default value) selects the defaults for all of the elements described below.

Date Format This option controls the format in which date information in the database file will be presented in the stream file.
Please note: This only applies to actual date fields in the database file. Numerical and alphanumerical fields containing date information cannot be identified as dates by *DBEXPORT.

All other options specify a date format and a separator character which divides the year, month, and day portions of the date.

Format

Separator Character

Time Format This option determines the format in which time information in the database file is presented in the stream file.

All other options specify a time format and a separator character which divides the hour, minute, and second portions of the time.

Please note:
This only applies to actual time fields in the database file. Numerical and alphanumerical fields containing times cannot be identified as times by *DBEXPORT.

Format

Separator Character

Decimal Point Character This element determines the characters to be used to denote a decimal point when representing fields with one or more decimal places.

HTML Title Text input here will appear in the title bar of the browser when HTML file is displayed.

Table Caption Text input here will appear as the HTML table caption. The HTML table caption is a explanatory text displayed above a data table.

Table's Boarder Width The width of the tables boarder in pixels.

Table Cell Spacing This attribute specifies how much space (measured in pixels) the browser should leave between the left side of the table and the left-hand side of the left-most column, as well as between the top of the table and the top side of the first row, and so on for the right and bottom of the table. The attribute also specifies the amount of space to leave between cells.

Table Cell Padding This attribute specifies the amount of pixels between the border of the cell and its contents.

Apply Edit Codes and Words This option determines if CVTDBF will use edit codes (EDTCDE) and edit words (EDTWRD) as defined by the DDS for formatting fields in the target file.

Convert Null Fields to This attribute determines how null fields are converted.

HEADER (Header Options) The HEADER (Header Row options) parameter specifies if and how a header row will be created in the stream file.
Please note: Header rows cannot be created for fixed-length ASCII files created with TOFMT(*FIXED) because the fixed-length nature of the columns in these types of files do not allow the creation of a header row.
It is common practice to include a single row at the beginning of the data that provides column labels for the data in CSV, Excel and HTML files.
This parameter contains 3 elements:

The first element determines the source of the headers contents. The following options are possible:

The second element determines if the column width will be fixed.
The following options are possible:

The third element determines if column headings in Excel contain linefeeds when the text of the column headings is derived from DDS column headings (COLHDG keyword).
Options are:

Additional Header - Line 1 The first of up to three free-format heading lines that appear above the column headings.

Additional Header - Line 2 The second of up to three free-format heading lines that appear above the column headings.

Additional Header - Line 3 The third of up to three free-format heading lines that appear above the column headings.

Headers on Sheets with Text Overflow Specifies if headers will be repeated on sheets with text overflow, when formatting with Excel. If the amount of converted data exceeds the maximum number of rows of an Excel worksheet, i-effect^® creates an extra text overflow, to retain the extra information. This element controls the rendering of column headers at the top of overflow sheets.

SORT (Sorting Tasks) The SORT (Sort Specifications) parameter can change the order in which records re-trieved from the input source are presented in the output stream file. It sorts the records by one or more fields.
Up to 50 sort keys may be specified in the format explained below, or one of these two single values can be selected:

Each sort key has two elements:

Key Field Name

Key Field Order

Suppress Repetitions Repetitions will be replaced by null cells.

QRYSLT (Query Selection)

Any logical expression, either formed from relationships (such as *EQ and *NE) of field and constant values or functions of field and constant values, can be entered. At least one field name is specified in each relationship.
The syntax of this query selection string is identical to that used by the QRYSLT parameter's OPNQRYF command.
Please note: If the input to CVTDBF is one of the special values *SQL, *SQLSRC, *QMQRY, or *QRYDFN, any record selections made in the SQL or query will reduce the size of the temporary results file that CVTDBF will process as its input. The *DBEXPORT QRYSLT parameter then controls record selection to the temporary results file, if appropriate. For example, SQL can be used to query the order file and calculate order totals by customer with the GROUP BY function. The SQL's WHERE clauses can be used to select only customers in New York State. The temporary results file would contain totals for each customer. The *DBEXPORT QRYSLT parameter could then be used to select only those customers whose totals exceed a given threshold value.

DBFCCSID The DBFCCSID (Database File CCSID) parameter specifies the CCSID (Coded Character Set Identifier) which best describes the encoding of data in the database file if this information is not otherwise available to *DBEXPORT.
The following options are possible:

STMFCODPAG (Stream File Code Page) The STMFCODPAG (Stream File Code Page) parameter determines the way in which i-effect^® will convert data from the format in which it is stored on the Power Systems (typically EBCDIC) to an appropriate format in the stream file (typically ASCII).
The rules used to determine how Power Systems data is converted are complex, and depend on numerous factors including the file format of the new stream file (as specified by the TOFMT parameter).
In particular, PDF has its own rules regarding data encoding, which are followed in all instances. The value specified by the STMFCODPAG parameter will be ignored in relation to PDF creation and CVTSPL will convert the spooled file contents and all other data (such as the values specified on the TITLE or KEYWORDS parameters) to a format compatible with PDF.
The following special values are possible:

Example:

CVTSPL FILE(INVOICES)
TGTFMT(*TEXT)...
STMFCODPAG(1253)

The CVTSPL command is creating an ASCII text file from a Greek-language spooled file called INVOICES. Code page 1253, suitable for Greek-language data, will be used to convert the contents of the spooled file.
Common Windows code pages are shown in the table below. CVTSPL maps EBCDIC CCSIDs to Windows code pages in this manner. If the ECBDIC CCSID has no defined mapping, code page 1250 is used by default. If the characters in the spooled file do not appear correctly in the stream file created by CVTSPL, try to specify it with the help of the STMFCODPAG parameter.

Example:

CVTSPL FILE(FACTURES)
STMFCODPAG(1252)

In the example above, the CVTSPL command is used to create an ASCII text file from a French-language spooled file called FACTURES. Windows code page 1252, suitable for French-language data, will be used to convert the contents of the spooled file.

UNICODE The UNICODE (Unicode Options) parameter determines various Unicode related options when specifying a Unicode encoding scheme with the STMFCODPAG parameter.
This parameter contains 2 elements:

Big endian or Little endian Because UCS2 coding requires 2 bytes to display each character, this option determines the order in which the bytes will appear.

Include Unicode marker? This option determines if *DBEXPORT will mark the beginning of a text file telling the reading application if the byte order is big endian or little endian.
Applications such as Windows NotePad check for a marker at the start of the file (hex x'FEFF' or x'FFFE') and use it to identify if Unicode data is encoded in big endian or little endian format.

DBFDATFMT(Database Date Format) This parameter defines the format in which dates in the numerical fields of the database file will be converted.
If a field in the database file being converted is:

• A packed decimal or zoned decimal

• 6, 7, or 8 digits in length

• Not containing any decimal places

• Or was edited with an edit code of ‚Y'

*CVTDBF will attempt to interpret the field as a date and convert it to a date in the output file. For this reason, *CVTDBF must know in which date format the data appears.
The following options are possible:

AUT (Authority) Determines the rights for the creation of data stream files. If the data stream file already exists, this parameter has no effect and the existing file retains its current settings.
The creator of the stream file (i.e. the user who issued the CVTSPL command) will always have complete rights to the new data stream file. This parameter controls the rights for other users.
The following options are possible:

The second element of this parameter defines the public authority for the work files required to create a PDF file.
CVTSPL requires three temporary work files to generate PDF output. These files are normally automatically deleted when the command is completed or if an error occurs.
The files are named #job_nbr, where job_nbr is the job number of the job by which the command was run.
The owner of the temporary file is always granted full authority. This parameter controls the authority given to other users. The default is *RWX (read, write and execute authority, i.e. full authority).
Please note: if a value other than *RWX is specified by this command, it is possible, in certain circumstances, that the file's creator will not have authorization to delete the file, and be unable to clear them after use.
The following options are possible:

Inherit auth. from directory? The INHERITAUT (Inherit Authority) parameter controls if object authorities are inherited from the parent directory in which the stream file is created.
The following options are possible

If the INHERITAUT is set to *NO, the object authorities (*OBJEXIST, *OBJMGT, *OBJALTER, and *OBJREF), assigned to the owner, primary group, and *PUBLIC with respect to the stream file being created, are copied from the owner, primary group, and public object authorities of the parent directory in which the stream file is created. This occurs even when the new file has a different owner than the parent directory. The new file does not have any private authorities or authorization list. It only has authorities for the owner, primary group, and public. The owner is assigned full data authorities and *PUBLIC is assigned the data authorities specified by the AUT parameter.
If the INHERITAUT is set to*YES, the object authorities (OBJEXIST, *OBJMGT, *OBJALTER, and *OBJREF), assigned to the owner, primary group, and *PUBLIC with respect to the stream file being created, are copied from the owner, primary group, and public object authorities of the parent directory in which the stream file is created. However, the private authorities (if any) and authorization list (if any) are also copied from the parent directory. If the new file has a different owner than the parent directory and the new file's owner has a private authority in the parent directory, that private authority is not copied from the parent directory. The authority for the owner of the new file is copied from the owner of the parent directory. The owner is assigned full data authorities and *PUBLIC is assigned the data authorities specified by the AUT parameter.