Archives of the TeradataForum
Message Posted: Mon, 01 Mar 2010 @ 16:59:37 GMT
| Subj: || || Re: Regarding Dynamically collecting the Stats |
| From: || || Mohommod.Khan |
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
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.