cancel
Showing results for 
Search instead for 
Did you mean: 

Global Temporary Tables in Sybase 16 SP02 PL04 HF1

Former Member
0 Kudos

It looks like Global Temporary Tables are available properly in Sybase 16 SP02 PL04 HF1.

Essentially, these look like a normal table but the data is only visible in a session.

see https://archive.sap.com/discussions/thread/3928146

under the covers, you create a temp table and it creates proc at the same time with the name of the table with a _<objectid>.

Inserting into the global temp table then creates a temp table.

All really good - but no documentation on it.

Why no documentation ?

Accepted Solutions (1)

Accepted Solutions (1)

dan_thrall
Participant
0 Kudos

Hi Mike,

The Global Temporary Table ability is not fully available as a feature until at least SP03 (as of this writing, subject to change) which is why you do not see any documentation on this.

Answers (5)

Answers (5)

Former Member

Kiran,

You could be right - but from Googling I think Netweaver can work with HANA and ASE (and others).

And if Netweaver supports Global Temp table - then it would have to be added to ASE. Hence my query, was it Netweaver that requested the change to ASE ? If so its a great change - really, really useful functionality.

Its still buggy - though - sp_rename on a global temporary table will crash ASE.

Former Member

Carine,

I'm using ASE - don't know anything about NetWeaver ABAP.

Is NetWeaver ABAP built on ASE ? Were the Global Temp tables added to ASE for this purpose ?

Thanks

Mike

CarineTchoutouo
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Mike,

sorry, this is a confusion from my side.
I though the question was related to the ABAP application server running on top of SAP ASE database, but this is not the case. I don't have any input regarding your issue.

Kind regards,
Carine

former_member187136
Contributor
0 Kudos

Hi Mike,

I think Carine confused with the terminology "Global temp table" with that of ABAP.

As the link specifies"you can create a definition of a temp table. The actual underlying temp table will get create as you insert into it and will be local to the session". I don't think this related to ABAP/NW. This is Sybase ASE 16.0 feature.

This is separate concept in that of SAP ASE database which may be helped for the SAP application.

Kindly correct me if I am wrong.

Regards

Kiran K Adharapuram

CarineTchoutouo
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Mike,

Global Temporary Tables (GTT) have been introduced with ABAP 7.5.
Find more information about it in the ABAP Keyword Documentation.
https://help.sap.com/abapdocu_750/en/abenddic_database_tables_gtt.htm

Kind regards,
Carine