How to convert select into native SQL

Former Member — Fri, 15 Aug 2008 07:40:35 GMT

Hi All

I have a requirement to convert crtain statments to Native SQL

select * from zabc into table it_zabc

where a in s_oa

and b in s_ob

and c ge date_time-datefrom

and d le date_time-dateto

and e in admin_st.

How to handle selct options in Native SQL

Re: How to convert select into native SQL

matt — Fri, 15 Aug 2008 08:22:56 GMT

Select options are internal tables with header lines. You'll have to got through each line in the table, and process it according to type.

So, say you have selopt S for field F.

If you've got S-SIGN = I, S-OPTION = BT, S-LOW = 1, S-HIGH = 3 that'll be an SQL where clause of F GE 1 AND F LE 3.

If you've got S-SIGN = E, S-OPTION = EQ, S-LOW = 1, that'll be an SQL where clause of F NE 1

You need to work out then what the appropriate SQL is for Including/Excluding for all the possible options - if you don't know what the options are then read the help on SELECT-OPTIONS.

matt

topic Re: How to convert select into native SQL in Application Development and Automation Discussions

How to convert select into native SQL

Re: How to convert select into native SQL