Using INTO to create a macro variable for pass-through teradata query

[kb011235]

I couldn't get this to work; the error message says that the teradata engine cannot be found.

[Tom]

Use whatever engine your current process is using.  I would assume you are using ODBC if you don't have SAS/Access to Teradata licensed.  You are not going to get as much performance out of the SAS - Teradata connection using generic ODBC connection.

You can still get access using ODBC engine, but I am not sure if that supports accessing volatile tables via a libref.

Try it and see.

[ballardw]

---

@kb011235 wrote:

Thanks for the effort, but your method runs into the same list length issue (capped at 65534 characters).

---

Show your LOG with the code submitted and the error messages.

[Reeza]

@kb011235  did you try my approach? Did it not work?

[kb011235]

@Reeza I didn't try your approach.