how to put all the records of a temp Table into a container ?

(0) Share

Report

Posted on by San Artham

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

I have the same question (0)

All responses (8)

Answers (1)

5400 7,162 on at

Like (0)

Report

RE: how to put all the records of a temp Table into a container ?

take temp table data in common buffer.

buffer2con(common)

Was this reply helpful? Yes No
Martin Dráb 236,336 Most Valuable Professional on at

Like (0)

Report

RE: how to put all the records of a temp Table into a container ?

Why don't you simply use a TempDB temporary table?

What you're trying to do sounds like wasting of resources to me.

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

RE: how to put all the records of a temp Table into a container ?

again you have to do common = con2buf(container) after passing to server site.

Was this reply helpful? Yes No
San Artham 3,175 on at

Like (0)

Report

RE: how to put all the records of a temp Table into a container ?

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.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 236,336 Most Valuable Professional on at

Like (0)

Report

RE: how to put all the records of a temp Table into a container ?

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.

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

RE: how to put all the records of a temp Table into a container ?

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.

Was this reply helpful? Yes No
Martin Dráb 236,336 Most Valuable Professional on at

Like (0)

Report

RE: how to put all the records of a temp Table into a container ?

linkPhysicalTableInstance() doesn't pack or send anything - it merely connects an AX buffer (X++ variable) with a table instance in TempDB database.

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

RE: how to put all the records of a temp Table into a container ?

Hi Martin,

yes, Just i provide the method because tmpTable won't work with .setTmp(). if he needs to to carry the data in different instance, he should use above function.

Thanks

Bhaskar

Was this reply helpful? Yes No