IBM 000-8697 Manual de usuario Pagina 500

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 702
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 499
7-22 IBM Informix OnLine Database Server Administrator’s Guide
How to Create a Command File
You can combine both forms of the FILE statement in a single command file.
For clarity, each statement type and form are described separately in the
sections that follow:
Delimiter form FILE statement (page 7-22)
Delimiter form INSERT statement (page 7-23)
Character-position FILE statement (page 7-26)
Character-position INSERT statement (page 7-28)
Delimiter Form FILE Statement
The syntax for the delimiter form of the FILE statement can be represented as
follows:
If the delimiter specified by c appears anywhere in the input file as a literal
character,itmustbeprecededwithabackslashintheinputfile.Forexample,
if the value of c were specified as [, you would need to place a backslash
beforeanyliteral[that appearedintheinputfile.Similarly,youmustprecede
any backslash that appears in the input file with an additional backslash.
The DELIMITER keyword causes dbload to internally assign the sequential
names f01, f02, f03, ... to fields in the input file. You cannot see these names,
but if you refer to these fields to specify a value list in an associated INSERT
statement, you must use the f01, f02, f03 format.Refer to page 7-24 to see an
example.
c definesthefield delimiterforthespecificinputfilespecifiedas
filename.
filename specifies the input file.
nfields is an integer that indicates the number of fields in each data
row contained in filename.
FILE
filename DELIMITER c nfields ;
Vista de pagina 499
1 2 ... 495 496 497 498 499 500 501 502 503 504 505 ... 701 702

Comentarios a estos manuales

Sin comentarios