Thanks Mirtheil with your advice i have now got it working correctly. Do you know if there are any tools to be able to run sql scripts from the command line for PSQL or are we stuck with running through the pcc
Hi Mirtheil
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.