Transaction control in BTEQ script

Database
Enthusiast

Transaction control in BTEQ script

Hi all,

I am coding for SCD (Slowly changing Dimension) 2 in BTEQ script. What should be ideal code to avoid mess up of data considering SCD-2?

As of now, if there is an error we quit but is there any optimal solution?

1 REPLY
Enthusiast

Re: Transaction control in BTEQ script

Is there a limitation to write this complex logic in BTEQ? Why dont you write a stored procedure and call that SP in BTEQ script?

Khurram