Help need on Extracting data from database to QVDs

[bhavvibudagam]

Hi Experts,

Can any one please help me on below Two requirements.

In my Data base Daily jobs will run like below.

When I have extracted the jobs from database to QVDs on today 17/02/18 I have to extract only from today to last 8 days jobs from data base to QVDs i.e., Total 9 QVDs

1. A180209_AJOB

2. A180210_AJOB

3. A180211_AJOB

4. A180212_AJOB

5. A180213_AJOB

6. A180214_AJOB

7. A180215_AJOB

8. A180216_AJOB

9. A180217_AJOB

When I have extracted the jobs on tomorrow 18/02/18 I have to extract only from today to last 8 days jobs from data base to QVDs i.e.,

Total 9 QVDs

1. A180210_AJOB

2. A180211_AJOB

3. A180212_AJOB

4. A180213_AJOB

5. A180214_AJOB

6. A180215_AJOB

7. A180216_AJOB

8. A180217_AJOB

9. A180218_AJOB

How to automate this process please help me on this

Thanks in advance.

[shiveshsingh]

What's the script that you are using?

You can put a filter to take only latest 9 values from max date.

[markp201]

Since it is a set number of days, you can setup a FOR loop

Output:

FOR vDay = 1 to 8

  ExtractDay=today() - vDay + 1

  SELECT

     *

  FROM

     "A" & ExtractDay & "_AJOB"

NEXT

One qvd/day or one qvd/all days?

For tomorrow is yesterday's data rebuilt or do you append?