sqlUpdate

swordfish.function.sqlUpdate()

Dynamically generate a metacode of the SQL update statement. To execute the generated metacode, please use function eval.

Parameters:

• table (Constant) – Can be an in-memory table or a distributed table.

• updates (Constant) – A metacode or a tuple of metacode, indicating the updating operation.

• from (Constant, optional) – A metacode indicating the table join operation, by default DFLT.

• where (Constant, optional) – A metacode indicating the where condition, by default DFLT.

• contextBy (Constant, optional) – A metacode indicating the context by clause, by default DFLT.

• csort (Constant, optional) – A metacode or a tuple of metacode that specifies the column name(s) followed by csort, by default DFLT. This parameter only works when contextBy is specified.

• ascSort (Constant, optional) – A scalar or vector indicating whether each csort column is sorted in ascending or descending order, by default DFLT. 1 (default) means ascending and 0 means descending.

• having (Constant, optional) – A metacode or a tuple of metacode that specifies the having condition(s), by default DFLT. This parameter only works when contextBy is specified.