Using variable for lib-Connection

[mruehl]

I want to store a specific Data Connection into a variable so that I can do the following:

LIB CONNECT TO 'vODBC';

vODBC is the variable.

I need this for looping through different ODBC Sources.

The problem is, I don't get the right syntax, just $(vODBC) does not work.

Thanks in advance!

[Anil_Babu_Samineni]

Perhaps this?

SET vODBC = 'Connection String';

and then,  LIB CONNECT TO '$(vODBC)';