Sample Header Ad - 728x90

BCP cannot read table created in the same transaction when executed from Control-M

0 votes
1 answer
259 views
How to export global temp table using BCP when original process locks table for BCP? We created our own exporting procedure where we provide SELECT or table_name and procedure stores data to global temp table, which then BCP utility exports. It runs fine, but when we run it from BMC's Control-M system, there is schema modification lock on the table and procedure just waits for itself to unlock. Static table(s) is not a good solution for us. We tried using for example self linking linked server or index on all columns of global temp table. Our current proposal is to add export to a queue which would then be exported asynchronously by another process.
Asked by owl (310 rep)
Feb 17, 2021, 02:30 PM
Last activity: Jul 16, 2021, 09:22 AM