7 Replies Latest reply: Apr 19, 2011 7:53 AM by Jonas Moellerhoej RSS

    Creating a qvd file per for each table in an Oracle database

    Jonas Moellerhoej

      Hello,

      We have just started using Qlikview in our organisation and I am struggling a bit with a load script

      What is working is :

      run a piece of sql to show all the tables owend by a certain user and create a string for each

      The script is a follows

      ODBC CONNECT TO.......

       

      MAXIMO_LOAD_SCRIPT:

      LOAD *;

      SQL SELECT 'MAXIMO.'|| table_name ||':' || ' '|| 'LOAD * ; SQL SELECT * FROM' ||' '|| 'MAXIMO.'|| table_name ||';' ||' ' || 'STORE'||' ' || 'MAXIMO.'|| table_name||' '||'INTO C:\TEST\MAXIMO_QVD\MAXIMO.'||TABLE_NAME||'.QVD'||';' AS LOAD

      FROM ALL_TABLES

      where owner = 'MAXIMO'

      and table_name not like '%$%'

      AND TABLE_NAME IN ('ASSET','ACTION');



      The output of the above is

      MAXIMO.ACTION: LOAD * ; SQL SELECT * FROM MAXIMO.ACTION; STORE MAXIMO.ACTION INTO C:\TEST\MAXIMO_QVD\MAXIMO.ACTION.QVD;

      MAXIMO.ASSET: LOAD * ; SQL SELECT * FROM MAXIMO.ASSET; STORE MAXIMO.ASSET INTO C:\TEST\MAXIMO_QVD\MAXIMO.ASSET.QVD;

      Where I am struggling is the next step.

      I want pass these values into a new file which can be run on a schedule and the idea is that all the specified tables will be extracted as qvd files

      is this even possible?