Table of Contents

About

This how-to shows you how to generate an string,varchar, text sequence with the column sequence generator.

Steps

Creation of the generator file

To generate data, you need to create a generator file that will describe the data to be generated.

The below data resource generator:

  • has the name sequence_varchar–datagen.yml
  • has the logical name sequence_varchar
  • will generate 30 values (MaxRecordCount count)
  • has a column named id that has sequence data generator that:
    • starts by default at the value 1
    • increments by default with the value 1
  • has a column named seq_char with the varchar data type that has sequence data generator
MaxRecordCount: 30
Columns:
  - name: id
    type: integer
    comment: A id column to see easily the number of values generated
    DataGenerator:
      type: sequence
  - name: seq_char
    type: varchar
    precision: 2
    comment: A column with a sequence character generator
    DataGenerator:
      type: sequence

Printing the data

With the data print command, we can print the values generated. 

tabli data print sequence_varchar--datagen.yml@howto

howto is the connection that contains the files used in the HowTo's. 

id   seq_char
--   --------
 1   a
 2   b
 3   c
 4   d
 5   e
 6   f
 7   g
 8   h
 9   i
10   j
11   k
12   l
13   m
14   n
15   o
16   p
17   q
18   r
19   s
20   t
21   u
22   v
23   w
24   x
25   y
26   z
27   ba
28   bb
29   bc
30   bd

Next

Because a generator is just a data resource, you can use it in every data operation.

How to use a generator in a data operation