HOW TO RUN SAME DML STATEMENT IN 'N' NO OF TIMES IN BTEQ

General
Enthusiast

HOW TO RUN SAME DML STATEMENT IN 'N' NO OF TIMES IN BTEQ

Hi,

Could anyone pls tell me the query, how to run same dml statement(i.e sel * from table_name) in no of times in bteq.

Regards,

Purushoham.

3 REPLIES
Enthusiast

Re: HOW TO RUN SAME DML STATEMENT IN 'N' NO OF TIMES IN BTEQ

BT

;SEL DATE

;ET;

=5

OR use unix loops

Junior Contributor

Re: HOW TO RUN SAME DML STATEMENT IN 'N' NO OF TIMES IN BTEQ

There are two way in BTEQ, the one Raja mentioned:

your_select;
=n

.repeat n
your_select;
Enthusiast

Re: HOW TO RUN SAME DML STATEMENT IN 'N' NO OF TIMES IN BTEQ

Hi,

Thank's a lot raja and dnoeth for writing the query.