Reputation: 125
I have a bteq file that delete a table.
.LOGON Server/User,Password;
del from Database.table all;
.LOGOFF
.EXIT
This operation works. What I want is to take the user/password from this bteq file, put them in a parameter file and then call them fromp there. Should i create a second bteq file as a parameter file ? and if so how can I declare those parameters and how can i call them ?
Upvotes: 0
Views: 1256
Reputation: 7786
You can use the .RUN command to call an external file containing valid BTEQ commands. In this instance, you would take the .LOGON command along with the credentials and place it in another file. Your BTEQ script above would look like this afterwards:
.RUN FILE={path}/{filename}.{ext};
del from Database.table all;
.LOGOFF
.EXIT
Upvotes: 1