topic Re: How to access data from Cluster table....? in Application Development and Automation Discussions

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

Former Member — Wed, 10 Jan 2007 10:06:43 GMT

Hi Experts,

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

Thanx in advance.

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

Former Member — Wed, 10 Jan 2007 10:09:14 GMT

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.

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

Former Member — Wed, 10 Jan 2007 10:09:16 GMT

refer link.

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

former_member188829 — Wed, 10 Jan 2007 10:09:37 GMT

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.

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

rahulkavuri — Wed, 10 Jan 2007 10:12:00 GMT

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.