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.
Also, can some one explain me where to go and post our question on this forum?
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
Der Beginn aller Wissenschaften ist das Erstaunen, dass die Dinge sind, wie sie sind.-Aristoteles
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.
So that, i can add that batch file inthe windows scheduler.
Can you please assist me to complete this requirement.
Ultimate intension is to, execute the queries through the windows scheduler...
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.