I have a scheduled job in Control M which runs a bteq to insert the data in staging table. But when it runs through control M , it gives 2616: Numeric overflow occurred during computation error. However, when i execute the same insert through TD SQL assistance or run the bteq script manually, the data gets loaded into that table.
Can you please let me know why it is giving error when schedule to run in Control M.
can you share the bteq log of the controll M BTEQ run and the manually executed BTEQ run?