SmodE

From SRB

Contents 1 NAME 2 SYNOPSIS 3 DESCRIPTION 4 OPTIONS 5 SEE ALSO

NAME

SmodE - modifies extensible metadata table rows in the MCAT.

SYNOPSIS

SmodE -i dataName collName tableName insertAttrList insertAttrValueList [ insertAttrValueList ... ]

SmodE -d dataName collName tableName conditionAttrList conditionList "[ conditionList ... ]

SmodE -u dataName collName tableName modifyAttrList modifyAttrValueList conditionAttrList conditionList

SmodE -i -f insertFileName dataName collName tableName insertAttrValueList

DESCRIPTION

SmodE modifies rows in the user-defined MCAT table called tableName.

These tables are associated with a SRB object such as a collection collName or a srbObject dataName.

OPTIONS

-i

inserts a row into tableName and takes in a list of column-names insertAttrList separated by |, and a list of values insertAttrValueList separated by | (quoted if string or date values). More than one row can be inserted by repeated use of insertAttrValueList .

-d

deletes one or more rows from tableName and uses a list of column-names conditionAttrList separated by |, and a list of conditions conditionList separated by | (quoted if string or date values are used). More than one condition can be specified on the attributes and will be used conjunctively.

-u

updates one or more rows from tableName and uses a list of column-names modifyAttrList separated by |, and a list of (new)values and a condition based on a list of conditions conditionList separated by | (quoted if string or date values are used). More than one condition can be specified on the attributes and will be used conjunctively.

-f

inserts a row into tableName and takes in a list of column-names insertAttrList separated by |, and a file name insertFileName that contains the list of values to be inserted. Format of file is as follows:

first-line  =attrVal|attrVal|...|attrVal
second-line =attrVal|attrVal|...|attrVal
: :
nth-line =attrVal|attrVal|...|attrVal

The following attribute names are keywords and have particular meaning in the SRB:

DATA_ID, USER_ID, COLLECTION_ID, RSRC_ID, CONTAINER_ID, GUID, and TIME_VAL If you want it to be substituted internally give the value or 0. If 0 is used the corresponding data_id or collection_id or user_id will be generated from other parameters being passed by the command.

SEE ALSO

SmodD