Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 08 Oct 2001 @ 14:51:29 GMT


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


Subj:   Re: Macros using USING
 
From:   Edmond Ray

You are having problems because you understanding is incomplete. The USING statement implies that you will be using a 'USING buffer' to pass data to the macro. If you are running this from bteq the only way to due this is by using a .REPEAT statement. If you are calling this macro from CLI program you have set up and fill the 'USING buffer'. If you just want to pass argument to the macro the syntax is:

create macro lcidba.ins_sp_used
  ( in_dt       date,
    in_tm       time(0),
    in_used_qt  decimal(15,0) )
as (
insert into lcidba.spool_used
   ( when_dt
    ,when_tm
    ,spool_used_qt )
   VALUES (  :in_dt
                   ,:in_tm
                   ,:in_used_qt);
);

Edmond Ray
Senior Data Warehouse Consultant
Special Programs, NCR Government Systems



     
  <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: 15 Jun 2023