RetrieveResultSet_SampleBOwithMcardChild.txt

Attribute name:RetrieveSP

Contains the parent business object Jdbctest_Customer and the multiple-cardinality child, Jdbctest_Address. The Jdbctest_Address business object uses fid, the primary key of the parent business object, as the foreign key attribute. Application- specific information of this attribute contains the following information: SPN=RetrieveAddress;RS=True;IP=CustomerID. RetrieveAddress is the name of the stored procedure that uses the foreign key attribute CustomerID as the only input parameter. Because RS is set to True, all the addresses for that CustomerID are returned in a result set. Note that output parameters cannot be part of the RetrieveSP attribute's application-specific information when a result set is returned. If RS is not set or is set to false , output parameters can be part of the application-specific information.

Copyright IBM Corp. 1997, 2003