Join Load Statement and SQL Query

[krishnacbe]

Hi

I have a list of Job numbers in a QVD. I have to fetch data from a SQL table where the job number exist in QVD. I have to store the data from SQL query into a QVD no need to store data from QVD. Only for checking condition I need to use the QVD.

QVD Data

JobNo

A

B

C

SQL Data

JobNo	Values	Date
A	1	3/12/2012
B	2	4/12/2012
C	3	5/12/2012
D	4	6/12/2012

Please help me to write the script for fetching the related data (A,B & C) and store that in a QVD.

Thanks in advance

Regards

Krishna

[shree909]

Hi, try this

Temp:

load from qvd;

concatenate(Temp)

load from sqldata;

store temp into  filename.qvd(qvd);

drop table temp;

so the new qvd will be created and stored in a filename which has all the rows from 2 taqbles

if you want only A,B, C  then use inner join instead of  concatenate.

[krishnacbe]

Hi Shree

Thanks for your fast reply.

In my QVD i have huge data. If I concatenate the reloading time will be more. for example I have 3,376,538 records in QVD. if i use the example given above it will load 3,376,538 records but related data is only around 15,000.

Thanks

Regards

Krishna

[shree909]

i think that is only one time process use join function depening on ur requirement and create another qvd which has both tables.

but reloading from qvd will be fast.