User defined variables

[adtrombley]

Trying to create a list of table names I can later call (in SAS we use &name. to call it), and %mend at the bottom to invoke it, how do I do this in Teradata?

CREATE FUNCTION input_tables ('TABLE8X ' VARCHAR(20), 'TABLE_8X' VARCHAR(20), 'TABLE_SESSION_8X' VARCHAR(20), 'TABLERL_8X' VARCHAR(20) )
RETURNS VARCHAR(20)
LANGUAGE C
NO SQL
PARAMETER STYLE SQL
EXTERNAL;

appreciate the help!