Log-In to post
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
this script will not run in Toad but in HANA Studio:
select x."Payback period in year", case when x."Payback period in year" > 0 and x."Payback period in year" <= 1.5 then '1' when x."Payback period in year" > 1.5 and x."Payback period in year" <= 2.5 then '2' else 'x' endfrom TOP_INVESTMENTS x
And I get not error message / number in Toad from HANA
There is a problem with Toad for SAP which causes issues during production releases which had DDL changes.
How to reproduce:
1, Open Toad -> and connect to a Sybase IQ server via Connection manager
2. Go to View- > Object Explorer.
Now Check for table locks by using sp_iqlocks. You will see shared locks on ALL tables on the server, across all schemas.
Thus, if someone has a Toad session open during the release, any DDL on a tables such as alters, will fail with a table is in use error.
I don't understand why Toad needs to lock all tables .
We have many Toad sessions connected, and this is not feasible for us to control everyone and tell them not to use Toad during the release.
Has anyone come across this issue and do you have solution ?
Version : Licensed Toad for SAP 3.1.0 bugs 1109