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

fusionss's gravatar image

fusionss
11111
accept rate: 0%


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.

permanent link

answered 29 May '15, 17:42

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
6.5k2894
accept rate: 29%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×10

question asked: 29 May '15, 16:37

question was seen: 354 times

last updated: 29 May '15, 17:42