Environment metadata
Enter in this field the variables and values that are associated to the JSON script file inserted in the New Model window (see Script section).
For example:
#ALIAS# value="RCT-ARIANE"
#RCTYPE# value="AS400"Other examples of variables:
| Variable | Description |
|---|---|
| FC.SRC_TBL | File/Lib/Member Source If AS400 IBMi source: Lib/File (Member) |
| FC.SRC_FIC | For AS400 IBMi source only. |
| FC.SRC_LIB | For AS400 IBMi source only. |
| FC.SRC_MBR | For AS400 IBMi source only. |
| FC.TGT_TBL | File/Lib/Member Target |
| FC.RCV_NAME | Last receiver processed |
| FC.RCV_LIB | Last receiver library processed |
| FC.JRN_SEQ_10 | Sequence number |
| FC.JRN_OPLVL | Journal operation level |
| FC.JRN_OPNAT | Journal operation code (UB,UP,PT, DL) INSERT, UPDATE, DELETE, TRUNCATE |
| FC.JRN_DATTIM | Post Date/Time The format is YYYYMMDDHHMISS |
| FC.JRN_JOB | Job name |
| FC.JRN_USER | User name |
| FC.JRN_PGM | Program name |
| FC.JRN_MBR | Member |
| FC.JRN_RRN | Record Relative Number |
| FC.DATETIME | Processed date The format is YYYYMMDDHHMISS |
| FC.JRN_SEQ_20 | Extended Sequence For AS400 IBMi source only. |
| FC.TRAN_ID | XactID (transaction ID) For MS SQL Server source only. |
| FC.CMD_ID | Command ID For SQL Server source only. |
| FC.TIMEZONE | Time Zone |
| FC.SEP | Separation for more fields For Snowflake target. |