Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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);