4 Replies Latest reply: Nov 5, 2014 3:40 AM by Bill Markham RSS

    Script doubts -RESIDENT,rename ,drop

    Gopi Raju

      EMPTemp:
      LOAD * INLINE [Ename,Employee_number
      'A',1
      'B',2
      'C',3
      'D',4
      'E',5
      'F',6
      ];

      EMP_TBL:
      LOAD
      Ename,Employee_number  AS Emp_number
      RESIDENT EMPTemp;

      drop table EMPTemp;

      Why should I drop EMPTemp?
      Why should I rename Employee_number to other name Emp_number in EMP_TBL?
      What RESIDENT will do?

      I think forum gurus will share more things than product manuals.

      Kindly explain.