SELECT... INTO... in SQLSCRIPT

[Former Member]

Hi All,

In SQLScript, if I declare a local variable and use "select...into..." to assign value to it, is that declarative or imperative logic?

And how does that affect parallelism?

According to the SQLScript guide, this is imperative. But isn't a select statement declarative?

Thanks in advance.

Regards,

Jason

[Former Member · Accepted solution]

A select into statement can be applied to a local table variable with no loss of parallelism. But this is different to a select into a local scalar variable because Hana doesn't have an equivalent to select single. To do this would push you out of parallel mode.

[Former Member · Accepted solution]

Thanks!