topic Re: accessing data from PCL3 in Application Development and Automation Discussions

accessing data from PCL3

Former Member — Thu, 12 Feb 2009 10:29:56 GMT

Hi I am reading data from cluster table PCL3 using the SRTFD field .

am using the statement IMPORT IT_TEXT1 FROM DATABASE PCL3(AN) ID 'XYZ'.

but am not able to fetch the data

do i need to declare some includes for the same for buffer management ?

please help.

this statement is not working.

Re: accessing data from PCL3

suresh_datti — Thu, 12 Feb 2009 15:25:46 GMT

Yes, you will have to fill the following key to IMPORT the Applicant Notes from the PCL3 database cluster.

data: begin of al-key.
        include structure pc3al.
data: end of al-key.

Do an se16 on the table trmac for the macro rp-imp-c3-an & you sure will get an idea!

~Suresh

Re: accessing data from PCL3

Former Member — Fri, 13 Feb 2009 08:06:26 GMT

Hi Suresh

Very thanks for you reply.

I am not using macro macro rp-imp-c3-an for accessing data.

I am using import statement to fetch data from PCL3

but i am not getting the data although i am getting all the entries in the table using key field.

using export data base i am able to send data to pcl3 but i want to retrive the data using the index key store in the pcl3 table. i think data is stored some where else as only index key is available in tge pcl3 data base.

i wat to retrive that data.

Re: accessing data from PCL3

Former Member — Wed, 18 Feb 2009 12:34:18 GMT

Hi , i got the solution.

1) data IT_TEXT1 TYPE TABLE OF TXW_NOTE.

key = your key as per logic from pcl3

IMPORT IT_TEXT1 FROM DATABASE pcl3(an) ID key.

2) or you can also follow this technique

tables pcl3.

INCLUDE rpc3an00.*

rpc3(for plc3 cluster)an(cluster i want to read)00

IMPORT notes FROM DATABASE pcl3(an) ID key.

I tried second solution on one system it is working fine, on other system its not working i do not know why.

but first solution is working for all system