Hi First post here so hope i am following the correct procedure. I have multiple sql scripts that i want to cover by 1 script but can't seem to get the syntax correct. I have included below an example of what i am trying to do.
update "BAL_SHEET_DETAIL"
set ccy_cde = 2
where ccy_cde = 1
update "BAL_SHEET_DETAIL"
set ccy_cde = 1
where ccy_cde = 7
update "BANK_DIARY_FILE"
set accno_scurrency = '02'
where accno_scurrency = '01'
update "BANK_DIARY_FILE"
set accno_scurrency = '01'
where accno_scurrency = '07'
update "GENERAL_LEDGER"
set acc_no_currency = '02'
where acc_no_currency = '01'
all tables are contained in the same database but i am unable to write these into the same scripts.
any help would be great
thanks Bleep
update "BAL_SHEET_DETAIL"
set ccy_cde = 2
where ccy_cde = 1
update "BAL_SHEET_DETAIL"
set ccy_cde = 1
where ccy_cde = 7
update "BANK_DIARY_FILE"
set accno_scurrency = '02'
where accno_scurrency = '01'
update "BANK_DIARY_FILE"
set accno_scurrency = '01'
where accno_scurrency = '07'
update "GENERAL_LEDGER"
set acc_no_currency = '02'
where acc_no_currency = '01'
all tables are contained in the same database but i am unable to write these into the same scripts.
any help would be great
thanks Bleep
