Search code examples
batch-fileteradata-sql-assistant

Run Teradata SQL Assistant via a batch script

I am trying to Run a teradata SQL script via a batch script and export the details. I have managed to execute the whole thing in DOS which is great Im just not sure how to package it up Below is my very average attempt. COuld anyone point me in the right direction?

The SQL is SELECT DATE

@title Optional Title
@echo off

C:\'Program Files (x86)'\Teradata\Client\15.00\Teradata SQL Assistant\
Sqla -c DB_NAME -f "C:\Temp\test.sql" -e "c:\Temp\test_output.log"

Thanks

Solution

  • I found the answer on another different question on Stack Overflow

    How do I execute cmd commands through a batch file?

    This basically does what i need or at least points me in the correct direction

    Thank you for your time