Hp Neoview Release 2.3 Software Manuel d'utilisateur télécharger pdf (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

ExampleDescription

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

1 2 ... 27 28 29 30 31 32 33 34 35 36 37 ... 109 110

Pas de commentaire

Hp Neoview Release 2.3 Software Manuel d'utilisateur Page 32