I have 10 different .txt files which contains the BTEQ script.
I can able to run all them though the command prompt.
Now, i want to create a .bat file, which should call all of the 10 .txt files (Which has the BTEQ scipt within) and executes.
Please help me on this.
You seem to manage to post to the forum. So what is your question here?
call the scripts in the bat file like
bteq < yoursql.txt > yoursql.log 2>&1
I have a text file, which contains the BTEQ script within.
I can able to exeute this file the command prompt.
C:\ BTEQ < myfilename.txt
Now i want to create a batch file (.bat), which should execute the BTEQ scripts which is written inside the text files.
Open an editor
bteq < myfilename.txt > myfilename.log 2>&1
and save it as
you can call this file from an windows cmd window and it will execute your bteq and create a log file.