All Forums General
Purushotham 87 posts Joined 04/14
19 Jun 2014
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.
 

Purushotham.M
Raja_KT 1246 posts Joined 07/09
19 Jun 2014

BT
;SEL DATE
;ET;
=5
OR use unix loops
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

dnoeth 4628 posts Joined 11/04
20 Jun 2014

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

your_select;
=n

.repeat n
your_select;

 

Dieter

Purushotham 87 posts Joined 04/14
20 Jun 2014

Hi,

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

Purushotham.M

You must sign in to leave a comment.