All Forums Database
N_Raghu 34 posts Joined 12/13
24 Jan 2014
Order of sql execution in a macro

I have several insert statements that needs to be executed in certain order. Can we accomplish this in a macro? 
If not any other suggestions?
As far as I understand a macro executes sql statments parallely and not sequentially.

-Raghu
Tags:
Raja_KT 1246 posts Joined 07/09
24 Jan 2014

I guess that teradata macros are intelligent enough to execute those statements that do not have /share dependencies in parallel.
Cheers,

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.

N_Raghu 34 posts Joined 12/13
26 Jan 2014

Yes...You are right Raja_KT.. My macro worked just fine..Thank you for your response :)

-Raghu

You must sign in to leave a comment.