Differences

This shows you the differences between two versions of the page.

--- novo_motion_schema_editor [2021/02/05 16:19] – dlm
+++ novo_motion_schema_editor [2024/05/13 16:08] (current) – dlm
@@ Line 63: / Line 63: @@
 |@LITERAL | Used to pass static data through the schema - @LITERAL:1 |
 |@FIELD | Field based on info  - @FIELD:info:delimiter:occurrence:numberOfOccurrences|
+|@FIELDS | Field for multi-value array.  Same as @FIELD |
 |@TM | Allows selection of a specific table master - @TM:tablenbr |
 |@CHANGE | Used to change a specific string from one literal to another - @CHANGE:info:from:to |
@@ Line 72: / Line 73: @@
 |@TRIM | Removes errant spaces from a string  - @TRIM:mvinfo |
 |@NULL | Returns a null character - @NULL |
+|@BLOAT | Use to expand (bloat) a dictionary to the value mark count dictated by another dictionary - @BLOAT:DictOne:BoatDict|
+|@USER | Sends the U2 user ID who caused the record change event, or load event |
+|@SWAP | Used to change string from one string to another -  @SWAP:info:from:to |
+|@CAT | Use U2 CATS to combine two arrays of data together - @CAT:info1:info2 |
+|@TIMESTAMP | transmit a record timestamp for when change / load event happened in U2. This is both date and time in SQL. |
+  * In SWAP CONVERT etc above, @AM @VM @SVM can be specified as IN or OUT strings.
   * Ordinal considerations: The precision and scale assigned to the ordinal are taken from the mvinfo dictionary. Because an ordinal is a number, the precision and scale should be changed to numeric with a scale of 3 or 4.