Code: Select all
vsql -d VMart_Schema -w ${DB_PASSWD} -c "INSERT INTO GL.CURRENCYTABLE (CURRENCY_CODE, PERIOD_YEAR, BEGIN_BALANCE_DR,INDIAN_CURRENCY) SELECT
CURRENCY_CODE,
PERIOD_YEAR,
BEGIN_BALANCE_DR,
(CASE
WHEN CURRENCY_CODE = 'GBP' THEN BEGIN_BALANCE_DR*95
WHEN CURRENCY_CODE = 'CAD' THEN BEGIN_BALANCE_DR*60
ELSE
BEGIN_BALANCE_DR
END ) as INDIAN_CURRENCY
FROM
GL.GL_BALANCES;COMMIT; "