Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 26 Jun 2008 @ 23:21:44 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020