Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 Mar 2003 @ 19:32:32 GMT


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


Subj:   Re: Trouble migrating a huge SP to production
 
From:   Jason Fortenberry

Hey Bhupesh,

How did you migrate this SP over? Did you just copy into Queryman and run, use BTEQ, part of a database restore? It sounds like you probably lost some formatting along the way, and since the SQL syntax in the SP is not verified at SP create time, you don't see these type errors until you actually call the SP. Perhaps try copying out the SQL part of the procedure and run it in small steps to see where the error is, if possible.

--Jason



     
  <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