Application-specific information at the business-object level

Application-specific information at the business-object level allows you to:

At the business-object level, application-specific information format consists of parameters separated by colon (:) or semicolon (;) delimiters:

TN=TableName; SCN=StatusColumnName:StatusValue
   

where TableName identifies the database table, StatusColumnName is the name of the database column used to perform logical deletes, and StatusValue is the value that signifies that a business object is inactive or deleted.

For example, assume that a Customer business object has the following value specified for its business object application-specific information:

TN=CUSTOMER; SCN=CUSTSTATUS:DELETED
   

Assume also that the connector receives a request to delete the customer. Such a value causes the connector to issue the following SQL statement:

UPDATE CUSTOMER SET CUSTSTATUS = 'DELETED' WHERE CUSTOMER_ID = 2345
   

If the SCN parameter is not included or no value is specified for it, the connector physically deletes the business object from the database. In other words, if the business object with the Delete verb includes the SCN parameter in its application-specific information, the connector performs a logical delete. If the business object with the Delete verb does not include the SCN parameter in its application-specific information, the connector performs a physical delete.

Both update and delete operations may use the value of the SCN property:

At the business-object level, application-specific information may be used to specify a wrapper:

WRAPPER=true|false
   

If the wrapper parameter is set to true, the top-level business object is a wrapper object. The wrapper object is not represented by a database table or view. A wrapper is used as a container for unrelated business objects. The connector ignores the top-level object and processes only the children. The wrapper object may contain N cardinality or N-1 cardinality entities or both.

Copyright IBM Corp. 1997, 2003