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

[Former Member]

Hi Experts,

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

Thanx in advance.

[Former Member]

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.

[Former Member]

refer link.

[former_member188829]

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.

[rahulkavuri]

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.