Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 26 Jun 2008 @ 11:07:19 GMT


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


Subj:   Stored procedures Error as a Warnings?
 
From:   kkishore

Hi All,

Any one knows about below issue cause.

Issue is: I was installed Teradata V2R6.1 Demo version in two systems (Windows XP sp3). Now I am creating same stored procedures in both the system.

     Create procedure SP1 (...........)
     Begin
        ..............
        ..............
        ..............
        Call SP2 (.......);
        .................
        .................
     End;

Note: SP2 not at created (not available).

When I try to create SP1

SYS1 --> SP1 is creating by showing a "WARNING" "SP2 object not found"

SYS2 --> Shows an "ERROR" "SP2 object not found"


Can any one help me what is the difference in both the systems? If I want to change SYS2 as SYS1 where I need to change? Any one please help me.


Thanks,

Kishore KK



     
  <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: 27 Dec 2016