Skip to Content
0
Jun 23, 2014 at 08:42 AM

Upgrade to release 7.4 - loss-free assignment

124 Views

L.S.,

In Note 1810104 there is this part about OpenSQL. And it states that the SELECT statement must satisfy the rules for loss-free assignment for data type "i". But I have absolutely no clue what this means. Can anyone give me an inside of what this means?

Thanks and best,

Sander

Segment of note 1810104.

Open SQL

A new SQL parser for Open SQL has been introduced for Release 7.40 SP02. This parser checks some rules more strictly than the old parser. In particular, the same parser is now used for statically specified Open SQL and for the content of dynamic tokens. For Release 7.40 SP02, this parser was initially used for the SELECT statement only. As of Release 7.40 SP05, the new parser is used for all Open SQL statements. As a consequence, the following syntax constructs, which have always been incorrect, now trigger syntax or runtime errors as of Release 7.40 SP02 or SP05:

  • As of Release 7.40 SP01, the content of the operand "n" of the additions "UP TO n ROWS" and "PACKAGE SIZE" of the statement SELECT must satisfy the rules for loss-free assignment for the data type "i".