Archives of the TeradataForum

Message Posted: Mon, 01 Mar 2010 @ 16:59:37 GMT

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

In side your For Loop, I am assuming you are using some sorts of Cursor then you need to set your messages as follows:

     FOR LOOPVAR  AS CUR1  CURSOR FOR
     DO
     SET PCG_MSG4='COLLECT STATISTICS ON ' ||LoopVar.PCG_MSG1||'.'||LoopVar.PCG_MSG2|| '
     INDEX (' || LoopVar.PCG_MSG3|| ') ' ;

     CALL DBC.SYSEXECSQL (:PCG_MSG4 ) ;

If you still have problem, I suggest you break the messages and run as Select so that you can see what is the end result of your SQL. This way we can troubleshoot better. Let me know if this worked.

Thanks

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