User Tools

Site Tools


novo_motion_schema_editor

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
novo_motion_schema_editor [2021/02/05 21:19]
dlm
novo_motion_schema_editor [2021/06/08 14:16] (current)
mah update @variables
Line 63: Line 63:
 |@LITERAL | Used to pass static data through the schema - @LITERAL:1 | |@LITERAL | Used to pass static data through the schema - @LITERAL:1 |
 |@FIELD | Field based on info  - @FIELD:info:delimiter:occurrence:numberOfOccurrences| |@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 | |@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 |  |@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 | |@TRIM | Removes errant spaces from a string  - @TRIM:mvinfo |
 |@NULL | Returns a null character - @NULL | |@NULL | Returns a null character - @NULL |
 +|@BLOAT | TBD | 
 +|@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.    * 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. 
novo_motion_schema_editor.txt ยท Last modified: 2021/06/08 14:16 by mah

DokuWiki Appliance - Powered by TurnKey Linux