A DataStore collaboration object copies business objects into a database table.
The database table must consist of two columns with the suggested names of ObjectKey and ObjectData. Specify values for these columns as shown in the table below. ObjectKey must be specified as a unique key for the table. If the database allows specification of the length of ObjectData, choose a value larger than the maximum anticipated length of the XML representation of the GBO being serialized. This value will vary according to the GBO being stored.
Column name | DB2® data type | Microsoft® SQL Server data type | Oracle data type |
---|---|---|---|
ObjectKey | VARCHAR (length =255) if the value of the DataStore collaboration
object's GENERATE_KEY configuration property is false. Integer if the value of GENERATE_KEY is true. |
VARCHAR (length =255) if the value of the DataStore collaboration
object's GENERATE_KEY configuration property is false. Integer if the value of GENERATE_KEY is true. |
VARCHAR (length =255) if the value of the DataStore collaboration
object's GENERATE_KEY configuration property is false. Integer if the value of GENERATE_KEY is true. |
ObjectData | CLOB | TEXT | CLOB |
Parent topic: Setting up the Datastore collaboration object