diff options
| -rw-r--r-- | sql/dawn.sql | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index b6b675aa..b91c94db 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -708,15 +708,21 @@ RETURNS text AS $$ DECLARE result text; stub text; + fcm text; BEGIN -result := 'CDS_%s%s_%s.0000000000_ICE-CREDIT_SGFCM_%s'; +result := 'CDS_%s%s_%s.0000000000_ICE-CREDIT_%s_%s'; IF tenor = '3yr' AND redcode = '2I65BYDJ1' THEN stub := '.3'; ELSE stub := ''; END IF; -result := format(result, redcode, stub, fixed_rate, to_char(maturity, 'YYYYMMDD')); +IF redcode = '2I65BRQY9' OR redcode = '2I65BYBE4' OR redcode = '2I666VCT0' THEN + fcm = 'WELLSFCM'; +ELSE + fcm = 'BOMLCM'; +END IF; +result := format(result, redcode, stub, fixed_rate, fcm, to_char(maturity, 'YYYYMMDD')); RETURN result; END; $$ LANGUAGE plpgsql; |