具有值列表的Teradata变量

具有值列表的Teradata变量

TD14支持名为STRTOK_SPLIT_TO_TABLE的漂亮表函数：

REPLACe MACRO testmac(param VARCHAr(1000)) AS(SELECT * FROM dbc.DatabasesV AS dbJOIN  (   SELECt token AS DatabaseName, tokennum   FROM TABLE (STRTOK_SPLIT_TO_TABLE(1, :param, ',')        RETURNS (outkey INTEGER, -- usually the PK of the table, here it's just a dummy      tokennum INTEGER, -- order of the token within the param string      token VARCHAr(128) CHARACTER SET UNICODE)   ) AS d  ) AS dtON db.DatabaseName  = dt.DatabaseNameORDER BY tokennum;);EXEC testmac('dbc,systemfe,syslib');