Archives of the TeradataForum
Message Posted: Tue, 13 May 2014 @ 12:39:11 GMT
During an upgrade of Teradata I read that using
is the way to go.
That's fine, but does this handle dependencies, I wonder ?
For example if I have 5 Procedures, with the following dependencies :
Proc_A ... invokes Proc_E
Proc_B ... invokes Proc_D
If we generate a Bteq script with the Alters in this order
Alter Procedure Proc_A ?Compile ; Alter Procedure Proc_B ?Compile ; Alter Procedure Proc_C ?Compile ; Alter Procedure Proc_D ?Compile ; Alter Procedure Proc_E ?Compile ;
then, whilst it is self-evident that Procedure C , D and E would independently compile, would the PRECEDING Procedures (i.e. A and B) fail to compile first time around ? ?
Effectively, would I have to run the script again in order for A and B to then compile ? ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|