Stack Overflow
Stack Overflow

Questions tagged [dbvisualizer]

DBVisualizer is a popular database tool by DbVis Software AB. Written in Java, it runs on Windows, Mac OS X, and Unix/Linux, and will connect to any JDBC enabled database server.

DBVisualizer is a popular database tool by DBVis Software AB. Written in Java, it runs on Windows, Mac OSX, and Unix/Linux, and will connect to any database server.

214 questions
0
votes
1 answer

Cannot connect to Redshift using dbVisulizer - SSL error (from Mac OS)

When I try to connect I get this error: PKIX path building failed: unable to find valid certification path to requested target I downloaded the certificate from this page and added it to KeyChain Access as you can see I tried disabling ssl on the…
rmcsharry
  • 5,363
  • 6
  • 65
  • 108
0
votes
1 answer

Issue with running a DB2 Script from DataStage Job

I have a DB2 script as below - BEGIN DECLARE var1 INTEGER; DECLARE var2 INTEGER; SET var1=<>; SET var2=<>; BEGIN WHILE (var1 <= var2) DO DELETE FROM (SELECT * FROM table_name WHERE ID >= var1 FETCH…
Abhishek.Roy
  • 11
  • 4
0
votes
0 answers

Unable to convert string to number on Redshift

I'm running this code in an Amazon Redshift query: case when offer.disbursement_required = 'true' and (json_extract_array_element_text(offer.disbursement_requirements, 2, true) :: numeric <> offer.amount or…
Prathyusha
  • 1
0
votes
0 answers

How to insert multiple rows using standalone procedure in dbviz

I want to fetch data from student and teacher tables and insert into another table. but when I try to do that I am getting below error @delimiter %%%; BEGIN DECLARE name CHAR (3); DECLARE subject VARCHAR(25); DECLARE ID DECIMAL(19,0); DECLARE…
Subathra
  • 13
  • 5
0
votes
0 answers

Insert Clause and receiving error for NULL value into column

Trying to create a lookup to run an import for a file into the database, and within the query I created that would insert an address from the import file if it was not found, I am getting the Error Code 515 stating that it "cannot insert the value…
iLoveSQL10
  • 1
  • 1
0
votes
2 answers

Exasol_Error: I keep getting Exasol connection error timed out

I am trying to connect to my Exasol SaaS database, I tried via these tools(TALEND, DBVISUALIZER, POWERBI) and via python but I cannot connect and I keep getting the same error. I saw another post on Exasol community…
Josh2187
  • 13
  • 2
0
votes
0 answers

how to copy hive table data from production to stage environment. using DBVisualizer or DBeaver

I have a transactional table in hive production server. It contains almost 10M rows. I want to copy this table data to hive stage server to test scenarios. We are using DBVisualizer and DBeaver to connect to Hive. Please let me know if there is any…
Hari Ch
  • 5
  • 2
0
votes
1 answer

Soda Core | checks.yml for all Tables in Database

Goal: run checks.yml on all Tables in Database, implicitly / dynamically (not naming 100s of Tables). Following Soda's quick start, I've completed sections: Install Soda Core Connect Soda Core to a data source - configuration.yml Now I'm following…
DanielBell99
  • 896
  • 5
  • 25
  • 57
0
votes
1 answer

How to create a new column using existing column in SQL Redshift

I am trying to create a new column in SQL with certain conditions in DBVisualizer by connecting redshift data source. I used the following command to achieve the results but getting syntax error. I would be really grateful for any help. Code: select…
Anamta sayyed
  • 41
  • 9
0
votes
1 answer

how to pull data from a table based on date ranges?

Is it possible to have a sql query which pulls data per date and customer? Use case: Table 1 has items purchased by customers, with data of purchase Table 2 has all of the support tickets customers may have reached out for. I am looking to filter…
msulol
  • 67
  • 6
0
votes
1 answer

SQL need to compare rows count values

I have a query that returns the ID, Name and count of the number of times an ID has been entered to the table. SELECT ID, NAME, COUNT(*) count FROM TABLE GROUP BY NAME, ID, CASE_DETAIL_ID HAVING COUNT(*) > 1; This returns…
AmachineR
  • 13
  • 6
0
votes
1 answer

Declaring variables for Oracle SQL in dbVisualizer

Using an Oracle database (currently 18g) through dbVisualizer, I have SQL that has parameters peppered throughout. Some of the parameters are in multiple places. The query I'm working with right now has 13 distinct parameter names with 56 total…
dougp
  • 2,810
  • 1
  • 8
  • 31
0
votes
1 answer

I want to copy existing table from one schema to another without changing anything

I am trying to copy 1 table from 1 schema into another schema in non existing table using DBVizualizer or SQL Developer. Also if possible just for testing purposes will need example how to copy 1 table into another (non existing table) in the same…
Atanas Nedelchev
  • 5
  • 1
0
votes
0 answers

DBVisualizer ERRORCODE=-4214, SQLSTATE=28000 Password expired

Connecting to DB2 LUW 11.5 database (running on docker) since a few days I got the following: An error occurred while establishing the connection: ERRORCODE=-4214, SQLSTATE=28000 Password expired the connection to a postgresql database via Davis…
Oliver
  • 13
  • 5
0
votes
3 answers

IF statement is not accepted in MySQL trigger, issuing Code 1064 but no reference into the statement

I'm using MariaDB (10.3.29-MariaDB-0+deb10u1) and DbVisualizer (Pro 12.1.1 [Build #3237]) as an IDE. I want to manage the primary key of a table by having MariaDB set the key to a UUID, I started with this CREATE TRIGGER …
user3481644
  • 398
  • 2
  • 12
1 2 3
…
14 15