The @@x statement is a variable representing an input argument for a macro. The number x is the number of the argument in the signature of the macro. So, @@1 represents the first input argument, @@2 represents the second input argument, and so on.
@@x
x | The number of an argument in the signature of the macro |
create macro Sample.'@ADD'(single, optional, single) as '(@@1 + @@2 + @@3)';and the following input parameters,
@ADD("New York", , Connecticut);the argument variables would be set to these values:
@@1 = "New York" @@2 = @_NULL @@3 = Connecticut
The following example shows a create statement for a macro with three input arguments that are added.
create macro Sample.'@SUM3'(single, single, single) as '(@@1 + @@2 + @@3)';
Copyright 1991-2002 Hyperion Solutions Corporation. All rights reserved.