Subversion Repositories Sigmater

Rev

Blame | Last modification | View Log | Download | RSS feed

LOAD DATA
INFILE *
INSERT INTO TABLE S3_SS02T_PROT_SINTEG
Fields terminated by ";" Optionally enclosed by '"'
(
  SS02_PROT_SINTEG NULLIF (SS02_PROT_SINTEG="NULL"),
  SS02_DATA DATE "MM/DD/YYYY HH24:MI:SS" NULLIF (SS02_DATA="NULL"),
  SS02_ANNOTAZ,
  SS02_COD_ENTE NULLIF (SS02_COD_ENTE="NULL"),
  SS02_COD_COM,
  SS02_AREA_TEMATICA NULLIF (SS02_AREA_TEMATICA="NULL")
)
BEGINDATA
0;"02/21/2005 00:00:00";"PROTOCOLLO VIGENTE";1;"0000";0