Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# INSERT Statement and Expressions

INSERT statements can contain expressions for the values to be inserted for a column. For example, the following INSERT statement can be used to add a timestamp as the primary key for each row being added:

    INSERT INTO mytable (col1, col2) VALUES (datetime(‘now’), ‘some string’)

Note: The expressions that can be used as values are limited and cannot contain column names that must be dynamically evaluated.

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.