NAME

setfields - set fields in an /rdb file

SYNOPSIS

setfields [options] select expression : assignment expressions

OPTIONS

-help

Print this help information.

-fXXX

The expression is in the file XXX, instead of on the command line. The advantage in this case is that no quoting of chars that might be special to the UNIX shell is necessary.

-cp

duplicate the selected row in the output rdb table, and set the fields in the duplicate row.

-d column[,def]

override the column type definition for column in the rdb file, setting it to def, if specified, or the opposite of the current definition, if def is not specified.

-x

Print out the Perl script which will be eval'd.

DESCRIPTION

setfields acts generally the same way that compute does, except that you can specify (via an expression) the rows upon which to operate. It will set fields to specified values in those rows from the input rdbtable which match an arbitrary expression using column names. Characters that are special to the UNIX shell must be quoted.

This operator reads an rdbtable via STDIN and writes an rdbtable via STDOUT. Options may be abbreviated.

Rows are selected by specifying an expression which will be true for the required rows.

Expressions

See the rdb_expr document for information on how to specify expressions.

NOTES

setfields was derived from row, part of perl-rdb 2.5k written by Walter V. Hobbs.

AUTHOR

Diab Jerius

VERSION

$Revision: 1.16 $ $Date: 2001/02/09 20:11:08 $