Stack Overflow
Stack Overflow

Questions tagged [aqua-data-studio]

Aqua Data Studio is a SQL client/IDE

Homepage: http://www.aquafold.com/aquadatastudio.html

25 questions
3
votes
0 answers

Can I query across Multiple Servers in Aqua Data Studio?

I have multiple servers registered in Aqua-Data Studio (V16). Is it possible to query across 2 or more servers, similar to how you can used Linked Servers in MS-SQL Server ?
TomNChi
  • 31
  • 3
3
votes
2 answers

How to run multiple queries in row safely?

I have the below queries and i can run them one by one successfully, Delete from eventor.user_role ; Delete FROM eventor.role ; delete from eventor.user ; but when i run all of them together, it complains with the error: You have an error in your…
Jeff
  • 7,767
  • 28
  • 85
  • 138
2
votes
0 answers

Aqua data studio return wrong count affected rows

I connected to Sybase Ase 15.0.3 with Aqua Data Studio. Data base has drive version: installjdbc ---- jConnect (TM) for JDBC(TM)/7.00(Build 26502)/P/EBF17821/JDK16/Tue Apr 6 11:59:33 2010 ADS has driver: jConnect (TM) for JDBC(TM)/16.0 PL01…
Dmitry
  • 21
  • 2
2
votes
1 answer

How to keep the value from previous records

My original table 'T1' looks like this: ID Date Order_ind Var2 Var3 1 1/1/2015 1 ..... ..... 1 1/5/2015 1 ..... ..... 1 1/5/2015 2 ..... ..... 2 1/10/2015 …
Jenna
  • 75
  • 6
1
vote
0 answers

Is it possible to run query while debugging procedure in aqua data studio?

I found a documentation of SQL Debugger for Sybase ASE documentation of SQL Debugger for Sybase ASE But I want to run queries while I am stopping in breakpoint, using temp tables from the procedure, and vaiables from the procedure Is it possible?
M Barzel
  • 739
  • 7
  • 9
1
vote
2 answers

Tenure Calculation with TeraData SQL

List item I have been having the hardest time converting this T-SQL to TeraData SQL. Can someone assist me with this. I would really appriecate it. I am not understanding the convertion of dates with teradata. I am super confused. A fiscal Month…
CodeOfArms
  • 21
  • 4
1
vote
2 answers

aqua data studio mysql variable

How can I use variables in aqua data studio when connecting to a MySQL database? Here is a simple example: set @var = 1 select @var or set @var = 1; select @var; This results in the following error You have an error in your SQL syntax; check the…
MaxPowers
  • 474
  • 1
  • 4
  • 18
1
vote
2 answers

Aqua Data Studio UTF-8 Support ('é' shows as 'é')

Situation I have a lot of UTF-8 characters saved in a MySQL database. In PHP, I do this: SELECT name FROM institutions; The characters display correctly with no problems and no additional processing necessary within the query or within the PHP…
dokgu
  • 4,957
  • 3
  • 39
  • 77
1
vote
2 answers

Unable to get version of Oracle database

Finding version of Oracle database should be easy. As written here: How can I confirm a database is Oracle & what version it is using SQL? it's one command: select * from v$version; However it seems to be not working on some specific versions of…
Arkadiusz Kałkus
  • 17,101
  • 19
  • 69
  • 108
0
votes
0 answers

AquaData Oracle create procedure error 00900

I'm an Oracle newbie (SQLServer background) and I'm having a heck of a time creating a stored procedure to return a record set. The below code [names obfuscated, they're named better than that in real life...] seems to match other examples I've…
Ross
  • 11
  • 4
0
votes
1 answer

Counting days between two days excluding weekend (Saturday and Sunday) in hive sql

the problem is simple, I have two dates and count all days between them by using datediff() function. E.g.: datediff('23/08/2023', '30/08/2023') returns 7, but it should return 5, because 26-27/08/2023 are weekend days. Do You know any function or…
adann96d
  • 41
  • 4
0
votes
0 answers

Missing EOF in DELETE statement

I try to run this code, but I am getting an error: ParseException line 4:2 missing EOF at 'JOIN' near 'tf_posting' DELETE FROM ez_014315_tap.tf_posting JOIN ( SELECT MAX( FROM_UNIXTIME( …
adann96d
  • 41
  • 4
0
votes
0 answers

SQL Aqua Data Studio average over date by customer

I am trying to find the 3 day moving average for customers. Here is my attempt. SELECT CUSTOMER_ID, AUTH_DATE, AVG(AMOUNT) OVER(PARTITION BY CUSTOMER_ID, AUTH_DATE ORDER BY AUTH_DATE RANGE BETWEEN INTERVAL '3 DAYS' PRECEDING AND…
nicodemusmd
  • 5
  • 2
0
votes
1 answer

How to debug SQL stored procedure script

I am trying to create a temp table, adding accounts to temp table and getting eventid joining temp table and "contractactivity". I am using SQL stored procedure (Aqua Data Studio 7.0.39). This is what I have so far: DROP PROCEDURE Demo_Prod () …
tsunade
  • 1
  • 2
0
votes
1 answer

In Aqua Data Studio (ADS) can you save queries/open servers without using save all individually?

After a restart ADS will clear all servers/queries. There is a save all option but this is not efficient when it must go through often 50+ servers, saving them as separate files. Essentially I want to reopen my entire workspace on start (all servers…
David
  • 3
  • 4
1
2