Archives of the TeradataForum

Message Posted: Wed, 11 Oct 2006 @ 21:12:02 GMT

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

Fachtna,

Something I've tried in the past that helped 'overcome' the 255 character limit, was inserting the Dynamic SQL into a table (could be a volatile table).

I inserted the Dynamic SQL line for line (instead of using Carriage Return) (and using an extra column in my Dynamic SQL table to keep the order straight), then BTEQ Exported the Dynamic SQL from the table (using SELECT and ORDER BY) and IMPORTING/running it in the next step.

Not sure if something like this will work for you, just thought I'd throw it out there...

Johannes de Wet
UnumProvident Corportaion

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