cancel
Showing results for 
Search instead for 
Did you mean: 

Variable use in an Update Statement

Former Member
0 Kudos
2,151

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member

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.