Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 14 Mar 2003 @ 20:15:08 GMT

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

Subj:   Re: Trouble migrating a huge SP to production
From:   Bhupesh Singu

Greetings Jason!!

We did use bteq in both environments. We created a .sql file with the stored procedure. We ran the script in development, tested the results and migrated the same script in production. And, that is when we started having problems.

We broke down the stored procedure in production into three smaller parts and the pieces ran fine. However, when we call the procedure, teradata seems to complain. I was wondering, if the sql script was too large and if the parser chopped the script somewhere in the middle.

Is this possible? If so, is it caused by an server setting?



  <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