Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Typical parameter usage may be the global definition of how many days should be looked back for changed data, a month or processing period, etc.
Parameters can be used in Load tables to place limits in a 'Where' clause, etc. Refer to Database Link Load - Source Mapping for details.
Stage table procedures also use them as variables. Refer to Generating the Staging Update Procedure for details.

  • SQL ServerPostgreSQL: Two procedures are provided to allow procedures to read and write parameters. These procedures are WsParameterRead and WsParameterWrite. Using these procedures, a procedure can load and use the contents of a parameter, modify an existing parameter, or add a new parameter. A function WsParameterReadF is also provided. This function will return the value of a parameter.

Global Parameters

...

  • .