Archives of the TeradataForum

Message Posted: Wed, 29 Aug 2007 @ 23:21:02 GMT

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

Hi,

In further testing of the Tpump, I observed one weird thing today. The problem seems to be with the macros getting invoked.

I did the following:

a) Took the DDL of a table that was successfully getting loaded and recreated the same in the testing database

b) Took the macro which currently loads into the table and recreated the same to point to the above recreated table and executed this macro in the same testing database

c) Modified the Tpump to just use the new macro. No additional fields were added. This modification to use the new macro was done by commenting the lines where the old macro was getting invoked and adding a couple of lines which executed the new macro. Both macros are anyway identical and only point to two different tables which have identical structure.

When I ran the tpump with the new macro, neither the original table nor the new table got loaded. And then I just removed the comments from the original macro invocation statement, applied the comments to the new macro invocation statement and ran the same tpump, and the original table got loaded.

I tried various iterations like deleting and recreating the mq, then recompiling and linking the c program and then running the tpump, but all gave the same result. I also checked if the macro was working by hardcoding the parameters in sql assistant and executing the macro and that successfully loaded the row into the new table.

Is there some parameter which needs to be specified in tpump for which macro to use? If so where is is specified. In the exec macro statement, I am pointing to the new macro, but still, it does not seem to be getting executed.

thanks and regards,

Ramaswamy

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