resident load con-cat.

[Anonymous]

Hi,

I have a issue with concatenating two tables of different data base,please try to resolve it.

Table A is from data base which i loaded from include files and Table B is loaded from excel file,

i need to concatenate this two  tables such That Table B fields should reflect in Table A.

i need to use resident load to do this and i don't have much knowledge on resident load.

Thanks in advance.

[sunny_talwar]

Can you share your current script? So that we can give specific instructions?

[amayuresh]

This may help you to understand the Resident Load and Concatenate,

[Table 1]:

LOAD * FROM [Table 1 ...];

[Table 2]:

LOAD * FROM [Table 2 ...];

[Table 3]:

NOCONCATENATE

LOAD * RESIDENT [Table 1 ...];

<CONCATENATE / JOIN>

LOAD * RESIDENT [Table 2 ...];

DROP TABLES [Table 1], [Table 2];

[Anonymous]

Table A:

load * from include file;

Table B:

load * from excel;

Table C:

noconcatenate

load * resident Table A;

Drop table Table A:

Concatenate

laod * resident Table B;

Drop table Table B: