odbc connection via parameter

A

acxy-1

Hello, Is there any way to connect to a table using via ODBC using a
parameter? I'd like to prompt a user like "please enter a batch key"
and that value would then go out to the database via ODBC and look for
basically: "batch_key*warehouse*" or "batch_key*newusers", etc. Right
now I can manually connect using the linking option and a file dsn, but
I've not used the 'dsn-less' option. Can someone give me an example
syntax skeleton string as well?

Any help on this would be greatly appreciated! Thanks.
 
Top