topic SQL syntax issue when selecting from edid4 in Application Development and Automation Discussions

SQL syntax issue when selecting from edid4

walkerist79 — Mon, 20 Mar 2023 15:02:58 GMT

Hi, I was encountering issues with this query. Not sure how to solve it.

 SELECT *
 FROM edid4
 WHERE segnam = 'E1EDK03'
 AND docnum = '0000123'
 AND segnum = '000009'
 INTO @DATA(lt_edid4).

This Open SQL statement uses additions that can only be used when the

fixed point arithmetic flag is activated (such as CASE expressions or

host variables in expressions).

Re: SQL syntax issue when selecting from edid4

Ryan-Crosby — Mon, 20 Mar 2023 15:06:33 GMT

Hi Wane,

You are missing the INTO TABLE since you have not indicated that you want to select a single record.

Regards,

Ryan Crosby

Re: SQL syntax issue when selecting from edid4

walkerist79 — Mon, 20 Mar 2023 15:11:17 GMT

ryan.crosby2 same issue with the "INTO TABLE @DATA(lt_edid4)."

Re: SQL syntax issue when selecting from edid4

RaymondGiuseppi — Mon, 20 Mar 2023 16:06:15 GMT

Any reason not to activate the 'fixed point arithmetic flag' in program attributes.

Re: SQL syntax issue when selecting from edid4

Sandra_Rossi — Mon, 20 Mar 2023 18:55:35 GMT

You can search the forum about what the "fixed point arithmetic flag" is. It's probably said at lots of places that it's highly recommended that the programs use it.

NB: it's fun that SAP forced the use of that flag when the program uses the Strict SQL Syntax, although it doesn't seem related at all.

Re: SQL syntax issue when selecting from edid4

Dominik_Tylczynski — Tue, 21 Mar 2023 07:39:53 GMT

Switch on "fixed point arithmetic" and it'll work fine. As per SAP Help https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abenfixed_point_arithmetic_glosry.htm

The disabling of this program attribute is obsolete.