‎2010 Jun 15 9:47 PM
Define lv_sql as stext. Say lv_sql = 'select * from table1 into lt_tab where ...'
how to execute lv_sql?
‎2010 Jun 16 2:57 AM
jacky,
break it down.. 2 3 strings..
'select' is not needed to be in the string...
direct write :
select (string1) into (string2) where (string 3)...
this line itself is executable...and how to make this!! searhc DYNAMIC SQL in SDN... you will find many wikis on this.
‎2010 Jun 15 9:53 PM
Sounds like dynamic programming. Check the help on GENERATE SUBROUTINE POOL.
Rob
‎2010 Jun 16 2:57 AM
jacky,
break it down.. 2 3 strings..
'select' is not needed to be in the string...
direct write :
select (string1) into (string2) where (string 3)...
this line itself is executable...and how to make this!! searhc DYNAMIC SQL in SDN... you will find many wikis on this.
‎2010 Jun 30 3:23 PM
This is exactly what i was looking for. Thank you guys so much!