Archives of the TeradataForum

Message Posted: Wed, 14 Mar 2007 @ 13:10:11 GMT

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

You could use dbc.SysExecSQL. Prebuild the string, including the variables and then submit it.

     set vs_system_view = v_cr_part1 || col_string1 || v_cr_part2 ||
        col_string2|| v_cr_part3 ;

     set vs_system_view = trim(both from vs_system_view);

     call dbc.SysExecSQL( :vs_system_view );

Vince Bernard
Teradata
Certified
Administrator

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