sequence number

Powerful and fully customizable utility that generates data for database testing purposes

Moderator: Support Team

sequence number

Postby hari » Thu Sep 15, 2011 2:05 pm

I have table in which a column is defined as varchar2 but it stores numbers. It was defined as varchar to store leading zeros.

I have tried to generate values for the above field using incremental fill method but the tool is generating with a negative values which is not desired for me.
I need all positive values with increment.

Can any one suggest any solutions.

Re: sequence number

Postby Support Team » Thu Sep 15, 2011 6:21 pm

Try to use "format" field with value like %05d where 5 is field width.
It produces 00001, 00002, 00003, etc.

If you use $Inc function of the pattern engine it allows you to specify format string as well.
Support Team
Posts: 259
Joined: Sun Mar 26, 2006 3:48 pm

Re: sequence number

Postby lakshmi » Fri Sep 16, 2011 12:17 pm

Thanks, $Inc function has worked

Return to DTM Data Generator, Flat File Generator and Test XML Generator

Who is online

Users browsing this forum: No registered users and 1 guest