|
I need to have a user enter in a number through a prompt in a batch file which I can get to happen but I can't get the isql to come up and run the sql file using the variable number entered in an Update script. set /p QTY=Enter QUANTITY PAUSE dbisql -c "eng=SERVER;dbn=fsms60dw;uid=DBA;pwd=SQL" PAUSE f:\fsms\update.sql |
|
You can use the Interactive SQL PARAMETER statement for this. This is often used to pick up parameters passed in via the cmdline or via the Interactive SQL READ statement but will prompt the user for values if one or more of those are not provided. |
