Export information from PCL2 to an external dataware house for productivity reports

[virgilioruiz]

Dear colleagues,

Currently we are facing a requirement from a customer in Mexico, consisting in the export to an external dataware house of the informacion related with the PCL2 table that is ciphered (in particular with the content related with WPBP, RT, C1, BT tables), to provide some productivity reports. This information should be consolidated in order to provide a readable and useful information.

Have you done something similar?

Thanks for your support.

[johnatan_gomez]

Hello VIrgilo,

I agree with Amilcar (again).. declustered tables is "easier" in your case.. another option is a export program (Z Program). There is some functions that you can user to read those cluster/tables.

Regards!

Johnatan