Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Looking for a script code to save my qvd into Teradata/Oracle data base.
My requirement is to take the back up of my old qvd file to taradata.
Thanks,
Ragi
Hi,
I believe you need QlikView Expressor to do this.
Regards
ASHFAQ
Hi,
it should be possible during reload, with SQL statement.
regards
Darek
What?
SQL INSERT .... should work
And how you're gonna INSERT records of a whole QVD file??
Of course you can code a single INSERT statement (maybe loop) if you have a connection with the rights to write back but you'll never will get a repsonse if it was succesful from the db thru the ODBC/OLEDB connection..
Shooting from the hip here but read in a QVD, save the table to a csv file and using TPT or some importing process load the data back into the database? Basically just dump the data out and use another tool to get it into the database.
Hi Venkata,
there are only a few tools around which can read an process QVD files externally to push data somewhere. The most easy way seems to be to load the QVD file into QlikView, store it as txt file (csv) and then load the txt file with the available database loader or ETL tool.
- Ralf
whole QVD ... hmm, of cours i thought about rows
but full file i hope from VB script should be possible
maybe this will help:
community.oracle.com/thread/195148?start=0&tstart=0
What do you think about concatenation on QV script side, put it as param into stored procedure and insert inside database ?