COAMGMT Apply Updates

    RM_VERSION_PROP.IDXPROPVER02
    RM_WF_MODEL.IDXWORKFLOWMODEL01
    RM_WF_MODEL_STAGE.IDXWFMODELSTAGE01
    RM_WF_REQUEST.IDXWFREQUEST01
    RM_WF_REQUEST.IDXWFREQUEST02
    RM_WF_REQUEST.IDXWFREQUEST03
    RM_WF_REQUEST.IDXWFREQUEST04
    RM_WF_REQUEST.IDXWFREQUEST05
    RM_WF_REQUEST.IDXWFREQUEST06
    RM_WF_REQUEST_ACTIVITY.IDXWFREQUESTACTIVITY01
    RM_WF_REQUEST_ACTIVITY.IDXWFREQUESTACTIVITY02
    RM_WF_REQUEST_ASSIGNED_TO.IDXWFREQUESTASSIGNEDTO01
    RM_WF_REQUEST_ASSIGNED_TO.IDXWFREQUESTASSIGNEDTO02
    RM_WF_TASK.IDXWORKFLOWTASK01

  Adding primary keys ...

    DAL_SEQUENCE.PK_DALSEQUENCE
    DAL_UPDATES.PK_DALUPDATES
    RM_ACCESS_GROUP_CTRL_HIER.PK_RMACCESSGROUPCTRLHIER
    RM_ACCESS_GROUP_DEFINITION.PK_RMACCESSGROUPDEFINITION
    RM_ACCESS_GROUP_PROP_GLOBAL.PK_RMACCESSGROUPPROPGLOBAL
    RM_ACCESS_GROUP_PROP_LOCAL.PK_RMACCESSGROUPPROPLOCAL
    RM_ACCESS_GROUP_USER.PK_RMACCESSGROUPUSER
    RM_BLENDER.PK_RMBLENDER
    RM_BLENDER_DEFAULT_PARAM.PK_RMBLENDERDEFAULTPARAM
    RM_BLENDER_HIERARCHY_SET.PK_RMBLENDERHIERARCHYSET
    RM_BLENDER_PROPERTY_LIST.PK_RMBLENDERPROPERTYLIST
    RM_BLENDER_PROPERTY_LIST_ITEM.PK_RMBLENDERPROPERTYLISTITEM
    RM_BOOK.PK_RMBOOK
    RM_BOOK_DEFAULT_PARAM.PK_RMBOOKDEFAULTPARAM
    RM_BOOK_ITEM.PK_RMBOOKITEM
    RM_CATEGORY.PK_RMCATEGORY
    RM_CATEGORY_USER.PK_RMCATEGORYUSER
    RM_COMPARE.PK_RMCOMPARE
    RM_COMPARE_DEFAULT_PARAM.PK_RMCOMPAREDEFAULTPARAM
    RM_COMPARE_ITEM.PK_RMCOMPAREITEM
    RM_CONFIG_INFO.PK_RMCONFIGINFO
    RM_CONNECTION.PK_RMCONNECTION
    RM_CONNECTION_ALLOWED_TABLE.PK_RMCONNECTIONALLOWEDTABLE
    RM_DERIVED_PROPERTY.PK_RMDERIVEDPROPERTY
    RM_DERIVED_PROPERTY_PARAM.PK_RMDERIVEDPROPERTYPARAM
    RM_DOMAIN.PK_RMDOMAIN
    RM_DOMAIN_NODE.PK_RMDOMAINNODE
    RM_DOMAIN_VALIDATIONS.PK_RMDOMAINVALIDATIONS
    RM_DOMAIN_VERSION.PK_RMDOMAINVERSION
    RM_ENGINE_INFO.PK_RMENGINEINFO
    RM_EXPORT.PK_RMEXPORT
    RM_EXPORT_COLUMN.PK_RMEXPORTCOLUMN
    RM_EXPORT_DEFAULT_PARAM.PK_RMEXPORTDEFAULTPARAM
    RM_EXPORT_NODE.PK_RMEXPORTNODE
    RM_EXPORT_NODE_PROP.PK_RMEXPORTNODEPROP
    RM_EXPORT_PARAM.PK_RMEXPORTPARAM
    RM_EXPORT_TYPE.PK_RMEXPORTTYPE
    RM_GLYPH.PK_RMGLYPH
    RM_HIERARCHY.PK_RMHIERARCHY
    RM_HIERARCHY_GROUP.PK_RMHIERARCHYGROUP
    RM_HIERARCHY_PROP.PK_RMHIERARCHYPROP
    RM_IMPORT.PK_RMIMPORT
    RM_IMPORT_CLASS.PK_RMIMPORTCLASS
    RM_IMPORT_DEFAULT_PARAM.PK_RMIMPORTDEFAULTPARAM
    RM_IMPORT_PARAM.PK_RMIMPORTPARAM
    RM_IMPORT_SECTION.PK_RMIMPORTSECTION
    RM_IMPORT_SECTION_COLUMN.PK_RMIMPORTSECTIONCOLUMN
    RM_IMPORT_SECTION_COLUMN_HIER.PK_RMIMPORTSECTIONCOLUMNHIER
    RM_IMPORT_SECTION_COLUMN_PARAM.PK_RMIMPORTSECTIONCOLUMNPARAM
    RM_IMPORT_SECTION_PARAM.PK_RMIMPORTSECTIONPARAM
    RM_IMPORT_TYPE.PK_RMIMPORTTYPE
    RM_JOB_HISTORY.PK_RMJOBHISTORY
    RM_JOB_HISTORY_RESULT.PK_RMJOBHISTORYRESULT
    RM_MERGE_LOG.PK_RMMERGELOG
    RM_NODE.PK_RMNODE
    RM_NODE_MERGE.PK_RMNODEMERGE
    RM_NODE_PROP_GLOBAL.PK_RMNODEPROPGLOBAL
    RM_NODE_PROP_LOCAL.PK_RMNODEPROPLOCAL
    RM_NODE_TYPE.PK_RMNODETYPE
    RM_NODE_TYPE_PROPERTY.PK_RMNODETYPEPROPERTY
    RM_NODE_TYPE_VALIDATION.PK_RMNODETYPEVALIDATION
    RM_NOTIFICATION.PK_RMNOTIFICATION
    RM_NOTIFICATION_DETAIL.PK_RMNOTIFICATIONDETAIL
    RM_OBJECT_ACCESS_GROUP.PK_RMOBJECTACCESSGROUP
    RM_OBJECT_ACCESS_GROUP_NAG.PK_RMOBJECTACCESSGROUPNAG
    RM_OBJECT_ACCESS_GROUP_USER.PK_RMOBJECTACCESSGROUPUSER
    RM_PROPERTY_CATEGORY.PK_RMPROPERTYCATEGORY
    RM_PROPERTY_CONSTRAINT.PK_RMPROPERTYCONSTRAINT
    RM_PROPERTY_CTRL_HIER.PK_RMPROPERTYCTRLHIER
    RM_PROPERTY_DEFINITION.PK_RMPROPERTYDEFINITION
    RM_PROPERTY_LIST.PK_RMPROPERTYLIST
    RM_PROPERTY_LOOKUP.PK_RMPROPERTYLOOKUP
    RM_PROPERTY_PARAM.PK_RMPROPERTYPARAM
    RM_PROPERTY_QUERY.PK_RMPROPERTYQUERY
    RM_QUERY_CRITERIA.PK_RMQUERYCRITERIA
    RM_QUERY_DEFAULT_PARAM.PK_RMQUERYDEFAULTPARAM
    RM_RELATIONSHIP.PK_RMRELATIONSHIP
    RM_REQUEST.PK_RMREQUEST
    RM_REQUEST_ITEM.PK_RMREQUESTITEM
    RM_REQUEST_VERIFICATION.PK_RMREQUESTVERIFICATION
    RM_ROLE.PK_RMROLE
    RM_ROLE_PERMISSION.PK_RMROLEPERMISSION
    RM_SCHEDULED_TASKS.PK_RMSCHEDULEDTASKS
    RM_SESSION_INFO.PK_RMSESSIONINFO
    RM_SYSTEM_PREFERENCE.PK_RMSYSTEMPREFERENCE
    RM_TRANSACTION_HISTORY.PK_RMTRANSACTIONHISTORY
    RM_USER.PK_RMUSER
    RM_USER_PROP_HIERARCHY.PK_RMUSERPROPHIERARCHY
    RM_USER_PROP_VERSION.PK_RMUSERPROPVERSION
    RM_USER_PROPERTY_DEFINITION.PK_RMUSERPROPERTYDEFINITION
    RM_USER_ROLE.PK_RMUSERROLE
    RM_VALIDATION_DEFINITION.PK_RMVALIDATIONDEFINITION
    RM_VALIDATION_DEFINITION_TEMPL.PK_RMVALIDATIONDEFINITIONTEMPL
    RM_VALIDATION_PARAM.PK_RMVALIDATIONPARAM
    RM_VALIDATION_PARAM_TEMPL.PK_RMVALIDATIONPARAMTEMPL
    RM_VALIDATION_PROP_HIERARCHY.PK_RMVALIDATIONPROPHIERARCHY
    RM_VALIDATION_PROP_NODE.PK_RMVALIDATIONPROPNODE
    RM_VALIDATION_PROP_VERSION.PK_RMVALIDATIONPROPVERSION
    RM_VERSION.PK_RMVERSION
    RM_VERSION_PROP.PK_RMVERSIONPROP
    RM_WF_MODEL.PK_RMWFMODEL
    RM_WF_MODEL_FILTER_NODETYPE.PK_RMWFMODELFILTERNODETYPE
    RM_WF_MODEL_STAGE.PK_RMWFMODELSTAGE
    RM_WF_MODEL_STAGE_ASSG_GROUP.PK_RMWFMODELSTAGEASSGGROUP
    RM_WF_MODEL_STAGE_TASK.PK_RMWFMODELSTAGETASK
    RM_WF_MODEL_STAGE_VALIDATION.PK_RMWFMODELSTAGEVALIDATION
    RM_WF_REQUEST.PK_RMWFREQUEST
    RM_WF_REQUEST_ACTIVITY.PK_RMWFREQUESTACTIVITY
    RM_WF_REQUEST_ASSIGNED_TO.PK_RMWFREQUESTASSIGNEDTO
    RM_WF_REQUEST_ATTACHMENT.PK_RMWFREQUESTATTACHMENT
    RM_WF_REQUEST_ITEM.PK_RMWFREQUESTITEM
    RM_WF_REQUEST_ITEM_FAIL.PK_RMWFREQUESTITEMFAIL
    RM_WF_REQUEST_ITEM_PROPVAL.PK_RMWFREQUESTITEMPROPVAL
    RM_WF_REQUEST_STAGE.PK_RMWFREQUESTSTAGE
    RM_WF_REQUEST_STAGE_APPR_GROUP.PK_RMWFREQUESTSTAGEAPPRGROUP
    RM_WF_REQUEST_STAGE_APPROVAL.PK_RMWFREQUESTSTAGEAPPROVAL
    RM_WF_REQUEST_STAGE_ENRICHED.PK_RMWFREQUESTSTAGEENRICHED
    RM_WF_REQUEST_TAG.PK_RMWFREQUESTTAG
    RM_WF_TASK.PK_RMWFTASK
    RM_WF_TASK_PROPERTY.PK_RMWFTASKPROPERTY
    RM_WF_TASK_VALIDATION.PK_RMWFTASKVALIDATION
    RM_WF_TASK_VALIDATION_PROPERTY.PK_RMWFTASKVALIDATIONPROPERTY

  Adding foreign keys ...

    RM_ACCESS_GROUP_CTRL_HIER.FK_SECGLOBDEF01
    RM_ACCESS_GROUP_CTRL_HIER.FK_SECGLOBDEF02
    RM_ACCESS_GROUP_CTRL_HIER.FK_SECGLOBDEF03
    RM_ACCESS_GROUP_PROP_GLOBAL.FK_GLOBSECNODE01
    RM_ACCESS_GROUP_PROP_GLOBAL.FK_GLOBSECNODE02
    RM_ACCESS_GROUP_PROP_LOCAL.FK_SECNODE01
    RM_ACCESS_GROUP_PROP_LOCAL.FK_SECNODE02
    RM_ACCESS_GROUP_PROP_LOCAL.FK_SECNODE03
    RM_ACCESS_GROUP_USER.FK_SECUSER01
    RM_ACCESS_GROUP_USER.FK_SECUSER02
    RM_BLENDER.FK_BLENDPROF01
    RM_BLENDER.FK_BLENDPROF02
    RM_BLENDER_DEFAULT_PARAM.FK_BLENDERDEFPARMS01
    RM_BLENDER_HIERARCHY_SET.FK_BLENDHIERSET01
    RM_BLENDER_HIERARCHY_SET.FK_BLENDHIERSET02
    RM_BLENDER_PROPERTY_LIST.FK_BLENDPROPLIST01
    RM_BLENDER_PROPERTY_LIST_ITEM.FK_BLENDPROPLISTITMS01
    RM_BOOK.FK_BOOK01
    RM_BOOK.FK_BOOK02
    RM_BOOK.FK_BOOK03
    RM_BOOK.FK_BOOK04
    RM_BOOK.FK_BOOK05
    RM_BOOK_DEFAULT_PARAM.FK_BOOKDEFPARMS01
    RM_BOOK_ITEM.FK_BOOKITM01
    RM_BOOK_ITEM.FK_BOOKITM02
    RM_CATEGORY_USER.FK_CATUSER01
    RM_CATEGORY_USER.FK_CATUSER02
    RM_COMPARE.FK_CMP03
    RM_COMPARE.FK_CMP04
    RM_COMPARE.FK_CMP05
    RM_COMPARE_DEFAULT_PARAM.FK_COMPAREDEFPARMS01
    RM_COMPARE_ITEM.FK_CMPITM01
    RM_CONNECTION.FK_CONN01
    RM_CONNECTION.FK_CONN02
    RM_CONNECTION_ALLOWED_TABLE.FK_CONNALLOWEDTABLE01
    RM_DERIVED_PROPERTY_PARAM.FK_DERIVEDPROPPARM02
    RM_DOMAIN_NODE.FK_DOMNODE01
    RM_DOMAIN_VALIDATIONS.FK_DOMVAL01
    RM_DOMAIN_VALIDATIONS.FK_DOMVAL02
    RM_DOMAIN_VERSION.FK_DOMVER01
    RM_DOMAIN_VERSION.FK_DOMVER02
    RM_EXPORT.FK_EXP01
    RM_EXPORT.FK_EXP02
    RM_EXPORT.FK_EXP03
    RM_EXPORT.FK_EXP04
    RM_EXPORT.FK_EXP05
    RM_EXPORT_COLUMN.FK_EXPCOLS02
    RM_EXPORT_DEFAULT_PARAM.FK_EXPDEFPARMS01
    RM_EXPORT_NODE.FK_EXPNODES01
    RM_EXPORT_NODE_PROP.FK_EXPNODEPROP01
    RM_EXPORT_PARAM.FK_EXPPARMS01
    RM_HIERARCHY.FK_HIER01
    RM_HIERARCHY.FK_HIER02
    RM_HIERARCHY.FK_HIER03
    RM_HIERARCHY_PROP.FK_PROPHIER01
    RM_HIERARCHY_PROP.FK_PROPHIER02
    RM_IMPORT.FK_IMP01
    RM_IMPORT.FK_IMP02
    RM_IMPORT.FK_IMP03
    RM_IMPORT_DEFAULT_PARAM.FK_IMPORTDEFPARMS01
    RM_IMPORT_PARAM.FK_IMPPARMS01
    RM_IMPORT_SECTION.FK_IMPSEC01
    RM_IMPORT_SECTION_COLUMN.FK_IMPSECCOL01
    RM_IMPORT_SECTION_COLUMN_HIER.FK_IMPSECCOLHIER01
    RM_IMPORT_SECTION_COLUMN_PARAM.FK_IMPSECCOLPARM01
    RM_IMPORT_SECTION_PARAM.FK_IMPSECPARMS01
    RM_JOB_HISTORY_RESULT.FK_JOBHISTRES01
    RM_NODE.FK_NODE01
    RM_NODE.FK_NODE02
    RM_NODE_MERGE.FK_NODEMERGE01
    RM_NODE_PROP_GLOBAL.FK_PROPGLOB01
    RM_NODE_PROP_GLOBAL.FK_PROPGLOB02
    RM_NODE_PROP_LOCAL.FK_PROPLOC01
    RM_NODE_PROP_LOCAL.FK_PROPLOC02
    RM_NODE_PROP_LOCAL.FK_PROPLOC03
    RM_NODE_TYPE.FK_NODETYPE01
    RM_NODE_TYPE_PROPERTY.FK_NODETYPEPROP01
    RM_NODE_TYPE_PROPERTY.FK_NODETYPEPROP02
    RM_NODE_TYPE_VALIDATION.FK_NODETYPEVALID01
    RM_NODE_TYPE_VALIDATION.FK_NODETYPEVALID02
    RM_NOTIFICATION.FK_NOTIFICATION01
    RM_NOTIFICATION_DETAIL.FK_NOTIFICATIONDETAIL01
    RM_OBJECT_ACCESS_GROUP_NAG.FK_OBJECTACCESSGROUPNAG01
    RM_OBJECT_ACCESS_GROUP_NAG.FK_OBJECTACCESSGROUPNAG02
    RM_OBJECT_ACCESS_GROUP_USER.FK_OBJECTACCESSGROUPUSER01
    RM_OBJECT_ACCESS_GROUP_USER.FK_OBJECTACCESSGROUPUSER02
    RM_PROPERTY_CATEGORY.FK_PROPCAT01
    RM_PROPERTY_CATEGORY.FK_PROPCAT02
    RM_PROPERTY_CONSTRAINT.FK_PROPCONST01
    RM_PROPERTY_CTRL_HIER.FK_GLOBDEF01
    RM_PROPERTY_CTRL_HIER.FK_GLOBDEF02
    RM_PROPERTY_CTRL_HIER.FK_GLOBDEF03
    RM_PROPERTY_DEFINITION.FK_PROPDEF01
    RM_PROPERTY_LIST.FK_PROPLIST01
    RM_PROPERTY_LOOKUP.FK_PROPLOOKUP01
    RM_PROPERTY_PARAM.FK_PROPPARMS01
    RM_PROPERTY_QUERY.FK_PROPQRY02
    RM_PROPERTY_QUERY.FK_PROPQRY03
    RM_QUERY_CRITERIA.FK_QRYCRIT03
    RM_QUERY_DEFAULT_PARAM.FK_QUERYDEFPARMS01
    RM_RELATIONSHIP.FK_REL01
    RM_RELATIONSHIP.FK_REL02
    RM_REQUEST_ITEM.FK_REQITM01
    RM_REQUEST_VERIFICATION.FK_REQVERIF01
    RM_ROLE_PERMISSION.FK_ROLEPERMISSION01
    RM_USER_PROP_HIERARCHY.FK_HIERUSER01
    RM_USER_PROP_HIERARCHY.FK_HIERUSER02
    RM_USER_PROP_HIERARCHY.FK_HIERUSER03
    RM_USER_PROP_VERSION.FK_VERUSER01
    RM_USER_PROP_VERSION.FK_VERUSER02
    RM_USER_PROP_VERSION.FK_VERUSER03
    RM_USER_ROLE.FK_USERROLE01
    RM_USER_ROLE.FK_USERROLE02
    RM_VALIDATION_PARAM.FK_VALIDPARM02
    RM_VALIDATION_PARAM_TEMPL.FK_VALIDPARMTMPL02
    RM_VALIDATION_PROP_HIERARCHY.FK_VALIDHIER01
    RM_VALIDATION_PROP_HIERARCHY.FK_VALIDHIER02
    RM_VALIDATION_PROP_NODE.FK_PROPVALID01
    RM_VALIDATION_PROP_NODE.FK_PROPVALID02
    RM_VALIDATION_PROP_NODE.FK_PROPVALID03
    RM_VALIDATION_PROP_VERSION.FK_VALIDVER01
    RM_VALIDATION_PROP_VERSION.FK_VALIDVER02
    RM_VERSION.FK_VER01
    RM_VERSION.FK_VER02
    RM_VERSION_PROP.FK_PROPVER01
    RM_VERSION_PROP.FK_PROPVER02
    RM_WF_MODEL_FILTER_NODETYPE.FK_RMWFMODELFILTERNODETYPE01
    RM_WF_MODEL_STAGE.FK_RMWFMODELSTAGE01
    RM_WF_MODEL_STAGE_ASSG_GROUP.FK_RMWFMODELSTAGEASSGGROUP01
    RM_WF_MODEL_STAGE_TASK.FK_RMWFMODELSTAGETASK01
    RM_WF_MODEL_STAGE_VALIDATION.FK_RMWFMODELSTAGEVAL01
    RM_WF_MODEL_STAGE_VALIDATION.FK_RMWFMODELSTAGEVAL02
    RM_WF_REQUEST.FK_RMWFREQUEST01
    RM_WF_REQUEST_ACTIVITY.FK_RMWFREQUESTACTIVITY01
    RM_WF_REQUEST_ASSIGNED_TO.FK_RMWFREQUESTASSIGNEDTO01
    RM_WF_REQUEST_ATTACHMENT.FK_RMWFREQUESTATTACHMENT01
    RM_WF_REQUEST_ITEM.FK_RMWFREQUESTITEM01
    RM_WF_REQUEST_ITEM_FAIL.FK_RMWFREQUESTITEMFAIL01
    RM_WF_REQUEST_ITEM_PROPVAL.FK_RMWFREQUESTITEMPROPVAL01
    RM_WF_REQUEST_STAGE.FK_RMWFREQUESTSTAGE01
    RM_WF_REQUEST_STAGE_APPR_GROUP.FK_RMWFREQUESTSTAGEAPRGR01
    RM_WF_REQUEST_STAGE_APPROVAL.FK_RMWFREQUESTSTAGEAPR01
    RM_WF_REQUEST_STAGE_ENRICHED.FK_RMWFREQUESTSTAGEENRICHED01
    RM_WF_REQUEST_TAG.FK_RMWFREQUESTTAG01
    RM_WF_TASK.FK_WFTASK01
    RM_WF_TASK_PROPERTY.FK_RMWFTASKPROPERTY01
    RM_WF_TASK_VALIDATION.FK_RMWFTASKVALIDATION01
    RM_WF_TASK_VALIDATION.FK_RMWFTASKVALIDATION02
    RM_WF_TASK_VALIDATION_PROPERTY.FK_RMWFTASKVALPROPERTY01
    RM_WF_TASK_VALIDATION_PROPERTY.FK_RMWFTASKVALPROPERTY02

 Schema is up to date

12 updates were applied to COAMGMT@//EPMSRV:1521/ORACLE


Press any key to continue.

Oracle DRM 11.1.2.4 : DRG New Features!

Please check the link for the DRM new features, in this blog post I have specifically talked about the Data Relationship Governance Features (DRG)

http://www.trendingthoughts.com/blog/2015/03/21/drm-11124-is-here-drg-new-features

DRM 11.1.2.4: DRG Workflow Request Submission using Batch Client

In the previous blog you have seen how to load request items from a file, sometimes being a DRM developer you may end up doing the same on a regular basis,

We can automate the request submission using the Batch client, provided we have a properly formatted input file with the request items.


"D:\products\DataRelationshipManagement\client\batch-client\drm-batch-client.exe" /URL=net.tcp://EPMSRV:5211/Oracle/Drm/Engine /log=D:\DRM\Data\Inbound\BatchLoad.log /u=Operations /pw=Welcome! /op=RequestSubmit /delim=tab /conn=Inbound /vabbrev="Vision Jan 2013" /hierarchy="Parent Total" /conn=Inbound /filename=AcctConditional-I.txt /workflowtask="Add Financial Account" /workflowmodel="New Financial Account" /requesttitle="Batch Request" /deleteonsubmitfailure=0 


Submit Workflow Request:

/op = RequestSubmit

/delim=                 Printable delimiter character the request items file use
s - single character (|~`:, etc) | tab | comma | space | #nnn  (#33 - #126)
/conn=                  (optional) Name of external connection pointing to locat
ion where file specified with filename option resides
/vabbrev=               Name of version to use for created request
/hierarchy=             Name of hierarchy to use for loaded request items
/filename=              (optional) Name of request items file if using an extern
al connection.
/infile=                (optional) Path and file name for a local request items
file to use.
/workflowtask=          Name of the workflow task to use
/workflowmodel=         Name of the workflow model to use
/requesttitle=          Title of submitted request
/deleteonsubmitfailure= Delete the draft request if submit fails validation - Y:
 Yes | N: No | T: True | F: False | 1 | 0
/allowblankoverrides=   (optional) If true, then blank values in the source file
 are treated as blank value overrides for each item, according to
                        the 
/blankvalueindicator param
/blankvalueindicator=  (optional) If specified, any column value matching the 
                        blankvalueindicator will be interpreted as a blank value override.
                        If not specified, any blank column value will be 
                        interpreted as a blank value override