Skip to Content
avatar image
Former Member

Can we use cluster tables in join?

Can we use cluster tables in table joins?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 15, 2008 at 09:16 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 09:37 AM

    hi,

    no you cannot use joins in cluster tables .

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

    thanks

    Sachin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 15, 2008 at 11:21 AM

    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

    Add comment
    10|10000 characters needed characters exceeded