PSQL V10 nested procedures
PSQL V10 nested procedures
(OP)
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
RE: PSQL V10 nested procedures
What error are you getting?
Have you tried adding a semicolon ( ; ) or pound ( # ) at the end of each statement.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: PSQL V10 nested procedures
Sorry forgot to say that i was using PSQL. The reason i want no net this is to ensure that the person that i running these changes does so in the correct order instead of running the cmd's 1 at a time and maybe missing one of them out.
Thanks
Bleep
RE: PSQL V10 nested procedures
What error / behavior are you seeing?
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: PSQL V10 nested procedures
RE: PSQL V10 nested procedures
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com