Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 24 Oct 2011 @ 08:41:22 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Stored Procedures - Proc within a Proc
From:   David Clough

If I can just try your patience a little longer with Stored Procedures ....

I've got some code within a Procedure, which I'd like to put into a Procedure in its own right. Ideally, however, I'd like it to be a Procedure within my main Procedure, partly because it'll tidy it away and partly because I want to call it with different parameters more than once, but I can't see it being of much use to anyone else.

Thing is, can I do this, or do I have to create a separate Procedure ? I can't see any reference to this ability within the manual, but just in case I'd thought I'd ask you guys.

It doesn't matter too much, but it would be nice if I could package things up a bit within my main Procedure.

Also, is there any way I can get output directed to a file system, directly from a Stored Procedure, or is this a complete no, no. Basically, I'll be generating SQL from SQL and the result will eventually need to go in a file.


David Clough
Senior Database Designer
Database Design Group

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