Is it possible to Use Multiple SQL passes in terdata data connector using .TDC modifications.
Create volatile table 1 as () ....;
Create volatile table 2 as ()...;
Select table 1 join table 2 on .....
where
X = [parameter1];
I see that the initial SQL box allows multiple passes but the Custom SQL box does not allow the same.
2 answers
Hi Deepak,
The Initial SQL setting supports DDL statements such as CREATE TABLE, INSERT INTO, etc. Any results from these queries will be ignored. In contrast, the Custom SQL connection only supports a single SELECT statement and it must produce a result set.
-Robert
