Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added comment about one process accessing the file.

...

username: sysdba
password: masterkey

Only one process can access the local.fdb file at one time. To look at e.g. an OC localdatastore, exit the OC before accessing the localdatastore with DBVisualizer and vice versa.

Tips and tricks

  • (wink) The wildcard for texts when using the Like statement is % (e.g. Select * from TimeSeries where moduleInstanceId Like '%Import%')
  • (wink) When looking for a date in an SQL string - use CAST('yyyy-MM-dd HH:mm:ss' as TIMESTAMP)
    (this is equivalent to the ORACLE to_Date command)