topic Re: how to pull all the tables at a time from database in QlikView

how to pull all the tables at a time from database

Anonymous — Mon, 23 Nov 2015 09:13:11 GMT

Hi Guys,

Can any one plz tell how to pull all the tables from database at a time and convert into QVD. PFA,for details about database details.

please provide script for this database.

Re: how to pull all the tables at a time from database

buzzy996 — Wed, 25 Nov 2015 12:21:42 GMT

try some thing like,

tab:

SELECT *
FROM sys.Tables;

store tab into qvdpath\alltables.qvd;

Re: how to pull all the tables at a time from database

effinty2112 — Wed, 25 Nov 2015 13:36:41 GMT

Hi Siva,

Something like

TableNames:

SQL SELECT NAME

FROM SYSTABLES;

Will give you a resident table giving you all the table names in your database. If you want to save the tables to qvd you will need to loop through the tablenames and create a qvd for each one - a qvd holds one table only.

This script to loop through the tablenames could be like below. I haven't tested this and wrote it in a hurry so I suggest caution - start off with For i =1 to 1 or some other low number. It gives the gist of how to do it.

For i = 1 to NoOfRows('TableNames')

Let TN = Peek('NAME',$(i),'TableNames');

[$(TN)]:

LOAD*;

SQL SELECT *

FROM $(TN);

STORE [$(TN)] into $(TN).qvd (qvd);

Re: how to pull all the tables at a time from database

Anonymous — Thu, 26 Nov 2015 05:50:36 GMT

Hi Bro,

i'm getting this kind of error....and my code and error is attached...Please help me out of these problem...

Re: how to pull all the tables at a time from database

buzzy996 — Thu, 26 Nov 2015 09:12:08 GMT

are u created dsn connection for this ans using the same to fetch the data?

Re: how to pull all the tables at a time from database

Anonymous — Thu, 26 Nov 2015 09:25:48 GMT

yes shiva reddy...

Re: how to pull all the tables at a time from database

jagan — Thu, 26 Nov 2015 09:29:22 GMT

Hi,

Check this link

Load all tables in database dynamically

Regards,

Jagan.

Re: how to pull all the tables at a time from database

buzzy996 — Thu, 26 Nov 2015 09:49:18 GMT

i think jagan already shared good one,hope that helps else let me know we can see...

Re: how to pull all the tables at a time from database

Anonymous — Thu, 26 Nov 2015 10:12:53 GMT

I'm tried with that,the thing is here i don't have Information schema.columns .so that it throws an error

Re: how to pull all the tables at a time from database

jagan — Fri, 27 Nov 2015 00:50:42 GMT

Hi,

Information schema.columns is for MS SQL Server database, you can replace that with the euqivalent table in the corresponding database.

For oracle ALL_TABLES ALL_TABLES

For MYSQL - all_tables or SHOW_TABLES

How to List All Tables and Describe Tables in Oracle, MySQL, DB2 and PostgreSQL | OneWebSQL

MySQL :: MySQL 5.7 Reference Manual :: 13.7.5.37 SHOW TABLES Syntax

What is the database you are using?

Regards,

Jagan.