Versions Compared

Old Version 17

changes.mady.by.user Shaun Forbes

Saved on

compared with

New Version 18

changes.mady.by.user Lucy Minato (Deactivated)

Saved on

Key

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

...

Name

Type

Required

Description

rpad

number

no

If the key value needs to be padded with spaces on the right to make it match the database, this specified specifies the total length of the final padded value.

For example rpad = 10 would change a key value from "value" to "value....." (where each . is a space).

lpad

number

no

If the key value needs to be padded with spaces on the left to make it match the database, this specified specifies the total length of the final padded value.

For example lpad = 10 would change a key value from "value" to ".....value" (where each . is a space).

trimbooleannoIf a key value needs to be trimmed of spaces before being used setting this to true will cause that to be done.
maxrowsnumbernoLimit the number of rows that will be extracted from the database when generating the data.
failOnSubstitutionErrorbooleanno

If set to true, or not set at all, this flag will force the generation of the data to fail if there is an issue with performing parameter substitution.

If this is set to false then a where clause that fails parameter substitution will be ignored.

The default value for this flag if it is not set is true.

...