retrieve table names from derived table's SQL (or in general

sdk development
1

Hi,

Can we retrieve all table names used within derived table’s SQL (or in general any SQL - ANSI or other)?

Appreciate your help.

Thank you,
Gaurav

gauravsays :india: (BOB member since 2009-12-01)

2

If its DeskI report then check the List objects in a report utility from BOB downloads or WID scanner for webI reports
You can as well check the DataproviderSQL function in DeskI
.

haider :es: (BOB member since 2005-07-18)

3

Hello,

I should have been little clear :hb: :oops:

for e.g. if there is a derived table “User activity” in universe “SLT.unv” that has SQL like “slect * from emp LEFT OUTER JOIN dept ON edeptno = ddeptno”

than the macro should list two tables emp, dept as output.

the macro repeats for all derived tables in the universe.

Hope this makes my query clear

Best regards/Gaurav

gauravsays :india: (BOB member since 2009-12-01)

4

You may have to improvise on the VBA code(can be found in SDK section or the list objects utility) to read the derived table code in the generated SQL
.

haider :es: (BOB member since 2005-07-18)