Keywords Available for use in the SQL Data Block

You can use any of the following keywords in place of a block and field pair.

  • NODENAME – The node name of the local SCADA server.
  • SQTBLK – The name of the SQT block.
  • TMDT – The current time and date.
  • TIME – The current time.
  • DATE – The current date.

For example, to save the time and date of each relational database transaction, enter the keyword TMDT in the SQL Data block.