The directives listed in this section are used when connecting to an Enterprise Geodatabase Feature Class.
These directives are not applicable for writing to raster datasets in an Enterprise Geodatabase.
VERSION
Required/Optional: Optional
The name of the version to which features should be written (only applicable on multi-versioned databases).
Parameter: <version>
Workbench Parameter: Transactional Version
Example:
GEODATABASE_SDE_VERSION jim.testversion
RECONCILE_AND_POST
Required/Optional: Optional
This optional directive reconciles all the changes between the version specified by the writer directive VERSION and its parent version, even those edits made outside of the current translation, and then posts the version to its parent. The reconcile and posting is done at the end of the translation when the Geodatabase writer is being shut down. As a result, if an error occurs during the reconcile or post, then only the reconcile and post changes are undone; all the features that were inserted/updated/deleted prior are still saved. The reconcile and post will only be successful if no conflicts are found. Conflicts must be resolved manually using ESRI’s ArcGIS. Upon a successful post, the child version will be deleted or left intact depending on the value of the DELETE_CHILD_AFTER_RECONCILE_AND_POST directive.
Since reconciling is done for all features including those inserted/updated/deleted outside the current translation, then this directive can be used in an empty workspace to simply reconcile and post a child version to its parent. Since this directive reconciles and posts the version specified by VERSION, the value for VERSION must not be SDE.DEFAULT because SDE.DEFAULT has no parent version. When reconciling and posting, the TRANSACTION_TYPE directive must be set to VERSIONING.
Parameter: <reconcile_and_post>
Values: YES | NO
Default Value: NO
Workbench Parameter: Reconcile and Post
Example:
GEODATABASE_SDE_RECONCILE_AND_POST YES
DELETE_CHILD_AFTER_RECONCILE_AND_POST
Required/Optional: Required
This directive determines whether to delete the child version following a reconcile and post, including the case where the child and parent version are identical. A value of ‘YES’ will delete the child version, while a value of ‘NO’ will leave it intact. The default value is ‘YES’.
Parameter: <delete_child_after_reconcile_and_post>
Values: YES | NO
Default Value: YES
Example:
In the example below, the child version will not be deleted after the reconcile and post operation completes.
GEODATABASE_SDE__DELETE_CHILD_AFTER_RECONCILE_AND_POST NO