Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 29 Jul 2004 @ 14:04:57 GMT

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

Subj:   Re: Macros: Treating a parameter as an object
From:   teradatanewsgroup

Passing an object will not work in a macro - only values. Still think about an different way.

Can you explain your statement on

  Unfortunately my solution has to be a macro. I'm trying not to use Dynamic SQL in a Stored Procedure, since that may involve multiple steps, which isn't something that would work for my scenario.  

I am not sure if I get this correct -

Can't you insert into a volatile table with dynamic SQL and read the content this table into a OUT variable?


  <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: 23 Jun 2019