Symbols are collected into the symbol table. They come from a variety of sources.
| Abbr | Name | Description |
|---|---|---|
| DEF | defines | defined in the DBS configuration file |
| ENV | environment | from the command shell environment |
| PRE | preset | set by DBSubst |
| SQL | SQL | returned from the SQL query |
| CNT | counter | specified in the DBS configuration file, updated on iterations through the respective levels |
| Symbol | Description |
|---|---|
| CurrentDateTime | The current date and time formatted according to the timestamp format |
| CurrentDate | The current date formatted according to the date format |
| CurrentTime | The current time formatted according to the time format |
| CurrentYear | The current year as a four digit number |
| CurrentDirectory | The current directory |
| DBSubstBuild | The build date of DBSubst |
| DBSubstVersion | The version of DBSubst |
| ComputerName | The name of the computer |
| UserName | The name of the user |
Both ComputerName and UserName will normally be supplied by the environment. If they are missing, empty strings will be inserted as preset symbols. This will insure correct execution will occur when these symbols are referenced.