using update else insert statement in tpt script

Tools & Utilities
Highlighted

using update else insert statement in tpt script

Hi All,

 

can we use update else insert statement in apply statement of tpt script which is using update operator . i am planning to use case condition ,based on that  i want to do update else insert in 3 target tables.The data is getting from one source file.

 

please let me know the syntax if its possible to use?

 

Thanks

Sivakrishna

1 REPLY
Teradata Employee

Re: using update else insert statement in tpt script

The APPLY clause (for each target table) should have one UPDATE statement followed by one INSERT statement and the INSERT FOR MISSING UPDATE ROWS modifier.

See the TPT User Guide and the PTS00004 example (in the sample directory where TPT is installed).