How to perform SQL query on QVD

[Jacob]

Hi all,

I want to perform sql query on qvd file .how can i do it 

Anyone can help

Below is SQL query:

CREATE OR REPLACE VIEW pushed (country,anx_count )
AS
SELECT SUBSTR(t1.name,0,2) AS country,
  COUNT(SUBSTR(t1.name,0,2)) anx_count 
FROM t_table2 t2,
  t_table1 t1
WHERE t2.date BETWEEN add_months(trunc(sysdate,'mon'),-1) AND trunc(sysdate,'mon')-(1/86400)
AND t2.bname_id = t1.name_log_id
GROUP BY SUBSTR(t1.name,0,2)

Note

I dont have SQL Connection I am working on QVD.

[dapostolopoylos · Accepted solution]

You cannot manipulate a qvd file with SQL...
The only way is to use a Load statement.

[Wilson_Webb]

You cannot use SQL syntax to load a QVD. The best way I can think around this for you to script in sql and store into a qvd. This way the QVD has all the necessary transformations you needed.

Let us know if this makes sense.