How to generate a sequence in bteq script.

Tools
Enthusiast

How to generate a sequence in bteq script.

Hi ,

I need to generate a sequence in bteq, can any body tell me how to to do that?

Thanks and Regards,
Kapil
1 REPLY
Enthusiast

Re: How to generate a sequence in bteq script.

hi,

check it this example

create set table sample(eno integer generated always as identity(start with 1 increment by 1
min value -2147483647
max value 2147483647
no cycle),ename varchar(20),esal integer);