cancel
Showing results for 
Search instead for 
Did you mean: 

Can we use cluster tables in join?

Former Member
0 Kudos

Can we use cluster tables in table joins?

Accepted Solutions (1)

Accepted Solutions (1)

MarcinPciak
Active Contributor
0 Kudos

As far as I know cluster tables can be read using IMPORT statement, macros, or specific FMs. You can't extract them directly using simple SELECT, thus joining is not allowed here two.

Nevetherless you are able to do join on internal tables which stores already extracted cluster tables. PROVIDE statement is the one to be used here.

Answers (2)

Answers (2)

Former Member
0 Kudos

No,you can not use inner join to transparent

table and cluster table.System will generate an error whenever you try to join the table.

Edited by: Smita Gupta on Oct 15, 2008 1:22 PM

Former Member
0 Kudos

hi,

no you cannot use joins in cluster tables .

u can use select statements in cluster table but it will degrade performance

thanks

Sachin