06-22-2017 1:33 PM
Hi,
I have the following SQL statement and was wondering if it is possible to rewrite it using the VALUE operator to avoid the DATA statement.
DATA(lv_initial) = VALUE /scwm/guid_hu( ).
SELECT * FROM /scwm/tu_dlv
WHERE lgnum = @lv_lgnum
AND top_hu = @lv_initial
INTO TABLE @DATA(lt).
I.e., I would like to have something like:
SELECT * FROM /scwm/tu_dlv
WHERE lgnum = @lv_lgnum
AND top_hu = @VALUE #( )
INTO TABLE @DATA(lt).
Is this possible? Any suggestions?
06-22-2017 2:03 PM
On 7.50 this should work:
SELECT * FROM /scwm/tu_dlv
WHERE lgnum = @lv_lgnum
AND top_hu = @( VALUE #( ) )
INTO TABLE @DATA(lt).
06-22-2017 2:03 PM
On 7.50 this should work:
SELECT * FROM /scwm/tu_dlv
WHERE lgnum = @lv_lgnum
AND top_hu = @( VALUE #( ) )
INTO TABLE @DATA(lt).
06-22-2017 8:15 PM
06-30-2017 7:33 PM
Thank you both! I was not aware of this. Unfortunately, I am working on release 7.40 at the moment, but at least I can stop searching now.