ADS version-ADS-16.0.0-dev-28
For Teradata Macros, Script Object to New Window -> Execute, is creating the script in an already open query analyzer window. ADS is not opening a new window for the script.
To reproduce:
Connect Teradata-15.0
//Create table
CREATE SET TABLE "test_company" ,
NO FALLBACK,
LOG,
NO BEFORE JOURNAL,
WITH JOURNAL TABLE = "sqlscript"."journals",
DEFAULT MERGEBLOCKRATIO,
CHECKSUM = HIGH (
"empid" BIGINT NOT NULL DEFAULT 75,
"c_name" VARCHAR(100) UPPERCASE CHARACTER SET LATIN NOT NULL DEFAULT 'DIMENTRIX',
"phnumber" INTEGER NOT NULL DEFAULT 60,
CONSTRAINT "c_name" PRIMARY KEY("c_name")
)
GO
//Create Macros using above table,
CREATE MACRO "sqlscript"."test_macros" (param1 bigint)
AS
(
SELECT empid,c_name,phnumber FROM sqlscript.test_company WHERE empid = :param1;
);
GO
Expand database node
Expand Macros node
Right click on "sqlscript"."test_macros" and select Script object to new window as/File as->Select 'EXECUTE' Parameter.
Here you will observe that,Execute script generated on current Query Analyzer.
Here,Execute script should be generated on new Query Analyzer.
Script to New Window and Script to File where accidently calling the script to window action. action calls fixed.