Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Know values of ODBC


recently I try to know haw can I see the value of a ODBC in QV.

I explain my problem, a client want to know in witch database the application work.

The name of ODBC is 'ODBC1','ODBC2', ... but the value is VISI001 or LISI001 and he want to store this value in QVD.

Can we do that in QV ?



PS : Sorry for my english, i'm french

1 Reply
Not applicable

Re: Know values of ODBC

i just found the solution :

load * ;
select current server
from sysibm.sysdummy1

STORE DB_NAME into ..\data\out\DB_NAME.qvd (qvd);