Syntax

[deepakqlikview_123]

Hi All,

Is below syntax is correct,please suggest.

Retail:

NoConcatenate

load

*

Resident Dealer1;

DROP Table Dealer1;

Concatenate(Retail)

LOAD * Resident EnquiryMaster;

DROP table EnquiryMaster;

Thanks,

Deepak

[Anonymous]

Hi,

There is nothing syntactically wrong here. I dont know your requirement. If your doubt is only about syntax then its ok. There will be no errors while reloading.

HTH

Ravi N.

[#3]

Ya sure the script works fine. it will concatenate with retail ( you can see in table viewer)

but  i think it will show a error like

Table not found

Concatenate(retail)

LOAD

*

Resident EnquiryMaster;

[sasikanth]

Yes

Your doing

NOconacatenate Load for RETAIL table and

below your doing concatenate with Retail table again

i think this is not correct

[PradeepReddy]

If the fields in the table Retail and EnquiryMaster are same then it will be throw an error.. stating that the table 'Retail' is not found.

Reason: EnquiryMaster and Dealer table are Concatenated, and Dealer table is no more exits, so no data will be copied to 'Retailer' table as consequence Retailer table won't exists.

If the fields are different in both tables, Please provide a sample script.

[richard_pearce6]

Retail is loaded 'NoConcatenate' so it will load a new table even thought the fields are the same as its a load *