ODBC data fetching.

[#1]

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,

HJ

[ramasaisaksoft]

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.

[#3]

Hi Seo,

Try to avoid the unwanted fields in table.

[el_aprendiz111]

Hi,

First 100 //200-300 1000
SQL SELECT *

[vishsaggi]

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