Select query from view in Unidata

Question

I want to perform the below SQL in Unidata

Select tab.col1, tab.col2 from (select col1, col2 from table1) tab;

Please help me for Unidata database

Just to confirm - this question is for https://www.rocketsoftware.com/products/rocket-unidata, not https://www.unidata.ucar.edu/ ? — Ian McGowan, May 27 '20 at 22:06

score 1 · Answer 1 · answered May 27 '20 at 21:41

1

This seems to be a bit redundant with the second select (select col1, col2 from table1).

Unidata would be:

LIST table1 col1 col2

-Arthur

answered May 27 '20 at 21:41

Arthur EM

46
2

Good point - the sql would seem equivalent to "Select tab.col1, tab.col2 from table1 tab;" – Ian McGowan May 27 '20 at 22:05
This is just an example. Actual SQL is much more complex for which this feature is absolutely necessary. Please let me know if there is any such feature. – Swastik Banerjee May 28 '20 at 20:27

score 0 · Answer 2 · answered Jun 04 '20 at 01:13

There is no native SQL interface to Unidata, but it's possible to run SQL against a Unidata database from Windows by setting up an ODBC datasource. It's not trivial and will take some work to do. If you go to the Rocket website and search for documentation, you'll end up here:

https://www.rocketsoftware.com/products/rocket-u2/documentation

And from there you'll want to drill down to "U2 Clients and APIs/Rocket U2 Clients and APIs U2 ODBC Developer Guide". Again, if this is not already setup for your environment, it's quite a bit of work to get going. If you can run native Unidata queries, that will be significantly easier. Look at the Uniquery reference manual for that.

Select query from view in Unidata

2 Answers2