You are not logged in.

Internal derby database - read schema and tablenames

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

dmarkovic

Master

  • "dmarkovic" is male
  • "dmarkovic" started this thread

Posts: 90

Date of registration: Aug 11th 2011

Location: Vienna / Austria

Occupation: Vector SW DV GmbH

  • Send private message

1

Tuesday, March 6th 2012, 12:49pm

Internal derby database - read schema and tablenames

Hi,

i need to see the tables and tablenames in the internal derby database, so i write this statement (i hope this should be availible in the next ETL Version).

Source code

 
1
2
3
4
5
6
7
8
9

select 
   s.SCHEMANAME as "Schema"
  ,t.TABLENAME as "Table"
from SYS.SYSTABLES t
  inner join SYS.SYSSCHEMAS s
    on t.SCHEMAID = s.SCHEMAID
where 1=1
   and t.TABLETYPE = 'T'
order by 1,2


1) make a connection to the internal derby
2) make a relational extract and execute the statement

Regards.
dmarkovic has attached the following image:
  • derby_schema_and_tablename.JPG
Djordja Markovic
Vector SW DV GmbH

Interessant things:
Internal derby:
http://www.jedox.com/community/palo-foru…14338#post14338
Calculate your cube size:
http://www.jedox.com/community/palo-foru…14406#post14406

This post has been edited 1 times, last edit by "dmarkovic" (Mar 7th 2012, 11:41am)

Similar threads

Used tags

derby, derby history, etl persistence, history, internal derby, persistence, schema, systables, table, tablenames

Rate this thread