webMethods, OneData, and Terracotta  10.2 | Managing Master Data with webMethods OneData | Implementing webMethods OneData | Objects in OneData | Creating An Object For A View
 
Creating An Object For A View
 
Best Practices for Creating a View
OneData supports views that are created in the relational database. You can import these views in OneData (using Update Schema functionality) and can configure as data objects. OneData requires an existing object to be identified as the base table in a view. This object is used to insert the values into the view.
While creating a view, include audit columns from at least one table that is used to create the view. The audit columns are:
*CREAT_DT
*LST_UPD_DT
*CREAT_USR_ID
*LST_UPD_USR_ID
*LST_DEL_DT
*S2P_TRN_DT
*FLD_DELETE
To include the audit columns, run an update schema on the base object that automatically creates the audit columns. Create the view after the base object is in the metadata. If the base object is not going to be in OneData, set the following defaults in the view.
Audit Column
Default Value
CREAT_DT
sysdate
LST_UPD_DT
sysdate
CREAT_USR_ID
‘ ‘
LST_UPD_USR_ID
‘ ‘
LST_DEL_DT
sysdate
S2P_TRN_DT
sysdate
FLD_DELETE
0

Copyright © 2011-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release