Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Support of InterSystems IRIS VIEW definition #18437

Open
amirsamary opened this issue Dec 5, 2022 · 2 comments · May be fixed by #33183
Open

Support of InterSystems IRIS VIEW definition #18437

amirsamary opened this issue Dec 5, 2022 · 2 comments · May be fixed by #33183
Labels
environment external feature request xf:metadata xp:normal

Comments

@amirsamary
Copy link

Description

When using DBeaver with InterSystems IRIS and asking to see the definition (source code) of a view, we get nothing:

image

DBeaver Version

Community 22.3.0

Operating System

Mac and Windows

Database and driver

InterSystems IRIS 2022.2

Steps to reproduce

Create a simple view in InterSystems IRIS
Connect DBEaver to the namespace
Ask to see the definition of the view

Additional context

No response
@LonwoLonwo
Copy link
Member

Hello @amirsamary

Because it is not supported yet, if you know the query to get the view definition from a database - please, share it with us.

@LonwoLonwo LonwoLonwo changed the title When asking to see an InterSystems IRIS VIEW, we get nothing Support of InterSystems IRIS VIEW definition Dec 5, 2022
@bdeboe
Copy link

bdeboe commented Dec 5, 2022 •
edited

Currently this has to go through an ObjectScript API call: %SYSTEM.SQL.Schema:ExportDDL(). We can call this through the com.intersystems.jdbc.IRIS:classMethodStatusCode() method on the JDBC driver

I forgot the much easier alternative available from the catalog views:

SELECT View_Definition
FROM INFORMATION_SCHEMA.VIEWS
where TABLE_NAME='AssetBreakDown' and TABLE_SCHEMA='halp_view'

Thanks @amirsamary for refreshing my memories! ;-)

adaptun added a commit to adaptun/dbeaver that referenced this issue May 16, 2024
@adaptun
dbeaver#18437 Support of InterSystems IRIS VIEW definition
5655264 
To implement getViewDDL I added a plugin for InterSystems IRIS
@E1izabeth E1izabeth linked a pull request May 16, 2024 that will close this issue
dbeaver/dbeaver#18437 Support of InterSystems IRIS VIEW definition #33183
Open
adaptun added a commit to adaptun/dbeaver that referenced this issue May 28, 2024
@adaptun
dbeaver#18437 Removed unnecessary logging and simplified pom
1c201d0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
environment external feature request xf:metadata xp:normal
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

dbeaver/dbeaver#18437 Support of InterSystems IRIS VIEW definition adaptun/dbeaver
4 participants
@amirsamary @bdeboe @E1izabeth @LonwoLonwo