Error While debugging ?

[#1]

Garbage after Statement how to reslove ?

[#2]

looks like missing the ; at the end

[#3]

Semicolon (;) is there, Some thing was the Error...

[mjayachandran]

Can you post the script so that we can try to help you. Its bit difficult to debug without seeing the script.

[antoniotiman]

Hi Helen,

are You sure field is ITED_TED_CODE ?

[#6]

Yes, ITED_TED_CODE  is field...

[#7 · Accepted solution]

Hi Helen,

The "order by" should be from a resident load.

try like this:

T1:

load ...

group by ...;

T2:

noconcatenate

load *

resident T1

order by ...;

drop table T1;

[#8]

Hi,

ITED_TED_RATE  field should be removed from group by .