3,175
Hi, i need to pack all the records of a temp table into a container.
I need this so that i can unpack and create temp table on another tier (client).
Thank you
Santosh.
*This post is locked for comments
linkPhysicalTableInstance() doesn't pack or send anything - it merely connects an AX buffer (X++ variable) with a table instance in TempDB database.
all the records means there is no limit. if you want to take it in container, it could give overflow in some scenario when data will be huge. It is not a good practice. so if your code in client tier if you are using im-memory table, it should not pass as argument in server tier. Please make the table property tempDb and use it in server tier for unpack.
use tmpTable.linkPhysicalTableInstance(table) to pack it and send.
If you use a TempDB temporary table, it exists neither on client nor on AOS - it's in TempDB database on database server. What you're talking about makes sense for InMemory tables only.
Bhaskar, i would want pack all the records not just one.
Martin, even in the case of TempDB table, isn't it better pack it in a container and unpack it another tier instead passing it by Ref ?
Regards
Santosh.
Why don't you simply use a TempDB temporary table?
What you're trying to do sounds like wasting of resources to me.
#1
André Arnaud de Cal...
294,283
Super User 2025 Season 1
#2
Martin Dráb
233,025
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
