I have a db that must be optimised due to the size of the data in it. I would LOVE to switch to non optimized but then the db max size limit is exceeded.
The optimized db is also in the load memory.
I am reading a section of the db from load memory into the working memory.
(It is a recipe library which contains variables for machine function.)
Let's say this is db1.
L recipe number
T index
I load db1[index] into the working memory db2[1] using "read DBL"
This works fine. (If both source and destination are both optimised or not optimised. )
After the batch is finished I want to clear the data in db2 to avoid any stale data and to avoid accidentally using the wrong recipe for the next batch.
I can't find a fill or clear function that will work with an optimised block.
I also can not address the block with an ANY pointer so I can not write it myself. "You cannot access an optimised memory area from this location."
So how do we clear or fill the data in optimized db db2, the destination block?
edit:
both source db1 and destination db2 are the same data type "udt recipe"
db1 has an array of 20 "udtrecipe" need to move one of those into working memory at db2.
The optimized db is also in the load memory.
I am reading a section of the db from load memory into the working memory.
(It is a recipe library which contains variables for machine function.)
Let's say this is db1.
L recipe number
T index
I load db1[index] into the working memory db2[1] using "read DBL"
This works fine. (If both source and destination are both optimised or not optimised. )
After the batch is finished I want to clear the data in db2 to avoid any stale data and to avoid accidentally using the wrong recipe for the next batch.
I can't find a fill or clear function that will work with an optimised block.
I also can not address the block with an ANY pointer so I can not write it myself. "You cannot access an optimised memory area from this location."
So how do we clear or fill the data in optimized db db2, the destination block?
edit:
both source db1 and destination db2 are the same data type "udt recipe"
db1 has an array of 20 "udtrecipe" need to move one of those into working memory at db2.
Last edited: