beautypg.com

Dataformats – HP Neoview Release 2.3 Software User Manual

Page 32

background image

“%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