RandomNumber

Generates an integer random number of the specified length

Arguments:

Argument	Required	Type	Description
Length	Yes	Number	The number of digits that the generated random number should have

 

Example:

--- !ClientQuery
Id: RND
Statement: Select RandomNumber(7) as RND

Result:

RND
4938238

 

RandomIBAN

Generates an IBAN with valid check code for country code, bank code and account number length. The RandomNumber function is used to generate the account number.

Node:
Additional (country-specific) check digits are not generated.

 

Arguments:

Argument	Required	Type	Description
Country code	Yes	Text	Country code of the IBAN. Must consist of exactly 2 characters (e.g. "AT").
Bank code	Yes	Number	Bank code. This is appended directly after the check code.
Account Length	Yes	Number	Length of the account number to be generated. The generated account number is appended after the bank code.

 

Example:

--- !ClientQuery
Id: AustrianIBAN
Statement: Select RandomIBAN('AT', 43000, 10) as IBAN

Result:

IBAN
AT37430007046189981