TDLOAD(TPT easy load)

General
Teradata Employee

TDLOAD(TPT easy load)

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