This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I need to load table name from SAS dynamically. I used the below statement for loading from SQL server.
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 :
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 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
MEMNAME : contains all the table names
DICTIONARY.TABLES : is the metadata
make sure to use this in CAPITAL letters.
View solution in original post
The generic method to get the meta data information when your are using ODBC is to use the statment:
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
will give you the additional column names and column info that could be used too if you need.
More info here: SQLColumns ‒ QlikView