I'm trying to use my SQL Server to extract and store the results of dynamic queries executed on our Teradata server, but ran into technical difficulties - namely an 8k character limit on queries using OpenRowset, about half our queries are bigger than that.
An alternative I've been researching but haven't been able to get to work is to use dynamic queries directly in Teradata, but unfortunately I haven't been able to figure out how to get it to work. I would ideally stored the queries in a table in Teradata, and then execute them remotely from SQL Server (since I not have to send the query across I could bypass the 8k limit). If I can figure out how to run them in Teradata SQL Assistant I can handle the SQL Server side.
I don't have the authority to create stored procedures, but I can create macros. Another option I was considering is BTEQ but I have no experience with that.
I've been wanting to get some good manuals for Teradata but it seems they don't exist. Also I strongly recommend updating your web server - it can take 5 minutes to load a simple page.