topic ODBC data fetching. in QlikView

ODBC data fetching.

Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I already connected ODBC channel. But because ODBC data is too big, it takes forever to fetch it by pressing Control + R in script.

How can I make ODBC data smaller as I want before fetching anything?

Thank you in advance,

ramasaisaksoft — Tue, 10 Jan 2017 12:11:11 GMT

Hi Hojun,

which data base you are using?

just take less records from the table and check like SQL Query.

sql select top 10 * from xyz;

or else use where condition in your script.

better to create qvd's individually then fetch data from qvd's.

Tue, 10 Jan 2017 12:22:15 GMT

Hi Seo,

Try to avoid the unwanted fields in table.

el_aprendiz111 — Tue, 10 Jan 2017 14:41:10 GMT

Hi,

First 100 //200-300 1000
SQL SELECT *

vishsaggi — Tue, 10 Jan 2017 14:54:43 GMT

Hows does your script look like can you share if possible ?