Skip to Content
0

SAP HANA SAP HANA XSA: Need help for creating a collection with .hdbcollection

Apr 20 at 02:53 PM

91

avatar image

Hi,

tried to create a collection by the artifact .hdbcollection.

Is there somewhere a sample where I can look for the syntax?

This docu didn't help me.

https://help.sap.com/viewer/4505d0bdaf4948449b7f7379d24d0f0d/2.0.02/en-US/fe16b635277c4aea825c72973f159359.html

Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dirk Raschke Apr 21 at 11:49 AM
0

This works: COLLECTION TABLE "namespace.db::MP"

Share
10 |10000 characters needed characters left characters exceeded
Thomas Jung
Apr 20 at 05:57 PM
0

It uses the SQL DDL syntax which is documented here:

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.02/en-US/ff13273610a54708bc027c107f2aa49b.html

But essentially the CREATE COLLECTION <name> is all there is to it. There is no structural definition as it takes on the key value properties of the JSON you insert into it.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

COLLECTION TABLE "NewSPS03.db.MP"

I'm struggling still with the namespace. Tried different possibilities, but always an issue with the namespace.

Tried it with and without the namespace.

(Tried also to set "ignore", but when I was building the db-modul I was asking again for the namespace.)

0

This works COLLECTION TABLE "NewSPS03.db::MP"

Didn't use the :: because the error msg was saying that.

0