topic Re: reading clusters in Application Development and Automation Discussions

reading clusters

Former Member — Wed, 06 Jun 2007 06:14:52 GMT

i am using payroll clusters.

how can i read ' wpbp ' cluster.

what macreo shud i use?

Re: reading clusters

Former Member — Wed, 06 Jun 2007 06:21:13 GMT

HI,

Cluster tables combine the data from several tables with identical (or almost identical) keys into one physical record on the database.

Data is written to a database in compressed form.

Retrieval of data is very fast if the primary key is known.

Cluster tables are defined in the data dictionary as transparent tables.

Special language elements EXPORT TO DATABASE, IMPORT TO DATABASE and DELETE FROM DATABASE are used to process data in the cluster tables.

http://fuller.mit.edu/hr/cluster_tables.html

Regards

Sudheer

Re: reading clusters

former_member214288 — Wed, 06 Jun 2007 06:31:38 GMT

Hi Nidhi,

Cluster Table in which WPBP is stored is PCL2. You can use the following statement to import data. Note that we cannot fetch data from Cluster tables using Select Statements. Data can be fetched only using Import Statement.

IMPORT B2-VERSION TO OB2-VERSION
       WPBP
FROM DATABASE PCL2(B2)
ID B2-KEY.

Report RPCLSTB2 fetches data from WPBP Cluster. You can refer to this program.

Do Reward points if helpfull and close this question as answered.

Regards,

Ram

Re: reading clusters

Former Member — Wed, 06 Jun 2007 06:47:47 GMT

good

WPBP

Table WPBP contains data on the employee’s work center and basic pay.

Try with macro RP-EXP-C2-B2

thanks

mrutyun^

Re: reading clusters

Former Member — Wed, 06 Jun 2007 07:07:14 GMT

Hi,

You can read the payroll cluster with the logical database PNP. Take a look at Report EXAMPLE_PNP_GET_PAYROLL and it's documentation. It's self-explanatory.

Regards