easy loader

Database
Enthusiast

easy loader

Hi All -

I am trying to load the data from one tabl to another table which on 2 different servers by using the easy loader commnd as below

tdload 'sel * from src_table;' src_tdpid src_user src_pwd -t tgt_table -u tgt_user -p tgt_pwd -h tgt_tdpid

but i am getting error as

TDLOAD: TPT05502: Error: Invalid syntax.  Hyphen is expected before 'sel

Can some please help me here to correct the commnd.

Thanks

2 REPLIES
Teradata Employee

Re: easy loader

Include the other option names in front of the values (all on one line)

tdload --SelectStmt "sel * from src_table;" --SourceTdpID src_tdpid --SourceUserName src_user --SourceUserPassword src_pwd -t tgt_table -u tgt_user -p tgt_pwd -h tgt_tdpid

Enthusiast

Re: easy loader

Thank you fred it is working fine when i pass the values through jobvar file.