INSERT & UPDATE

[#1]

Hi Friends,

I NEED TO INSERT,ADD NEW COLUMNS TO MY QVD//

Ex:1 (OLD) TABLE1

EID,ENAME,SAL

1    ,RAFI     ,100

2    ,SHAIK   , 200

STORE TABLE1 INTO TABLE1.QVD;

I Create One Table With Qvd,But i need to insert one record into table like below

3 , ravi  , 300

so how can i insert new records in qvd also

EX;2 TABLE2

EID,ENAME,SAL

1    ,RAFI     ,100

2    ,SHAIK   , 200

STORE TABLE2 INTO TABLE2.QVD;

AND ALSO I NEED TO CREATE ANOTHER COLUMN LIKE

DEPTNO

10

20

30

,

,

SO ANY BODY CAN HELP HOW CAN I INSERT, ADD NEW COLUMNS ALSO TO MY QVD

THANK YOU.

[#2]

You can contatenate easily two tables:

Table1:

Load

     EID,ENAME,SAL

From Table1.qvd;

Concatenate

Load

     EID,ENAME,SAL

From Table2.qvd;

To add another field, you can use the Join sentence.

[soniacoprosa]

Hi,

I made an example.

Regards,