on 10-15-2008 10:01 AM
Can we use cluster tables in table joins?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
no you cannot use joins in cluster tables .
u can use select statements in cluster table but it will degrade performance
thanks
Sachin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.