4.2 Data Source Properties

This topic describes the data source properties.

Provide properties of the created data source.

Data Source: This is a read only field. Data source name will be defaulted to this field.

Master: This filed identifies whether this data source is the master data source for the screen. Every screen should have one (and only one) master data source.

Relation Type: Relation type can be selected for the selected data source with the parent, One To One or One To Many. The relation should be one-to-many if the parent data source is Single Record entry and child data source is Multi Record.

Multi Record: This field tells about the type of data source in the screen, whether it is multiple Entry record or the single Entry Record data source, Select the field value Yes or No accordingly. Master Data source cannot be of multi record type.

Pk Cols & Pk Type: PK Cols and PK types are mandatory. Provide the Primary key columns of the data source separated by tilde (~) in PK Col field and its corresponding data types in PK Col field(also separated by tilde)

Example: If Pk Cols are CONTRACT_REF_NO (VARCHAR2) and VERSION_NO(NUMBER), Pk Col can be provided as CONTRACT_REF_NO~VERSION_NO and Pk Type can be provided as VARCHAR2~NUMBER

Parent: Parent data source has to be mentioned for all data sources except the master data source. Select List provides all the data sources created till that point .Developer can choose the data source from the list. For master data source, parent should not be provided.

Relation: Relation with parent has to be specified for all data sources except master data source. Keep the parent data source in the left side of the relation.

Example: If parent is STTM_CUSTOMER and child is STTM_CUST_ACCOUNT; and relationship is based on CUSTOMER_NO and BRANCH_CODE, it has to be provided as STTM_CUSTOMER.CUSTOMER_NO= STTM_CUST_ACCOUNT.CUSTOMER_NO AND STTM_CUSTOMER.BRANCH_CODE= STTM_CUST_ACCOUNT.BRANCH_CODE 22 Note that relationship can be only with parent maintained and the current data source; a third table cannot be introduced in the relationship. Only simple Relational operators and equal to can be used in the relationship.

Where Clause: This is an optional field. If only selected records of a particular data source is required, then where clause can be provided. Keyword WHERE need not be provided.

Example: Where clause can be given as BRANCH_CODE=GLOBAL.CURRENT_BRANCH The values of where clause field will be used in generating the query statements for current data source. During query of the record, this clause will be added in fn_sys_query of the generated main package.

Parent topic: Data Sources