|
Archives of the TeradataForumMessage Posted: Tue, 13 May 2014 @ 12:39:11 GMT
Hi guys, During an upgrade of Teradata I read that using Alter Procedure 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 Proc_C Proc_D Proc_E 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 ? ? Regards David Clough
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||