55
CoolSpools Spool Converter User Guide V6R1
Page:
94
www.ariadnesoftware.co.uk
*BLANK
A space or blank (ASCII x’20’ or the equivalent in
the CCSID selected) is used
*SEMICOLON
A semicolon (;) is used.
*PIPE
A pipe character (|) is used.
Field_delim
Type the delimiter character to be used.
The field delimiter will be output in the CCSID selected for the file.
Keep page headings?
How CoolSpools handles page headings in the file.
Following statistical analysis of a sample of the data in the spooled file, CoolSpools
will decide which lines are report data content and which not. Any lines which
precede the first report data line, but which do not appear to be a column heading,
will be considered a page heading. This element then determines how such lines are
handled.
Options are:
*FIRST
The first occurrence of a unique page heading line
is retained, but all subsequent occurrences of that
line are dropped from the output.
Note that any variation in the page heading from
one page to the next (such as a change in the time
that is printed at the top of the page) may cause
CoolSpools to retain a heading you would like to
have dropped. You may need to consider using
the EXCLLINNBR or EXCLLINKEY parameters to
exclude unwanted headings which CoolSpools
does not successfully drop.
*ALL
All page headings are retained.
*NONE
All page headings are dropped.
Keep column headings?
How CoolSpools handles column headings in the file.
Following statistical analysis of a sample of the data in the spooled file, CoolSpools
will decide which lines are report data content and which not. Any lines which
immediately precede the first report data line, and which overlap the data columns in
the report, will be considered column headings.
This element then determines how such lines are handled.
Options are:
*FIRST
The first occurrence of a unique column heading
line is retained, but all subsequent occurrences of
that line are dropped from the output.
Note that any variation in the column heading from
one page to the next may cause CoolSpools to
retain a heading you would like to have dropped.
You may need to consider using the EXCLLINNBR
or EXCLLINKEY parameters to exclude unwanted
51
CoolSpools Spool Converter User Guide V6R1
Page:
95
www.ariadnesoftware.co.uk
headings which CoolSpools does not successfully
drop.
*ALL
All column headings are retained.
*NONE
All column headings are dropped.
Spooled file currency symbol
This element defines the currency symbol that appears when printing currency
values in the report.
It is important that CoolSpools knows what currency symbol is used in the report so
that it can correctly identify columns of numbers that include a currency symbol as
numeric data rather than treating them as text.
Options are:
*SYSVAL
The currency symbol defined by the QCURSYM
system value is used in the report.
currency_symbol Specify the currency symbol used in the report if
this is different from the system currency symbol.
For example, if you are processing a report
containing values in Euros on a system where the
currency symbol is a pound sign (£), specify €.
CoolSpools will interpret data containing euro
signs as numeric data not text.
Spooled file decimal point
This element defines the decimal point that is used when printing numbers in the
report.
It is important that CoolSpools knows what decimal point symbol is used in the report
so that it can correctly identify columns of numbers as numeric data rather than
treating them as text.
Options are:
*JOB
The decimal point defined by the DECFMT
attribute of the current job is used in the report.
*SYSVAL
The decimal point defined by the QDECFMT
system value is used in the report.
Decimal_point
Specify the decimal point used in the report. For
example, if you are processing a report containing
numbers that have a comma as the decimal point
on a system where the normal decimal point is a
period (.), specify , (comma). CoolSpools will
interpret commas in numeric data as a decimal
point, not a thousands separator.
Spooled file 1000s separator
This element defines the thousands separator character that is used when printing
numbers in the report.
56
CoolSpools Spool Converter User Guide V6R1
Page:
96
www.ariadnesoftware.co.uk
It is important that CoolSpools knows what thousands separator character is used in
the report so that it can correctly identify columns of numbers as numeric data rather
than treating them as text.
Options are:
*JOB
The thousands separator character defined by the
DECFMT attribute of the current job is used in the
report.
*SYSVAL
The thousands separator character defined by the
QDECFMT system value is used in the report.
1000s_sep
Specify the thousands separator character used in
the report. For example, if you are processing a
report containing numbers that have a period as
the thousands separator character on a system
where the normal thousands separator character is
a comma (,)specify . (period). CoolSpools will
interpret periods in numeric data as a thousands
separator character, not a decimal point.
Spooled file date format
This element defines the date format that is used when printing dates in the report.
It is important that CoolSpools knows what date format is used in the report so that it
can correctly identify dates and treat them as such.
Options are:
*JOB
The date format defined by the DATFMT attribute
of the current job is used in the report.
*SYSVAL
The date format defined by the QDATFMT system
value is used in the report.
*DMY
The date format used in the report is day-month-
year. CoolSpools will identify data in the report
which looks like a valid DMY date as a date (2-digit
or 4-digit year).
*MDY
The date format used in the report is month-day-
year. CoolSpools will identify data in the report
which looks like a valid MDY date as a date (2-digit
or 4-digit year).
*YMD
The date format used in the report is year-month-
day. CoolSpools will identify data in the report
which looks like a valid YMD date as a date (2-digit
or 4-digit year).
Spooled file date separator
This element defines the date separator that is used when printing dates in the
report.
It is important that CoolSpools knows what date separator is used in the report so
that it can correctly identify dates and treat them as such.
Options are:
46
CoolSpools Spool Converter User Guide V6R1
Page:
97
www.ariadnesoftware.co.uk
*JOB
The date separator defined by the DATFMT
attribute of the current job is used in the report.
*SYSVAL
The date separator defined by the QDATFMT
system value is used in the report.
date_sep
Specify the date separator character used in the
report. For example, if you are processing a report
containing dates that have a hyphen as the date
separator on a system where the normal date
separator character is a slash, specify - (hyphen).
Spooled file word for 'Page'
This element defines the word “Page” as it appears in the report.
When excluding page headings, CoolSpools attempts to take account of lines which
differ only by a change of page number. In order to do so, it looks for the word
defined on this element followed by a number and treats that text as a page number
and ignores it for the purposes of deciding whether a page heading is a new one or a
repetition of a previous one.
Options are:
*DFT
The word for “Page” is taken from the text of
message CVT0008 in message file CP_MSGF.
This is shipped in the English version of
CoolSpools as “Page”.
Please note that if you change the text in this
message file, you will need to change it back again
after applying PTFs or new versions.
Word_for_page
Specify the word for “Page” as it is used with page
numbers in the report. For example, if it is
abbreviated to “P.”, specify “P.” here. S
imilarly, if
you are processing a Spanish-language report,
you may need to specify Página.
Example:
CVTSPLCSV
FROMFILE(SALESSTATS)…
CSV(*CRLF *DBLQUOTE *COMMA)
The Sales Stats report is converted to a delimited file is CSV (Comma-separated
variable format). Records are terminated by a carriage return/line feed pair.
Alphanumeric data is enclosed in double quotes. Fields are separated by commas.
34
CoolSpools Spool Converter User Guide V6R1
Page:
98
www.ariadnesoftware.co.uk
CUSTOMPAGE
–
Custom page size
Parameter
CUSTOMPAGE
Applies to
commands:
CVTSPLSTMF, CVTSPLHTML, CVTSPLPDF, CVTSPLRTF,
CVTSPLTXT
Dependent on: PAGESIZE(*CUSTOM)
This parameter allows you to define a non-standard page size.
Page width
Specify the width of the page in the units defined below.
Page length
Specify the length of the page in the units defined below.
Unit of measure
Specify the units in which the preceding dimensions are measured.
Options are:
*MM
Millimeters
*CM
Centimeters
*INCH
Inches
Example:
CVTSPLPDF
FROMFILE(SALES)…
PAGESIZE(*CUSTOM)
CUSTOMPAGE(10 10 *INCH)
The spooled file is converted to PDF format using 10-inch square paper.
56
CoolSpools Spool Converter User Guide V6R1
Page:
99
www.ariadnesoftware.co.uk
CVTFONTID - Convert font ids
Parameter
CVTFONTID
Applies to
commands:
CVTSPLHTML, CVTSPLPDF, CVTSPLRTF, CVTSPLSTMF
This parameter gives you close control over how fonts that are identified by a font
number (e.g. by means of the DDS FONT keyword or the FONT parameter of the
CRTPRTF command) are processed when your spooled file is converted.
For each font identifier or combination of font identifier and font size, you can specify
the predefined font to be used or a font object to be embedded. Where the specified
“from” font id and font size appears in the spooled file, that font will be mapped to the
font typeface and point size specified here, or the font object specified will be used to
reproduce that font in PDF.
Up to 100 font mappings or embedded fonts may be defined.
When FONT(*MAP) is specified, CoolSpools notifies you of the font mappings that it
has chosen by sending a message to the job log when you run the command. If you
are not satisfied with the appearance of your spooled file in the stream file, consider
using this parameter or the CVTFNTRSC parameter to define your own font
mappings. Refer to the discussion of the FONT parameter above for further
information about how CoolSpools assists you in identifying the font ids that need to
be mapped.
The default is *NONE , which indicates that no user-defined font id mappings are
specified.
Other than *NONE, all other selections for this parameter consist of two pairs of
elements:
o
From font id
consisting of:
o
Font id
o
Font size
o
Size units
and
o
To font
consisting of:
o
Face
o
Size
From font id
There is a single value:
*CPI
This denotes the font used in spooled files where
FONT(CPI) is specified, i.e. the font for basic text
in the spooled file where the text in question is not
associated with any of the DDS keywords FONT,
FNTCHRSET or CDEFNT and the spooled file
does not have any of the attributes:
66
CoolSpools Spool Converter User Guide V6R1
Page:
100
www.ariadnesoftware.co.uk
FONT(font_ID)
FNTCHRSET(font_character_set_name)
CDEFNT(coded_font_name)
Other values consist of:
Font Id
Enter the font number which identifies the font in the spooled file. This will usually be
a font number defined either on the FONT parameter of the CRTPRTF (Create
Printer File) command or on the DDS FONT keyword, e.g. 11 = Courier 10 CPI).
It can also be a PCL built-in font number.
Font Size
The default for the “from” font point size is *FONTID, which indicates that the font
point size implied by the font identifier should be assumed. Some IBM font identifiers
(e.g. 11 = Courier 10 CPI) imply a specific font size, while others (e.g. 5707 = Times
Roman Bold) do not. This is normally implemented on the system i through the use
of the printer file DDS keyword FONT with or without the *POINTSIZE option.
Size units
Options are:
*POINTS
The font size denotes the height of characters in
points.
*CPI
The font size denotes the pitch (width) of
characters in characters per inch.
To Font
This consists of:
Face
This specifies how the font will be implemented inside the PDF and can be any of:
o
a built-in PDF font
o
a system i font resource object
o
a TrueType of PostScript Type 1 font file located in the IFS
The following built-in typefaces are available for selection:
*COURIER
Courier
*COURIERB Courier Bold
*COURIERO Courier Oblique
*COURIERBO Courier Bold Oblique
*HELVETICA Helvetica
*HELVB
Helvetica Bold
*HELVO
Helvetica Oblique
*HELVB
Helvetica Bold
*HELVBO
Helvetica Bold Oblique
*TIMES
Times Roman
*TIMESB
Times Roman Bold
*TIMESI
Times Roman Italic
*TIMESBI
Times Roman Bold Italic
*SYMBOL
Symbol
*DINGBATS Zapf Dingbats
Documents you may be interested
Documents you may be interested
