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.
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