Is there anyway to use session write collection on a v8 tmp table?
I need to construct some data and then update fields on a tmp table, but doing it using a sqlexec and for each loop just takes a long time. I was thinking if I could just somehow to a session write collection and make a single update rather than 1000.
Hi @o_x,
I think it is not possible to use session write collection on workflow temp tables, since those aren't linked to any data schema. These tables are temporary tables created only during execution so the write APIs don't apply.
The best approach is to avoid row by row updates and use a single SQL update statement or even an enrichment to calculate or join the necessary data in one step. If you want to apply the write collection, it will only work with permanent schemas.
I share with you some useful doc:
Session methods API documentation
Hope it helps. Don't hesitate to come back if any doubt arises.
Best,
Celia
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.