The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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

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...
accept rate: 31%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 29 May '15, 16:37

question was seen: 629 times

last updated: 29 May '15, 17:42