Hi All,

Is there some way in which we can get values for a variable at runtime
from the user in sybase?
Something of the sort what '&' does in oracle.

Nitin

"Nitin Bansal" <nitin.bansal (AT) gmail (DOT) com> wrote

select @variable_name


HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

No. isql does not have the ability to query the user at run-time. There
is no equivalent to Oracle's &.

You have two options:

1. You can turn your isql batch into a stored procedure and then call
the stored procedure.

2. You can use keywords in your SQL and use a program like
DBPowerSuite's psSQL to replace keyword values as the program executes.

Brian
http://www.dbpowersuite.com




"Nitin Bansal" <nitin.bansal (AT) gmail (DOT) com> wrote