Archives of the TeradataForum

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

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

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>>