3 Replies Latest reply: Jun 14, 2011 10:02 AM by Miguel Angel Baeyens de Arce RSS

    Field not found <>

      I'm trying to perform a load on this sql select but keep getting an error when referring to any of the fields in the select

      // INSTRUCTOR

      Load
      *,
      instructor_d_id as test;
      sql select instructor_d_id, di.sis_contact_id instructor_sis_id,
      di.instructor_first_name||' '||di.instructor_last_name instructor_name,
      di.instructor_first_name,
      di.instructor_last_name,
      di.instructor_highest_ed,
      di.instructor_highest_ed_major,
      1 as instructor_counter
      from instructor_d di;

       

      ERROR:

      Field not found - <instructor_d_id>

      sql select instructor_d_id, di.sis_contact_id instructor_sis_id,

        di.instructor_first_name||' '||di.instructor_last_name instructor_name,

        di.instructor_first_name,

        di.instructor_last_name,

        di.instructor_highest_ed,

        di.instructor_highest_ed_major,

        1 as instructor_counter

      from instructor_d di

       

      The SQL select along works fine and if I just do a load * (no really purpose - just a test) it also works but I can't reference any of the fields?

      I've tried putting the field in " ", in [ ], in <>, no carriage return etc... I can't think of what I'm missing.  Can some assist me in this?  Thank you.

      The is an Oracle data base if that makes a difference.