Resolution:
In patch 3 of TIBCO adapter for teradata 4.1.1, an enhancement is available to turn on/off the prepare feature.This enhancement can be made use of, by making any one of the following entries in the adapter .tra file

tibco.clientVar.TDT_NoPrepare true  (To turn off the prepare feature)
tibco.clientVar.TDT_NoPrepare false (To turn on the prepare feature)

This feature is available with TIBCO Adapter for Teradata 5.2.0 and the corresponding FAQ associated with 5.2.0 version is FAQ1-45835E. However, this feature is not available with TIBCO Adapter for Teradata 5.1.0 version.