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
asked 29 May '15, 16:37
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.
answered 29 May '15, 17:42
Nick Elson S...