1 2 3 4 5 6 7 8 9 10 11 12 13
| create table mabib/newfic as ( select '"' concat
trim(replace(ZA, '"', '')) concat trim(replace(MVCMP, '"', ''))
concat trim(replace(ZB, '"', '')) concat trim(replace(Z1, ';',
'";"')) concat trim(replace(ZC, '"', '')) concat
trim(replace(MVVND, '"', '')) concat trim(replace(ZD, '"', ''))
concat trim(replace(Z2, ';', '";"')) concat trim(replace(ZE, '"',
'')) concat trim(replace(MVSSN, '"', '')) concat trim(replace(ZF,
'"', '')) concat trim(replace(Z3, ';', '";"')) concat
trim(replace(ZG, '"', '')) concat trim(replace(MVNICD, '"', ''))
concat trim(replace(ZH, '"', '')) concat trim(replace(ZE, ';',
'";"')) concat trim(replace(ZI, '"', ''))
[...]
from MABIB/FICOLD) with data |
Partager