Hello , 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. It says Invalid option: --SourceTdpId. etc....
How is this done?? Any helps. Thanks Aravind