1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| LOAD DATA
INFILE '/home/cics_new/incoming/CMSSO.csv'
TRUNCATE
INTO TABLE cics_soldes
fields terminated by ";"
trailing nullcols
(
DATEREF DATE "DD/MM/YYYY",
DATEARRET DATE "DD/MM/YYYY",
CODEBAN char,
CODEGUI char,
RACINE char,
NUMERO char,
RIBBAN char,
RIBGUI char,
RIBRACINE char,
RIBDO char,
CODEGES char,
CODEDEV char,
SOLDEV decimal external "to_number(replace(:soldev,',','.'))",
CONTVALEURO decimal external "to_number(replace(:contvaleuro,',','.'))",
DATEDERMOUV char,
ROLE char,
SOLDERISQ decimal external "to_number(replace(:solderisq,',','.'))",
INDICANOM char,
LIBANOMA char,
ROLERIB char
) |
Partager