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 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
| static void ma_methode ( void )
{
EXEC SQL EXECUTE
BEGIN
UPDATE ma_table
SET champ1 = DECODE( NVL(champ1 ,'#'), '#' , :ach_O_CodNull
, '999997', champ1
, '999998', champ1
, '999999', champ1
, DECODE( SUBSTR(champ1,1,2), '03'
, SUBSTR(champ1,1,2) || '000' || SUBSTR(champ1,6,1)
, SUBSTR(champ1,1,4) || '0' || SUBSTR(champ1,6,1)
)
)
,champ2 = DECODE( NVL(champ2 ,'#'), '#' , :ach_O_CodNull
, '999997', champ2
, '999998', champ2
, '999999', champ2
, DECODE( SUBSTR(champ2,1,2), '03'
, SUBSTR(champ2,1,2) || '000' || SUBSTR(champ2,6,1)
, SUBSTR(champ2,1,4) || '0' || SUBSTR(champ2,6,1)
)
)
,champ3 = DECODE( NVL(champ3 ,'#'), '#' , :ach_O_CodNull
, '999997', champ3
, '999998', champ3
, '999999', champ3
, DECODE( SUBSTR(champ3,1,2), '03'
, SUBSTR(champ3,1,2) || '000' || SUBSTR(champ3,6,1)
, SUBSTR(champ3,1,4) || '0' || SUBSTR(champ3,6,1)
)
)
,champ4 = DECODE( NVL(champ4 ,'#'), '#' , :ach_O_CodNull
, '999997', champ4
, '999998', champ4
, '999999', champ4
, DECODE( SUBSTR(champ4,1,2), '03'
, SUBSTR(champ4,1,2) || '000' || SUBSTR(champ4,6,1)
, SUBSTR(champ4,1,4) || '0' || SUBSTR(champ4,6,1)
)
)
,champ5 = DECODE( NVL(champ5,'#'), '#' , :ach_O_CodNull
, '999997', champ5
, '999998', champ5
, '999999', champ5
, DECODE( SUBSTR(champ5,1,2), '03'
, SUBSTR(champ5,1,2) || '000' || SUBSTR(champ5,6,1)
, SUBSTR(champ5,1,4) || '0' || SUBSTR(champ5,6,1)
)
)
,champ6 = DECODE( NVL(champ6,'#'), '#' , :ach_O_CodNull
, '999997', champ6
, '999998', champ6
, '999999', champ6
, DECODE( SUBSTR(champ6,1,2), '03'
, SUBSTR(champ6,1,2) || '000' || SUBSTR(champ6,6,1)
, SUBSTR(champ6,1,4) || '0' || SUBSTR(champ6,6,1)
)
)
,champ7 = DECODE( NVL(champ7,'#'), '#' , :ach_O_CodNull
, '999997', champ7
, '999998', champ7
, '999999', champ7
, DECODE( SUBSTR(champ7,1,2), '03'
, SUBSTR(champ7,1,2) || '000' || SUBSTR(champ7,6,1)
, SUBSTR(champ7,1,4) || '0' || SUBSTR(champ7,6,1)
)
) ;
COMMIT;
END;
END-EXEC;
} |
Partager