Using variable for lib-Connection

ManuelRühl — Sat, 16 Nov 2024 20:10:36 GMT

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!

Re: Using variable for lib-Connection

Anil_Babu_Samineni — Thu, 29 Aug 2019 13:03:13 GMT

Perhaps this?

SET vODBC = 'Connection String';

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