illegal combination of prefixes

[#1]

Hi

I am confused.  Annoyingly I have encountered this error message before but can not for the life of me remember what I did to solve the issue.

So when I reload the script I get the overly dramatic error message "Illegal combination of prefixes".  To get the script to load without error I remove the word in bold (mapping)???  This obviously defeats the object so could someone advise what/why this error is?

I originally had a more concise LOAD script doing the Order By in the mapping load but due debugging I split it into a separate section for clarity.

Essentially I am concatenating 2 tables (3 fields in each) - sorting them and then just reloading the sorted and complete table with only 2 fields to create the mapping table...?

tempEmpData:

LOAD

    EMPNO,

    EMPSN,

    PCPDAT

;

SQL

    SELECT

    EMPNO,

    EMPSN,

    PCPDAT

FROM

    SAAPAYDTA.PAYHISTP

;

//Concatenate(tempEmpData)

LOAD

    EMPNO,

    EMPSN,

    PCPDAT

;

SQL

    SELECT

    EMPNO,

    EMPSN,

    PCPDAT

FROM

    SAAPAYDTA.MONHISTP

;

tempEmpData_Sorted:

NoConcatenate

LOAD

    *

RESIDENT

    tempEmpData

ORDER BY

    PCPDAT DESC,

    EMPNO

;

DROP FIELD

    PCPDAT

;

DROP TABLE

    tempEmpData

;

tblmap_Test:

NoConcatenate mapping LOAD * RESIDENT tempEmpData_Sorted; // ORDER BY PCPDAT DESC, EMPNO;

DROP TABLE

    tempEmpData_Sorted

;

Many thanks

Oli

[simenkg]

Just remove NoConcatenate.

[rubenmarin · Accepted solution]

Hi Oli, remove the "NoConcatenate" before the "mapping" and it should work.

Also, mapping table only uses firsts two fields, the first for keys to search and the second for values to return in applymap, you can rename the two fields you want to use if the problem is autoconcatenating.