Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

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

hi,

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 ?

Regard,

Adrien SENEGAS

PS : Sorry for my english, i'm french

1 Reply
Not applicable

Re: Know values of ODBC

i just found the solution :

DB_NAME:
load * ;
sql
select current server
from sysibm.sysdummy1
;

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