Unknown Statement

[bharatkishore]

Dear All,

I have written the following code and i am getting an error i.e. unknown statement..I don't know where i have been wrong. Can you pls help me on this..I am also attaching the image for your reference.

Classification1:

LOAD nId,

    dDateUpdated,

    "sys_created_by",

    "sys_created_on",

    "sys_id",

    "sys_mod_count",

    "sys_updated_by",

    "sys_updated_on",

    "u_active",

    "u_classification_0",

    "u_classification_1",

    "u_classification_2",

    "u_classification_3",

    "u_classification_4",

    "u_classification_5",

    "u_classification_6",

    "u_classification_7",

    "u_classification_8",

    "u_classification_9",

    "u_classification_path",

    "u_contract",

    "u_external_reference",

    "u_filter_tag",

    "u_force_path_update",

    "u_full_name",

    "u_instructions",

    "u_name",

    "u_number",

    "u_parent",

    "u_realm",

    "u_review_comments",

    "u_review_required",

    "u_selectable",

    "u_service_type",

    "u_short_description",

    "u_transaction_id",

    "u_transaction_source",

    "u_type",

    "u_visible_downwards",

    nDeleted,

   "u_customer_integration_id";

SQL SELECT *

FROM "ODS_ITSM".dbo."ITSM_Class_u_classification";

Classification:

LOAD"sys_created_on" as Classification_created_on,

    "sys_id" as Classification_key,

     u_name as Classification_name,

     u_service_type as Classification_S_type,

     u_type as Classification_type,

    "u_classification_0",

    "u_classification_1",

    "u_classification_2",

    "u_classification_3",

    "u_classification_4",

    "u_classification_5",

    "u_classification_6",

    "u_classification_7",

    "u_classification_8",

    "u_classification_9"

     Resident Classification1;

DROP Table Classification1;   

Regards,

Bharat

[tresesco]

Put a space after LOAD and try, like:

                                                                 LOAD  "sys_created_on" as Classification_created_on,

[jagan · Accepted solution]

Hi Bharat,

Give space after LOAD keyword.

Classification:

LOAD "sys_created_on" as Classification_created_on,

Regards,

Jagan.

[danieloberbilli]

Could it be the from sql line?

FROM "ODS_ITSM".dbo."ITSM_Class_u_classification";

[danieloberbilli]

sometimes the mistake can be in the load / command before the indicated error

[jonathandienst]

I think the previous posts should address your problem, but I noticed that the LOAD statement could be simplified quite a lot. This will replace all the code you posted:

Classification:

LOAD

  sys_created_on as Classification_created_on,

  sys_id as Classification_key,

  u_name as Classification_name,

  u_service_type as Classification_S_type,

  u_type as Classification_type,

  u_classification_0,

  u_classification_1,

  u_classification_2,

  u_classification_3,

  u_classification_4,

  u_classification_5,

  u_classification_6,

  u_classification_7,

  u_classification_8,

  u_classification_9d;

SQL SELECT *

FROM ODS_ITSM.dbo.ITSM_Class_u_classification;

[bharatkishore]

Thanks Jagan...I just forget...