topic Re: Load tables dynamically from SAS in QlikView

Load tables dynamically from SAS

Anonymous — Wed, 10 Jan 2018 08:10:23 GMT

Hi All,

I need to load table name from SAS dynamically. I used the below statement for loading from SQL server.

SELECT "TABLENAME"

FROM P*****T.P*****H."_v_table" ;

But when i m using the same _v_table and tablename with SAS, i m getting the following error :

ODBC error

Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 4294967295, ErrorMsg: [SAS][SAS ODBC Driver][SAS Server] SPDS_NOTE: Correct Syntax for select expression is:

Can someone please let me know what is the exact syantax i should use to get all the tablename.

Thanks!!

Re: Load tables dynamically from SAS

petter — Wed, 10 Jan 2018 12:33:43 GMT

The generic method to get the meta data information when your are using ODBC is to use the statment:

SQLTables;

This will as a single word statement extract all the tables metadata available through the ODBC connection you already have connected to. Have a look here for further info: SQLTables ‒ QlikView

SQLColumns;

will give you the additional column names and column info that could be used too if you need.

More info here: SQLColumns ‒ QlikView

Re: Load tables dynamically from SAS

Anonymous — Wed, 10 Jan 2018 14:00:24 GMT

Hi Petter,

Thanks for your response.

I am loading data from SAS and SQL tables did not work from me.

Fortunately i found a solution which gives me exact what i wanted.

SQL SELECT MEMNAME

FROM X*******Z.DICTIONARY.TABLES

MEMNAME : contains all the table names

DICTIONARY.TABLES : is the metadata

make sure to use this in CAPITAL letters.

Thanks!!