Archives of the TeradataForum
Message Posted: Thu, 26 Jun 2008 @ 23:21:44 GMT
Subj: | | Re: Stored procedures Error as a Warnings? |
|
From: | | McCall, Glenn David |
You can't create SP1 unless SP2 exists. The solution is simply to create SP2 first then create SP1.
If SP2 calls SP1 - i.e. you have the same problem for SP2 - then you need to take 3 steps. The options are:
1) Create a dummy SP2 (one that does nothing except exist). Create SP1 that calls the dummy SP2. Create the real SP2 (that calls
SP1).
2) Create SP1 without any calls to SP2. Create SP2 (which can call SP1). Modify SP1 to call SP2.
|