Dataformats – HP Neoview Release 2.3 Software User Manual
Page 32
“%Y”
— To specify a formatstring for a day-time duration of 30.5 seconds formatted as
“30.5”:
“%S”
— To specify a formatstring for a day-time duration of 1 day, 2 hours, 3 minutes,
and 4 seconds formatted as “1:2:3:4”:
“%D:%H:%M:%D”
— The following formatstring is invalid because fields are not specified in order
from day to seconds:
“%H:%M:%D:%S”
Table 5-2 Typeformats: format_definition Date/Time Format String Examples
Example
Description
"%C%y%m%d"
Specify a formatstring for a date field without field
delimiters, in the format of "20070131"
"%C%y-%m-%d"
Specify a formatstring for a date field with hyphen
delimiters, in the format of "2007-01-31"
"%m/%d/%y %H:%M"
Specify a formatstring for a timestamp field with
mixed delimiters, in the format of "10/1/2007 12:45"
typeformats
{
formatname date "%C%y%m%d",
formatname date "%C%y-%m-%d"
}
Two typeformats of datatype date, with formats of
"20070131"
and "2007-01-31", respectively.
Dataformats
The dataformats section describes the data format of sources and targets. Format definitions
are for delimited, fixed-length, or Neoview SQL table format.
dataformats
{
format_definition [, format_definition ]...
}
format-definition:
delimited-format | fixed-length-format | SQL-table-format
format-definition
One or more occurrences of format-definition, separated by a comma (,). The last
format-definition
should not use the comma separator.
32
Control File Organization and Syntax