Forums - - Toad for SAP Solutions - Toad World
Danny Torres
Follow / 1 Nov 2016 at 2:16pm / Toad for SAP Solutions

We are now on Twitter!!! Contact a Technical Support expert today

Expand content
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

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

515 0 / Create an account to join the discussion.
Danny Torres
Follow / 1 Nov 2016 at 2:06pm / Toad for SAP Solutions

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
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

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

488 0 / Create an account to join the discussion.
Danny Torres
Follow / 1 Nov 2016 at 2:05pm / Toad for SAP Solutions

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
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

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

496 0 / Create an account to join the discussion.
h.blum
Follow / 3 Mar 2017 at 8:53am / Toad for SAP Solutions
Latest post by on 10 Apr 2017 at 12:08pm

Script not running in Toad but in HANA Studio

Expand content
Hi, 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"...

Hi,

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'
end
from TOP_INVESTMENTS x

And I get not error message / number in Toad from HANA

Holger

Unanswered 397 8 / Create an account to join the discussion.
AzaMull
Follow / 14 Mar 2017 at 6:41pm / Toad for SAP Solutions
Latest post by on 29 Mar 2017 at 2:03am

Tables are locked by 'Toad for SAP 3.1.0.bugs.1109' when using...

Expand content
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...

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

Unanswered 294 4 / Create an account to join the discussion.