When using Toad's Generate Data took, it does not select a value form a given list, when working with the generator selection of "Constant Value".
In the options settings for a column, "Constant Value" is selected. Below that, a list of values to select from is noted in the field.
But when Toad tries to create data, it seems to be using the whole is of values, instead of randmly selecting one of the listed options.
Example:
The type of a column is noted as char(1). They value should either be 'Y' or 'N' (a single value).
In the Data Generator settings, it list "Y,N" in the constants field. What is expected is that the generator will randomly choose to set the value as either 'Y' or 'N'.
Currently the generator is actually trying to enter in the full value of 'Y,N', which is incorrect and too large for the column/type
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center