I need to load a table from a different table which is in the same DB by using TDLOAD
i have a statement
tdload -h 192.168.64.128 -u students -p learning13 -t emp2 -h 192.168.64.128 -u students -p learning13 -t --SelectStmt"select * from emp1 where empname is not null";
emp2 is the target table and emp 1 is source.
Its not working.
in some internet help i found keywords like SourceUserName , SourceUserPassword etc. which is not getting recognozed. How is this done??