Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 6 | Andrea | 1 | LOAD DATA |
| 2 | INFILE * |
||
| 3 | INSERT INTO TABLE S3_SS02T_PROT_SINTEG |
||
| 4 | Fields terminated by ";" Optionally enclosed by '"' |
||
| 5 | ( |
||
| 6 | SS02_PROT_SINTEG NULLIF (SS02_PROT_SINTEG="NULL"), |
||
| 7 | SS02_DATA DATE "MM/DD/YYYY HH24:MI:SS" NULLIF (SS02_DATA="NULL"), |
||
| 8 | SS02_ANNOTAZ, |
||
| 9 | SS02_COD_ENTE NULLIF (SS02_COD_ENTE="NULL"), |
||
| 10 | SS02_COD_COM, |
||
| 11 | SS02_AREA_TEMATICA NULLIF (SS02_AREA_TEMATICA="NULL") |
||
| 12 | ) |
||
| 13 | BEGINDATA |
||
| 14 | 0;"02/21/2005 00:00:00";"PROTOCOLLO VIGENTE";1;"0000";0 |