Question Re: Need help with creating a sequence with several parameters in Technology Q&A

Need help with creating a sequence with several parameters

former_member445524 — Tue, 10 Jul 2018 13:08:12 GMT

Hello,

I am trying to create a sequence thus:

CREATE SEQUENCE "stest" START WITH 1, CACHE 32;

but it fails with the error: incorrect syntax near ",": line 1 col 36 (at pos 36).

There is no problem with a single parameter, e.g.:

CREATE SEQUENCE "stest" START WITH 1;
CREATE SEQUENCE "stest" CACHE 32;

According to the SQLScript reference,

<sequence_parameter_list> ::= <sequence_parameter>[{,<sequence_parameter>}...]

What am I doing wrong?

Re: Need help with creating a sequence with several parameters

SreekanthSurampally — Tue, 10 Jul 2018 16:07:09 GMT

there should not be , between parameters, can you try that please

Re: Need help with creating a sequence with several parameters

former_member445524 — Tue, 10 Jul 2018 16:45:37 GMT

Indeed, it works without the comma. But how did you know that? The documentation specifies the comma as parameter separator. I have quoted the relevant part in the post.

Re: Need help with creating a sequence with several parameters

SreekanthSurampally — Tue, 10 Jul 2018 17:05:09 GMT

If I go little below to the syntax part in the documentation, there are examples with multiple parameters use. Actually it avoids confusion around the formats in the syntax if there are any.

Re: Need help with creating a sequence with several parameters

former_member445524 — Fri, 17 Aug 2018 09:10:06 GMT

The confusion is stark serious, Sreekanth, for the grammar in the HANA documentation is wrong. Correct examples do not help at all but only make the documentation internally inconsistent.