Archives of the TeradataForum
Message Posted: Tue, 21 Feb 2001 @ 03:35:35 GMT
| Subj: || || Re: Vartext and instr |
| From: || || James Judge |
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.