Archives of the TeradataForum

Message Posted: Tue, 21 Feb 2001 @ 03:35:35 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Specifying "vartext" assumes a field delimiter between fields. If this is true then this could be a little easier. Thinking that you should be able to redefine the last VARCHAR FIELD with additional FIELD stmts for each different value. Also assuming that each different value has some value type header in variable data. If so you could have an APPLY for each case pointing to the different UPSERT label(s) for each type of field data. Haven't tried this, so this is just an educated guess on my part.

	<Prev	Next>		<<First	<Prev	Next>	Last>>