Data Types or Data Tables or Data Storage

<<Back

·         Data tables are just like relational Database tables but these are been created from Designer studio of PRPC.

·         Data Tables are deprecated from version 7, and these now called as Data Storage Rules.

·         When we create a Data Table it creates a table class under data layer.

·         The columns of the Data table will be created as properties under table class…

·         A Data Storage class should inherit from the OOTB class ‘Data-‘.

·         All the Data Storage classes are “Does not belong to a class group”, that means these classes are global classes and can be accessed from any of the class groups in our application.

·         When we create a Data Storage, it creates a physical table in the “Rulebase”. The name of physical table will be like PR_DataStorageClass.

·         For example, if Data Storage class is BOA-BANK-DATA-STATES then the physical table name will be PR_BOA_BANK_DATA_STATES…

·         Data Storage class will be connected to this physical table from PRPC application.

If we want access the Data Storage Columns, we need to access the properties of Data Storage Class.

·         When the physical table gets created in the Rulebase, this table will not have the columns that we create for Data Storage Rule instead it maintains all the Data storage columns into one single column in BLOB (Binary Large Objects) format.

·         This column name is “PZPVSTREAM”.

·         The Primary key column of the Physical table is “PZINSKEY”.

·         PZINSKEY is the combination of “CLASSNAME <SPACE> PRIMARY KEY of the Data Storage Rule”.

·         We can perform the below operations on Data Storage Rules.

o   Insert

o   Update

o   Fetch

o   Delete.

·         In order to query Data Storage, PRPC provides the below predefined methods in Activity.

1)      Obj-Browse: - This method is used to fetch multiple records (Rows) from the Data Storage.

2)      Obj-Save: - This method is used insert or Update Data to Data Storage.

3)      Obj-Open: - This methods fetches single record based on primary key.

4)      Obj-Open-By-Handle: - This method fetches single record based on pzinskey.

5)      Obj-Delete: - This method is used to Delete Data from Data Storage rules.

6)      Commit: - This method commits data to the data storage.

7)      Rollback: - This method rolls back uncommitted data.

8)      Obj-Save-Cancel: - This method rolls back latest uncommitted Obj-save.

·         Data Storage or Data Type can be created under Data Explorer.

While fetching data, PRPC application request DB directly. DB put the data on clipboard page. Application will access from clipboard