Skip to Content
author's profile photo Former Member
Former Member

How to access data from Cluster table....?

Hi Experts,

Can You plz tell How to import/read data from cluster table? Plz give me the syntaxes also..

Thanx in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 10:09 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 10:12 AM

    Types of TABLES and the differences

    Transparent tables

    Pool tables

    Cluster Tables

    From the user point of view, all tables are used to store data and there is no difference in behavior or operation of these tables. All of them can be managed by using the standard OPEN SQL. However from the administrator point of view, transparent tables do exists with the same structure both in the directory as well as the database, exactly with the same data and fields. While other two are not transparent in the sense that they are not manageable directly using database system tools. We cannot use Native SQL statements on these tables. These are logical tables, which are arranged as records of transparent tables.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 10:09 AM

    hi

    u cant use inner join on cluster tables.

    so first u select the data into one internal table of cluster table.

    and then u use for all entries concept.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 10, 2007 at 10:09 AM

    i think

    we have to use for all entries .

    by using join statement it is not possible.

    if there is any wrong let me know.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.