connect to DB2 directly due to more complex SQL queries

Closing based on recent Discussion Paul had with Airbus team. This RFE no longer needed

Hello Tom,

Here's another query that may be complex in SQL:

"Show all tags that have been applied to one or more given files"

Due to the fact that every tag in the database has its own table it's easy to get a tag and its value when we provide an fkey and a tag. But when we want to know what tags have been applied for a given file we need to check every <T_> table if it contains the given fkey/fkeys. Is there a simpler and more efficient way to do this? Maybe as a stored procedure or as a summary table that contains all tags for every fkey?

Thanks

Fred2

Hello Thomas,

We're working on a REST API that will communicate with DB2 in the backend.

Some possible queries:

Select only entries in table metaocean that are not in table t_uuid joining on column fkey in both tables:

SELECT mo.fkey FROM metaocean mo LEFT JOIN t_uuid id ON mo.fkey = id.fkey where id.fkey is NULL

Select all entries whose column owner contains numeric values only:

SELECT uid,owner,filename FROM metaocean WHERE datasource IN('de0_svm05_v19:/vol/de0_svm05_v19/A330_Transpose') AND REGEXP_LIKE(owner , '^\d+$')

Python code: Get number of files per given datasources grouped by datasource:

my_datasource = "'datasource1','datasource2','datasource3'"

sql = f"select count,datasource from metaocean where datasource in ({my_datasource}) group by datasource order by count"

Our database will easily grow up to 30 to 40 billion entries in the next couple of weeks. When using the REST endpoint db2whrest we often get HTTP timeouts due to long running queries.

Thanks

Fred2

Can you please provide a few exmples of complex SQL queries you are trying to run