Show DB2 Tables in Oracle SQL Developer
UPDATE: If anyone knows a tool that is free, and would display, and let me edit DB2 table data stored on a Zos System, I welcome that as an answer too. Really all I'm trying to do is find a nice windows GUI interface to avoid using the 3270 environment.
I'm connecting to a DB2 database with Oracle SQL developer. There's several tables in the database, but I don't see them listed when I start the connection, or make a query.
I'm using a DB2 on zOS and I've got the connection with the following 2 drivers db2jcc.jar db2jcc_license_cisuz.jar
Does anyone know if this is something I have to live with, or is there something I am missing to show all the tables? Also, if people know why I can't edit in-line query results, that'd be awesome to. They seem to be read only.
FYI, schema browser doesn't allow me to do anything either.
At work we use DbVisualizer. Your mainframe DBA's will need to give your account you are connecting with privileges to see the system catalogs.
- How to sort all numbers before letters with linguistic sorting?
- How to add multiple columns in AWS redshift with alter table query
- Time and Attendance query, First transaction of the day per person
- Filter out rows in 1:N LEFT JOIN where any row in child table fails condition
- SQL query left join with sum,group by and order by in MS Access
- Update an existing sql table based on content from an external csv file?
- SQL Formatting a string (name)
- Oracle Sql Statement for unique timestamp for each row
- winMySQL query fails on Ubuntu instance but works with Windows instance
- How do I suppress T-SQL warnings when running a script SQL Server 2005?
- How can I group time by hour or by 10 minutes?
- SQL syntax error when trying to create a new table using TypeORM
- How to use PERCENTILE_CONT without over clause? any alternative to it?
- Success message for an end user inside an SQL procedure
- Does Oracle field contain all letters from a string?
- SQL count occurrences based on values in other columns
- How to declare a variable in MySQL?
- Forward fill NULL values in multiple columns
- SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
- PostgreSQL EXISTS in user-defined function always returning true
- Count number of orders for a variation in Woocommerce
- count the number of preliminary and final invoices for each customer
- Extracting valid timestamps in SQL
- MySQL union - alias not visible
- Find values that are 6 characters long in a string, pipe delimited
- How to write this SQL query to find each account balance?
- SQL Query to get latest price
- Join newest price from price-table for all products
- Order By In a SQL Table Valued Function
- Return columns with a single value